Starting a Macro based on a ComboBox Result

  • Thread starter Thread starter 1Matt1
  • Start date Start date
1

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide columns based on row values 2
Lookup on a combo box 1
Access Combobox in Access Visible based on Checkbox 0
How do I Keep a Combo Box "Focused" on difrferent cells. 5
Use Combo Box value to determine macro used 1
Need Macro... 8
Run Macro on cell contents 1
Formula (off form) that completes form data based on a result 2

Back
Top