How to name a Combo Box
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: How to name a Combo Box

  1. #1
    Guest

    Default

     
    How do you name a combo box that has been created in a worksheet? I've been able to assign a range to the box, but I don't know how to assign a name to the object so that I can reference it in VBA.

    Thanks,
    Will

  2. #2
    Guest

    Default

    Will,

    If it's a forms control (which I think it is), then I don't think you can name it. You will have to use a visual basic control instead. Click view | toolbars | visual basic, then from the vb toolbar, select the combo box control (click the tools icon if it's not visible) and insert that instead of the the forms control. To rename the control, right click on the object and select properties. Change the name on the first line to whatever name you want for your combobox.

    Aloha!

  3. #3
    New Member
    Join Date
    Feb 2002
    Location
    ]-[ /-\ \/\/ /-\ | | ~~~@|_()]-[/-\!!!
    Posts
    48
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    (above post from me)

  4. #4
    New Member
    Join Date
    Mar 2002
    Posts
    24
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Thanks,
    That did the trick.

    Will

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