Saving value on worksheet from userform combobox

Hi All, I am having difficulty trying to save a value selected from a UserForm1 VendorCombobox to a worksheet. Scenario is when vendor is selected from the combobox, the value is copied to worksheet (Report). UserForm is still initialized and I would like for the combobox to return to blank after selection has been made with a slight delay (wait). Issue is only way I can clear the textboxes and combobox on userform is to use value = "". This causes the value on worksheet report to be cleared also.What am I missing or is this the wrong approach?

Please Login or Register  to view this content.

Hi Mehmetcik, thank you for the quick reply. I just tried the Flag solution. Didn't work but I could be placing the Dim in wrong place. You have it above the Private Sub VendorComboBox. I am assuming it goes underneath the sub, that didn't work. Also tried UserForm_Initialize sub with Dim. Neither seems to work.

THAT WORKED!! thank you so much.