When you set any object to Nothing, you remove any memory usage or reserve
for that object, including its properties. You would have to re-establish
the item to use it again in that instance of the procedure.

"Tendresse" wrote:

Thanks for the clarification, guys. Much appreciated.

Another question if you don't mind. With:

Userform1.Show
Set Userform1 = Nothing

What does 'Set Userform1 = Nothing' do exactly? I saw it in one of the
threads and i'm using it everytime I 'show' a form but i don't know exactly
what would happen if I don't put it there. Are you able to shed some more
light on this one, please?
Thanks once more .. you guys are gems.
Tendresse