Userform direction
Thanks for the explanation
"Alan" wrote:
If the two are stacked, you are not unloading your Userform1 before showing
Userform 2.
If you are not unloading Userform1 then I presume you are using Userform1 to
load Userform2 to get data to fill Userform1. (If not, then you are going
about this all wrong.) To regain focus on Userform1 you must have change
event code in Userform2 that populates the data into Userform1 then closes
Userform2. This will allow Userform1 active to continue. I like to place an
OK button on a userform to use that to fill data, open and close Userforms.
Me.Hide, will hide Userform1 till you call it to show in your Userform2
change event.
Regards,
Alan
"Curt" wrote in message
...
says it can't show all ready displayed. userform 2 is called from 1 and
does
apear on top of 1
Curt
"merjet" wrote:
Put this in Userform2's code module.
Private Sub UserForm_Terminate()
UserForm1.Show
End Sub
Merjet
|