Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Mar 2005
    Location
    Kent, England
    Posts
    138
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Identifying items on a ControlComboBox (Microsoft Excel 2003)

    I have created a toolbar which has a ComboBox with a list of items. What I need do to is to identify what item from the list the user has selected. Can anyone shed any light please?

    Cheers
    Jack

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Identifying items on a ControlComboBox (Microsoft Excel 2003)

    You can specify the name of a macro to run when the user selects an item by setting the OnAction property of the combo box.
    This macro can inspect CommandBars.ActionControl.Text to see which item the user selected.

  3. #3
    2 Star Lounger
    Join Date
    Mar 2005
    Location
    Kent, England
    Posts
    138
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Identifying items on a ControlComboBox (Microsoft Excel 2003)

    Many thanks Hans .... I had been fiddling around with Tag for ages without success.

Posting Permissions

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