View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
James James is offline
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