Thread: Before and after combo box change
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
merjet merjet is offline
external usenet poster
  
Posts: 812
Default 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 With QuoteReply With Quote