• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

clear combo box when click on a button

Netsy

New Member
in attached excel,
when click on clear button the country selected in the display combo box should be set to blank and when click on the arrow the list of countries should be displayed.
the list of values should not be deleted.

Ive added but its does not clear the display value.
ComboBox1 = ""

Can you please help how to make that works?
 

Attachments

  • test_autocomplete.xlsm
    25.8 KB · Views: 10
Last edited:
How about
Code:
Sub Button3_Click()
   With Sheets("Sheet1")
       .ComboBox1.Value = ""
       .Range("E8:F9").Value = ""
   End With
End Sub
 
The initial code well works as it is if it's moved to the worksheet module !​
Or in its actual standard module :​
Code:
Sub Button3_Click()
    Sheet1.ComboBox1 = "":  [E8] = ""
End Sub
Do you like it ? So thanks to click on bottom right Like !​
 
Back
Top