Userform Wait Before Showing Next Form

[Jaye7]

Can anyone please help with the following.

I have 4 forms which all open when I run a script, for each form that opens in the userform activate code it then runs a script which removes the forms caption.

The problem I am having is that it is only removing the first form that executes caption, even though I have a remove caption call method in each userform activate event.

If I have 4 scripts, 1 script to open each form then it works fine however I can not combine the scripts to make one call event.

ie. I can run the following individually

Sub U1()
call userf1 ' which will call userform1
end sub

Sub U2()
call userf2 ' which will call userform2
end sub

Sub U1()
call userf3 ' which will call userform3
end sub

Sub U1()
call userf4 ' which will call userform4
end sub

however if I combine them into one script it does not work ie.

Sub U5()
call userf1
call userf2
call userf3
call userf4
end sub

Is there a method that will wait until the form is completely displayed before it then runs the next call method.

I have tried application.wait but it doesn't work.


.

 

[Leith Ross]

Hello Jaye7,

I suspect your problem is the UserForm.ShowModal property is set to True. This allows only one UserForm to have the focus.

Sincerely,
Leith Ross

 

[Jaye7]

Unfortunately all the forms lock to the screen as toolbars.

Thanks anyway.