Delete or Clear RowSource

[mtroche]

How do I delete or clear a rowsource from a combobox? I have a userform called "A" and a combobox called "B". I am trying to use this command, but it doesn't works:

A.B.RowSource = " "

Any suggestion will be very helpful because I have no idea on how to do that.

Att.
MTroche

 

[onlyadrafter]

Hello,

When do you want to clear the combobox. The following code will clear it when the userform is activated.

Private Sub UserForm_Activate()
B.RowSource = ""
End Sub

Does this suit your needs or not?



----------------------------------
Hope this helps.
----------------------------------

maybe only a drafter
but the best user at this company!