Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform.Activate
Hi all, Firstly thanks to everyone who has answered my
questions of the last few days !!! I have a userform that has some code in the activate event, this looks at a value in sheet1.range("A1") and uses this to scan along a data table and fill in some textboxes, this all works fine, but when i use the userfrom1.hide option, then change the value on sheet 1, then use userfrom1.show again, it appears to be still using the old value, is this becase Im not really unloading the form but simply hiding it from view ? if so whats the correct way to unload the form so that it clears the data from the form.activate event ? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform.Activate
Neil,
Unload UserForm1 John Neil wrote: Hi all, Firstly thanks to everyone who has answered my questions of the last few days !!! I have a userform that has some code in the activate event, this looks at a value in sheet1.range("A1") and uses this to scan along a data table and fill in some textboxes, this all works fine, but when i use the userfrom1.hide option, then change the value on sheet 1, then use userfrom1.show again, it appears to be still using the old value, is this becase Im not really unloading the form but simply hiding it from view ? if so whats the correct way to unload the form so that it clears the data from the form.activate event ? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform.Activate
Use this to unload the userform
Unload userform1 -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Neil" wrote in message ... Hi all, Firstly thanks to everyone who has answered my questions of the last few days !!! I have a userform that has some code in the activate event, this looks at a value in sheet1.range("A1") and uses this to scan along a data table and fill in some textboxes, this all works fine, but when i use the userfrom1.hide option, then change the value on sheet 1, then use userfrom1.show again, it appears to be still using the old value, is this becase Im not really unloading the form but simply hiding it from view ? if so whats the correct way to unload the form so that it clears the data from the form.activate event ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't activate an add-ins | Setting up and Configuration of Excel | |||
activate a page of a Multipage in Userform | Excel Discussion (Misc queries) | |||
Run Code On Activate | Excel Worksheet Functions | |||
Password userform activate | Excel Discussion (Misc queries) | |||
When to Activate? | Excel Discussion (Misc queries) |