Hi Everyone
I have searched the forum and this seems to be a recurring problem but I can't find a solution - any help please?
I am using a combo box on a user form which is populated using the RowSource property.
It functions OK. I need the same values to be available all the time i.e. Low, Med, High.
When the user form first runs the Combo box displays blank and allows the items to be selected using the drop down arrow - no problem - and this is what I want.
However when I '.Hide' the form and then call it back again (with '.Show') it still displays the last value.
How can I get the combo box to display blank again each time the user form is called?
I have tried .Clear and setting .Value all to no avail (presumably because it is pre-populated using RowSource?).....help please!
WTIA
barry
Bookmarks