Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Switching userfoms
Perhaps you could establish a global variable which the activate event
checks before it executes the growth code. Have userform2 set the variable to prevent the growth. -- Regards, Tom Ogilvy "nath" <n@n wrote in message ... Hi I have a userform, userform1 that when selected to be opened, opens the form with it rising from the centre of the screen. There are various controls on this form, where one is a button to see a financial year week number by clicking a date on the calendar. The calendar is on userform2, which shows fine. However when i close userform2, even though userform1 is still visible, it still runs the code to make the form extend. I have used the UserForm1_Activate for this "growth" code. It has to appear in this way. Dows anybody know how to just switch between the forms rather than deactivate them i am using userform2.show when the button is clicked. TIA Nath. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Switching Text | Excel Discussion (Misc queries) | |||
Lists Switching | Excel Discussion (Misc queries) | |||
switching the worksheet? | Excel Discussion (Misc queries) | |||
Switching Information | Excel Discussion (Misc queries) | |||
switching between modes | Excel Discussion (Misc queries) |