Jagat Pavasia
Active Member
- Joined
- Mar 9, 2015
- Messages
- 359
- Office Version
- 2021
- Platform
- Windows
I had insert COMBO BOX (ActiveX Control) in my sheet.
Now, when i drop down list and select any name from drop down list then linked cell is "B1" displayed result very well.
But, I have another formula in D1 and E1 is related to B1.
so my D1 and E1 did not changed, but when I click any other cell than it is working.
so, I would click every time after drop-down selection to get result in D1 and E1
have any idea for VBA code ?
please help me.
I have insert image below, please find it and help me
Now, when i drop down list and select any name from drop down list then linked cell is "B1" displayed result very well.
But, I have another formula in D1 and E1 is related to B1.
so my D1 and E1 did not changed, but when I click any other cell than it is working.
so, I would click every time after drop-down selection to get result in D1 and E1
have any idea for VBA code ?
please help me.
I have insert image below, please find it and help me