PDA

View Full Version : How to clear a userform after completion



enfantter
09-14-2007, 05:04 AM
Hey all,

I have a userform which contains listboxes and textboxes which can be filled out by the user.
When it is carried out a data in the excelsheet is filtered.
Now, I want to clear the selections after the userform is completed.
Can anyone help?!

/JackJackJack

Bob Phillips
09-14-2007, 05:57 AM
If you Unload the form, next time it is loaded it will be clear.

enfantter
09-14-2007, 06:05 AM
Super!
Is that like userform.unload??

enfantter
09-14-2007, 06:09 AM
sorry just found out - thx!!

Bob Phillips
09-14-2007, 06:09 AM
Not quite


Unload Me