Activex COMBO box drop down list help

[Jagat Pavasia]

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

 

[EXCEL MAX]

Hello Jagat,
try to turn on Calculculation option to "Automatic".

 

[Jagat Pavasia]

Hello Jagat,
try to turn on Calculculation option to "Automatic".

Dear EXCEL MAX,
The calculation is always automatic on my work book. I never change it to manual.

In my case, for example I have formula "=sum(B1+M6)" in D1 cell. (M6 have fix value).

Where B1 is linked cell from activex control combo box.
So, whenever i select any value from combo box list then the answer is not coming out in D1.

The answer is coming when i click mouse to any other cell.

I want instant answer without click any where.

 

[EXCEL MAX]

Did you try to create new combobox with default properties and then to repeat connecting with linked cell?
Did you try to do in the new workbook?
Does your workbook have some VBA code?

 

[Jagat Pavasia]

Did you try to create new combobox with default properties and then to repeat connecting with linked cell?
Did you try to do in the new workbook?
Does your workbook have some VBA code?

Yes, problem solved.

Thanks

 

[EXCEL MAX]

I'm glad that you are solved a problem.