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: 542
Default UserForm Visibility question

Hi All,

Probably a simple question. I have 2 Userforms (DataPlate & Status). I want
to hide the DataPlate and show the Status form vbModeless. All works fine but
the Dataplate does not hide, it is still in the background when the status
form is shown. Ive tried Dataplate.repaint, setting up a delay, nothing
works. How do i get it to hide like I want? thanks.

Private Sub CommandButton1_Click()
Application.ScreenUpdating = True
DataPlate.Hide
Status.Show vbModeless
Status.Repaint
'do stuff here
end sub
 
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
UserForm Question Stockwell43 Excel Discussion (Misc queries) 0 October 27th 08 01:02 PM
Add-In Visibility Trent Argante Excel Discussion (Misc queries) 5 February 13th 08 08:01 PM
userform question Peterke Excel Programming 0 March 25th 06 07:23 PM
UserForm Question Tempy Excel Programming 2 May 19th 05 11:04 AM
Visibility Gordon[_12_] Excel Programming 4 January 9th 04 08:04 PM


All times are GMT +1. The time now is 03:22 PM.

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

About Us

"It's about Microsoft Excel"