Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Private Sub CommandButton2_Click()
UserForm1.Hide UserForm2.Show Application.ScreenUpdating = False Application.ScreenUpdating = True End Sub Private Sub CommandButton2_Click() UserForm2.Hide UserForm1.Show Application.ScreenUpdating = False Application.ScreenUpdating = True End Sub -- Regards, Tom Ogilvy "Laurin" wrote in message ... I have two userforms in my program. I set it up so that clicking on a command button on userform1 hides userform1 and shows userform2. Userform2 is set up in the same way such that clicking on a commandbutton will hide userform2 and show userform1. the problem is that the userforms are not the same size. Userform2 is wide and short while userform1 is tall and skinny. And when I hide a userform and show the other userform (via the command buttons) you can still see the hidden userform behind the userform being shown. In other words the userforms are not really being hidden. I've set application.screenupdating to true thinking that might be the problem but it isn't. Here is the code in userform1: Code: -------------------- Private Sub CommandButton2_Click() UserForm1.Hide UserForm2.Show End Sub -------------------- And the code in userform2: Code: -------------------- Private Sub CommandButton2_Click() UserForm2.Hide UserForm1.Show End Sub -------------------- -- Laurin ------------------------------------------------------------------------ Laurin's Profile: http://www.excelforum.com/member.php...o&userid=26832 View this thread: http://www.excelforum.com/showthread...hreadid=494931 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |