Clearing userform contents after saving to worksheet

I have a vba user form. The form has multiple combo boxes and text boxes. The first combo box is populated with the form's initialization. The second and third combo boxes are dependent; choices in the second combo box are based on Select case statements based on the first combox selection. The third combo box is similarly populated based on the second combo box selection. Based pm the selection of the third combo box selection, i have a vba lookup to populate several text boxes on the form.

Please Login or Register  to view this content.

Everything works fine until i save the form. After saving, i want to clear the form for re-entry. I have a cmdClear button with the following code:

Please Login or Register  to view this content.

This code clears nothing. Any suggestions would be useful.

upon the save button click at the very end you need to also call the cmdClear sub,

a potential issue that i see in your clearing macro is your not technically clearing the textbox or combo box, your just placing a blank space in there, instead of "ctrl.Text = "" " try using the ".Clear" command. which will reset the object instead of just retyping a blank.

Sorry, no change. Thank you for your suggestion.

can you attach the whole file?

Thank you, pointing out the typo, embarrassing as it is that i did not catch that, helps. I can now clear the combo boxes. But i do appear to have a logic problem. The vlookup function is triggered by the change event in combo box3, so when i clear that combo box, it is generating an error in efforts to clear the textboxes populated by the vlookup results.

Any suggestions on how i can structure an option to the Private Sub ComboBox3_Change()?

Please Login or Register  to view this content.

Excellent. I appreciate the help; problem is not solve.

The problem is NOW solved; typos abound. Thank you all.