MsgBox Replacement w/ an UserForm

  • Thread starter Thread starter Chuckles123
  • Start date Start date
C

Chuckles123

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

End a procedure form a UserForm 3
End a procedure from a UserForm 1
SIMPLE UserForm w/ 2 OPTION BUTTONS 1
change color of command button problem 2
UserForm MsgBox problems 6
stringed userforms won't hide 6
Sum and Counta function in Listbox for UserForm 2
Class Modules and Userforms 3

Back
Top