Message Box with three options

  • Thread starter Thread starter Scott A
  • Start date Start date
S

Scott A

Hi. I never work with VBA so I am struggling with what is a very easy problem.

Upon opening a workbook, I would like to be prompted with three options:

1) Go to sheet "A"
2) Go to sheet "B"
3) "No"; basically quit and stay in the tab I am currently in

I currently have a Yes/No routine, but now I have another tab that I have
to consider going to.

Appreciate any help.
 
hi
for the built in message box, no. it does have multiple options like "OK",
"YES">"NO", "Abort">"retry">"Ignore". but these are not programable.
you would have better luck to create your own custom message box from a user
form using labels for the messages then put some code behind the labels to
"goto" the sheet selected.

regards
FSt1
 
Back
Top