in sheet "KP"
i want sum of the range btween "H2:H10 in
sum in cell "H11" (range H2:H10)
vat 4% cell "H12" (H11*4/100)
add.vat 1% cell "H13" (H11*1/100)
G.Total cell "H14" (H11 + H12 + H13)
by the worksheet selection change event macro
sum with selection change event
- krpatel
- Thread is marked as Resolved.
-
-
Re: sum with selectin change event
Hello,
If, as a first step, you type in all your formulas ...
You will not need to have an event macro ... :wink:
-
Re: sum with selectin change event
I did not put manuyly formula
only selection change event -
Re: sum with selectin change event
Hello again,
You should type in your formulas ... and everything will work ...
-
Re: sum with selectin change event
dear
i do not put formula manulay i do this only vba macro by selection change envent only -
-
Re: sum with selectin change event
Hello,
Difficult to understand your request ...!!!
Attached is your file ... with a proposal ...
Hope this will help
-
Re: sum with selectin change event
Hello,
Why ... no answer ???
-
Re: sum with selectin change event
ok
sir
i solve my prbobelm
thanku very much -
Re: sum with selectin change event
Glad you could solve your problem ...
-
Re: sum with selectin change event
Yes, he solved his problem on MrExcel and Chandoo... in other words, people on 3 forums running around just for him. That's how to do it.
-
-
Re: sum with selectin change event
Quote from Grimes0332;788447Yes, he solved his problem on MrExcel and Chandoo... in other words, people on 3 forums running around just for him. That's how to do it.
Thanks for pointing this out ...!!! :wink:
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!