Excel VBA Code - ComboBox Change

[johntacon]

I need to run a workbook in manual calculate.

But I want to know if there is a VBA code (and where to put it) that would make the 'active sheet' calaculate whenever a (new) combo-box selection is made.

John

 

[Mennokie]

Combobox ChangeCombo Box change

Hello,

I Just leanred an easy way to do this :

Sub Combobox1_Change()

call ActivesheetCalcluateProcedure

End sub

Sub ActivesheetCalculateprocedure ()

Avtivesheet.Calculate

End Sub

Each time your combobox value changes, the procedure That calculates your activesheet values gets called.

Hope it helps

Cheerios

 

[johntacon]

Hi Mennokie

Many thanks for this code. It looks great. I will try today. But I presume you have to do one code for each combobox - is that correct ... or will this work for multiple boxes on one sheet?

Also, can you advise how I can cause the active sheet to calculate whenever data is entered in Excel cell and user presses enter (when Workbook is in Manual Calculate mode)?

Regards - John