Starting a Macro based on a ComboBox Result

[1Matt1]

Hi,

I have a spreadsheet with a Combo Box that allows a user to selec
either a Percentage, Dollar or Volume view of a report. VLookups
Offsets are used so that the selected result is displayed in the sam
cells each time.

I need to reformat these cells to either Percentage/Currency or Numbe
depending on the combo box selection. I see a macro as the easiest wa
to do this.

How can I start a macro based on the result of the combo box?

Thanks!

Mat

 

[Ron de Bruin]

Hi Matt

If you have combobox from the controltoolbox on your sheet then
put your code in the change event of the control.

Private Sub ComboBox1_Change()

End Sub