Consulting

Results 1 to 2 of 2

Thread: Changing the Value of the ComboBox

  1. #1
    VBAX Contributor
    Joined
    Jun 2015
    Location
    Houston
    Posts
    111
    Location

    Question Changing the Value of the ComboBox

    Greetings & Salutations,

    I have a small problem. I am trying to create reset button for my Workbook. I have most the code figured out, but I have added ComboBoxes and am not very familiar with them.

    What I want to do is simply reset the value of the ComboBoxes to a certain value.

    For example: I have 13 of these boxes that are simply "Yes" or "No" boxes. I want to set them all to "No". when the reset button is selected.

    There are some other ComboBoxes with other values, but I mainly just need the starting point on how to change the value on any one of them.

    Thanks.

  2. #2
    VBAX Contributor
    Joined
    Jun 2015
    Location
    Houston
    Posts
    111
    Location

    Cool

    I figured it out.

    Dim strNo As String
    
    strNo = "No"
    
    With ActiveWorkbook
        .Worksheets("Project Info").ComboBox1.Value = strNo
        End With

Posting Permissions

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