UserForm Visibility question

  • Thread starter Thread starter James
  • Start date Start date
J

James

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
 
Let us know in which form your commandbutton1 is placed..

If this post helps click Yes
 
I do not believe it is the code that is causing it. I could not duplicate
the condition in a test set up.
 
Tried the same scenario and it is working.. Please check the other events
around this...

If this post helps click Yes
 
ya, it works fine if i make a testbook. The only time I could get it to work
was when i put Me.Hide in the MouseUp event. but in this case, all the
controls seem to have been unloaded. I actually set a public variable (a
string) in a previous subroutine and it cleared the variable (= ""). huh? im
stumped. I guess i can live with it in the background. Thanks everyone for
your help, this site is great
 
Back
Top