How to run code on ComboBox Selection 1

[attrofy]

In Excell 2000, I have some code assigned to acontrol buttons. Instead of buttons, I would like to have a drop down box of choices.

I understand I could create a range of cells with the drop down choices (i.e. A1:A5 would have the name of 5 functions, and this range could be name Code_Select) then let the user select the code needed from the combo box.

Is there someway to set cell B2=Code_Select, then run the code selected?

I am pretty new to all the VBA, please state which event to put the code in, as well as some sample syntax would be greatly appreciated.
TIA,
RUssell

 

[BlackburnKL]

Check out the Click event of your ComboBox. That event is fired when a selection is made. BlackburnKL

 

[attrofy]

NOt quite what I had intended, but it worked none-the-less. I hadn't planed on using a Control, rather just the Validation to create the list, but this worked ok. THanks for your input.