Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Before and after combo box change
I am not very good at VB at all, but in Access, with the
help of wizards, I seem to get around OK. My problem is in Excel 2000. I have created a combo box that works just fine. Now I need to have a macro run before the combo box change, then run another macro after the combo box change. As I said, in Access I can do this because of the various events listed in the properties box. But in Excel, I don't know where to start. I just assumed there would be a "Before Update" option for the combo box. I can't even find the code for the combo box itself. Please help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Before and after combo box change
It depends on which ComboBox. 1. From the Control Toolbox
toolbar and on a worksheet. 2. From the Forms toolbar and on a worksheet. 3. From the Toolbox and on a UserForm. Only #3 has a BeforeUpdate event procedure. For #1 access the code by double-clicking the control in design mode (toolbox open) or go to the VB Editor (menu Tool | Macro). For #2 right-click on the control with the toolbox open and click the little Edit Code icon. HTH, Merjet |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting Combo boxes to change options based on other Combo boxes. | New Users to Excel | |||
Change of behavior in Combo Box | Excel Discussion (Misc queries) | |||
Combo box range change | Excel Discussion (Misc queries) | |||
combo box on change code | Excel Discussion (Misc queries) | |||
Can I change the font size in a Combo Box ? | Excel Worksheet Functions |