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 ? |
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) |