Before and after combo box change

  • Thread starter Thread starter Dale
  • Start date Start date
D

Dale

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.
 
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
 
Back
Top