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.
|