Close a combo box with vba code

Question

I am using Excel 365. I open a combo box with vba code when there is a certain value in a worksheet range with this code:

cmbccVnd.DropDown

The combobox is a field on a form. The fields on the form are saved by VBA code to a work sheet and then cleared. The problem is that the list portion of the combo box is still displayed when the save routine is finished running.

Is there any way to not display the list items of the combo box ?

Answer 1

The code works fine for me.... are you fully updated?

Answer 2

Thanks Snow Lu MSFT but that does not work. I have tried that before this post and tried it again. Each time I get an "Unspecified Error -2147467259 (80004005

Answer 3

Thanks Bernie but that does not work. I have tried that before this post and tried it again. Each time I get an "Unspecified Error -2147467259 (80004005)

Answer 4

Hi Alex,

Greetings! Thank you for posting to Microsoft Community.

Here is a sample to run the main code and then clear the list item in Combox1.

=========================

Private Sub ComboBox1_Click()

'Main code

Me.ComboBox1.Clear

End Sub

=========================

Best Regards,

Snow Lu

Answer 5

Use code like this in the userform code to just clear the selection

me.cbComboBoxName.Value = ""

This will clear both the entry and the list:

me.cbComboBoxName.Clear