activex combo box on excel sheet
activex combo box on excel sheet
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: activex combo box on excel sheet

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    255
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    If I view the forms toolbar and pick a combobox and put it on a worksheet, how do I find it's name? Also, does it show up somewhere in the VB Editor environment? Can I set properties for it?

    Dave

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Fort McMurray, AB
    Posts
    218
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm not sure what you want to know.

    If you put a combobox in your spreadsheet, rick-click on it and you'll see "Format Control" on the pop-up menu.

    Select it, and head to the Control tab, where you'll see the various controls for this box. For example, you may want someone to choose from one of 50 states; write the 50 states down a column, and then when you set up your combobox, you'll set the input range to pick up the range that contains the states; now, when someone clicks on the combobox, they can select one of the states when it pulls down.

    There are other fun things you can do with comboboxes, but let me know if this is in the direction of info you needed to begin with.
    Regards, Duane
    Office2010 in Win7

  3. #3
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Dave

    If the ComboBox is from the Forms toolbar it's not an ActiveX control (Control toolbar is). To see the name though, just select it and look in the "Name Box" (left of formula bar). You can also rename it here,

    _________________
    Kind Regards
    Dave Hawley
    OzGrid Business Applications
    Microsoft Excel/VBA Training


    [ This Message was edited by: Dave Hawley on 2002-04-02 20:40 ]

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    255
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Thanks guys, I'm beginning to understand this better. But I don't understand what the difference is between the controls on the forms toolbar and the ones on the controls toolbar. How are these different from what you'd put on a userform? Do they still support the same properties and methods as a combobox on a userform?

    Dave

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com