My 'Yes-No' MsgBox is currently in the middle of my procedure.
Depending upon user selection, either of two sections of code i
accessed. I want to replace this MsgBox with a 2-button UserForm.
am looking for guidance on how to transfer control from the mai
procedure to the UserForm and then back to the main procedure.

Chuckles12

--
Chuckles12
-----------------------------------------------------------------------
Chuckles123's Profile: http://www.excelforum.com/member.php...fo&userid=1494
View this thread: http://www.excelforum.com/showthread.php?threadid=26787

Why? Want do you want to do that the MsgBox doesn't do?

As to the actual question, create a public variable, say 'ans', in a
standard code module, and then in the form, set this according to the button
selected, and after unloading the form, test this variable.


--

HTH

RP

"Chuckles123" wrote in message
...

My 'Yes-No' MsgBox is currently in the middle of my procedure.
Depending upon user selection, either of two sections of code is
accessed. I want to replace this MsgBox with a 2-button UserForm. I
am looking for guidance on how to transfer control from the main
procedure to the UserForm and then back to the main procedure.

Chuckles123


--
Chuckles123
------------------------------------------------------------------------
Chuckles123's Profile:
http://www.excelforum.com/member.php...o&userid=14948
View this thread: http://www.excelforum.com/showthread...hreadid=267872