Excel VBA Code - ComboBox Change

J

johntacon

Joined
Jun 7, 2005
Messages
2
Reaction score
0
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
 
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
 
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
 
Back
Top