Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Difference between Userform Activate and Initialize | Excel Programming | |||
.Activate vs. .Select in VBA | Excel Discussion (Misc queries) | |||
Select OR Activate ? Which when and Why? | Excel Programming | |||
select vs. activate | Excel Programming | |||
select vs activate | Excel Programming |