Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
userforms showing and hiding
I have two userforms in my program. I set it up so that clicking on command button on userform1 hides userform1 and shows userform2. Userform2 is set up in the same way such that clicking on commandbutton will hide userform2 and show userform1. the problem is that the userforms are not the same size. Userform2 i wide and short while userform1 is tall and skinny. And when I hide userform and show the other userform (via the command buttons) you ca still see the hidden userform behind the userform being shown. I other words the userforms are not really being hidden. I've se application.screenupdating to true thinking that might be the proble but it isn't. Here is the code in userform1: Code ------------------- Private Sub CommandButton2_Click() UserForm1.Hide UserForm2.Show End Su ------------------- And the code in userform2: Code ------------------- Private Sub CommandButton2_Click() UserForm2.Hide UserForm1.Show End Su ------------------- -- Lauri ----------------------------------------------------------------------- Laurin's Profile: http://www.excelforum.com/member.php...fo&userid=2683 View this thread: http://www.excelforum.com/showthread.php?threadid=49493 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro showing and hiding detail | Excel Discussion (Misc queries) | |||
Showing and hiding series in charts | Excel Discussion (Misc queries) | |||
hiding and showing graphs | Excel Worksheet Functions | |||
Hiding Userforms | Excel Programming | |||
Showing and hiding columns | Excel Programming |