View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default UserForm Visibility question

Tried the same scenario and it is working.. Please check the other events
around this...

If this post helps click Yes
---------------
Jacob Skaria


"James" wrote:

It is in the DataPlate Userform

"Jacob Skaria" wrote:

Let us know in which form your commandbutton1 is placed..

If this post helps click Yes
---------------
Jacob Skaria


"James" wrote:

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