Results 1 to 7 of 7
  1. #1
    Join Date
    Jan 2004
    Posts
    17

    Unanswered: combo box txt size

    how do you change the size of the text in a combo box?
    Ben

  2. #2
    Join Date
    Dec 2003
    Location
    San Diego, CA
    Posts
    153
    If it's a Forms ComboBox, you don't. Increasing screen zoom is about it.

    If it's a Control Toolbox ComboBox, select Properties-->Font and adjust from there.

    Hope that helps,

    Smitty

  3. #3
    Join Date
    Jan 2004
    Posts
    17

    Question

    Control Toolbox ComboBox is what i need. but im not sure how the information is inputted into the combo box ? ? ? please help!
    Ben

  4. #4
    Join Date
    Dec 2003
    Location
    San Diego, CA
    Posts
    153
    Are you using a UserForm or are your controls placed directly on the spreadsheet?

    Either way, ActiveX controls (those created from the Control Toolbox) have their own VBA code associated with them. In Design mode, double click the control and VBA will open with:

    Private Sub ComboBox1_Change()

    End Sub

    From there, look at the AddItem Method for populating the combo Box. I.E.

    Code:
    Private Sub ComboBox1_Click()
        With ComboBox1
            .AddItem "Office 1"
            .AddItem "Office 2"
            .AddItem "Office 3"
            .AddItem "Office 4"
            .AddItem "Office 5"
        End With
    End Sub
    
    Private Sub ComboBox1_Change()
        '  Return the selection to the worksheet
        Range("B1") = ComboBox1
    End Sub
    Hope that helps,

    Smitty

  5. #5
    Join Date
    Jan 2004
    Posts
    17
    hi again!
    do you think you could create an example because i cant get it to work. thank you..
    Ben

  6. #6
    Join Date
    Dec 2003
    Location
    San Diego, CA
    Posts
    153
    Here's an example of a Control Toolbox ComboBox, a Forms ComboBox and a User Form ComboBox.

    Hope that helps,

    Smitty
    Attached Files Attached Files

  7. #7
    Join Date
    Jan 2004
    Posts
    17
    Originally posted by Smitty
    Here's an example of a Control Toolbox ComboBox, a Forms ComboBox and a User Form ComboBox.

    Hope that helps,

    Smitty
    thank you this is a great help

Posting Permissions

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