user form issues

[Steve]

morning all.
I've created a user form and while it's getting close to what I want, I'm
noticing that when I go to access it a subsequent time after, the combo box
fields are still populated from my previous use.

How do I prevent this from occurring?
In my code I have Me.Hide, which acts to close the form.
I don't however see anything close to the idea of
me.depopulateformfieldsonclose, or me.emptyformfieldsonclose.

Thank you.
Oh-- this is the first form that this has happened to, and I've made 7 other
forms-- albeit this is my first with combo boxes.
Best.

 

[r]

unload me

regards
r

Il mio ultimo lavoro ...
http://excelvba.altervista.org/blog/index.php/Excel-VBA/UsedRange-eccezioni-e-alternative.html

 

[Jacob Skaria]

Instead of Me.Hide unload the form and load as and when required

'To unload
Unload UserForm1

' To load
Load UserForm1
UserForm1.Show

If this post helps click Yes

 

[Steve]

Unload me it is then....
That appears to have worked-- thank you both R, and Jacob.