Sum a range in textbox1 only after one highlihted cell to other highlighted cell

[HaroonSid]

hi,
i want to sum a range (show sum in textbox1) after one highlighted cell to other highlighted cell

for example

if i select a cell with my mouse click B5 then textbox1 show the some of b2:b11 = result 58

if i select a cell b18 then textbox1 show the sum of b12:b16 = result 94


if i select a cell b19 then textbox1 show the sum of b17:b20 = result 80

hope some one will help
Capture.JPG
2.JPG

[YasserKhalil]

Hello .. try this code in worksheet module

Please Login or Register  to view this content.

[HaroonSid]

Master Peace
Thank you Very Very Much @ YasserKhalil

[YasserKhalil]

You're welcome. Glad I can offer some help
Best Regards