I have multiple procedures; So i set up a master to call the sub procedures,
then I show a form to get user input and call more procedures. Clicking OK on
the form does not appear to trigger the cmdOK_button click event and write
the value to a cell on a temp worksheet, and worse, the master continues to
procedures 3 and 4 without the value from the form call; where did i go wrong?

sub master()
call procedure1
call procedure2
frmUserInput.show
call procedure3
call procedure4
end sub

headly,

Call Procedure3 and 4 from the form's terminate event.


sub NewMaster()
call procedure1
call procedure2
frmUserInput.show
end sub

Private Sub UserForm_Terminate()
call procedure3
call procedure4
End Sub

HTH,
Bernie
MS Excel MVP


"headly" wrote in message
...
I have multiple procedures; So i set up a master to call the sub procedures,
then I show a form to get user input and call more procedures. Clicking OK on
the form does not appear to trigger the cmdOK_button click event and write
the value to a cell on a temp worksheet, and worse, the master continues to
procedures 3 and 4 without the value from the form call; where did i go wrong?

sub master()
call procedure1
call procedure2
frmUserInput.show
call procedure3
call procedure4
end sub