Results 1 to 3 of 3
  1. #1
    Azri1
    Guest

    Data validation / combo box...

    Can I run macros when I select on a combo box or data validation drop down.thanks.ie.I have a data validation
    /combo box at cell A1..when I choose any option at the dv/combo box..the macro that I selected will runs..thanks

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Data validation / combo box...

    You can have a macro run when a ComboBox from the Control Toolbar (ActiveX) is used. These Macros are triggered when you do something to the ComboBox, Change, click etc. Which one you use depends on what you want to do. You can also assign one macro to a ComboBox from the Forms Toolbar. You cannot assign a macro to a Data Validation control, as far as I know.

    Andrew

  3. #3
    Azri1
    Guest

    Re: Data validation / combo box...

    thanks for the explanation Andrew..

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •