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
---------------
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

I do not believe it is the code that is causing it. I could not duplicate
the condition in a test set up.


"James" wrote in message
...
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

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

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

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



"JLGWhiz" wrote:

I do not believe it is the code that is causing it. I could not duplicate
the condition in a test set up.


"James" wrote in message
...
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