Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Macros and combo boxes

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I used to use macros but its been awhile and I have forgotten the basics. Can anyone tell me the code for a basic combo box?
    Thanks for your help!
    Jill

  2. #2
    New Member
    Join Date
    Apr 2002
    Location
    Milwaukee, WI
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I used to use macros but its been awhile and I have forgotten the basics. Can anyone tell me the code for a basic combo box?
    I believe that combo boxes can only be placed on userforms. You have to design the userform and create code to load and display the form. I don't think a combobox can be brought up any other way.

  3. #3
    New Member
    Join Date
    Feb 2002
    Location
    McKinney Texas
    Posts
    6
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    You can add a combo box to a spreadsheet without using a user form. You can select it from the Visual Basic menu. If you right click on the top menu, you can select it here, or go to VIEW-TOOLBARS and select VISUAL BASIC. Here is a macro that you can adjust and use that will add a combo box:

    Sub AddBox()

    ActiveSheet.OLEObjects.Add(ClassType:="Forms.ComboBox.1", Link:=False, _
    DisplayAsIcon:=False, Left:=240.75, Top:=65.25, Width:=94.5, Height:= _
    12.75).Select
    Application.CommandBars("Control Toolbox").Visible = False
    End Sub

    [ This Message was edited by: Scott on 2002-04-16 15:03 ]

Some videos you may like

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
  •