Delete or Clear RowSource
Delete or Clear RowSource
(OP)
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
A.B.RowSource = " "
Any suggestion will be very helpful because I have no idea on how to do that.
Att.
MTroche





RE: Delete or Clear RowSource
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!