ActiveX ComboBox

[txfink]

I'm not really sure how to do this, but I'm sure there is a relatively simple way for some of you all who know this stuff better than I do. So here is where I'm at and where I'm trying to go. I'm looking for any input on how to get there.

I have two worksheets, called 'Input' and 'Calculations'.

The 'Input' sheet has a series of ActiveX combo boxes. The user will select an option, which results in a value being placed in specific cells on sheet 'Calculations'.

I need some code to run anytime one of these combo boxes are changed.

There are two ways I can think of to accomplish this - I don't know how to do either. I can (1) initiate the code when the combo box on sheet 'Input' changes or (2) initiate the code when the target cell on sheet 'Calculations' changes.

I'm sure there are others - I'm open to any suggestions. Appreciate the help.


SMF

 

[strongm]

Right-click the combobox, select View Code from the menu, and it should drop you straight into the Combobox_Change event handler in the VBA IDE

If you want to know about what code to put in there then you'll probably be better off in forum707