LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
macro showing and hiding detail KC Excel Discussion (Misc queries) 1 October 20th 09 07:56 PM
Showing and hiding series in charts Matt H Excel Discussion (Misc queries) 2 February 28th 08 10:14 PM
hiding and showing graphs chrisrowe_cr Excel Worksheet Functions 0 September 2nd 05 11:22 AM
Hiding Userforms CeeKay Excel Programming 3 November 10th 04 01:53 AM
Showing and hiding columns BatMan Excel Programming 1 July 21st 04 06:11 PM


All times are GMT +1. The time now is 12:54 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"