Customize options in a MsgBox

  • Thread starter Thread starter Darrin Henry
  • Start date Start date
D

Darrin Henry

Hello,

I am in need of some assistance. I have to code a command button, when
the button is pressed, a msgbox need to popup. This is normally not a
problem, I can do it in my sleep. However, what I am unsure at to what
to do, is give the user three different buttons which I have to name.
And based on which button they push. I need to call a macro for it. I
know how to do the last part, it is just the msgbox I need help on.
Thanks.
 
You can't customize the names of a MsgBox without some serious subclassing,
you'll have to create a Form or if it's not a really professional thing do
something as follows.

Msgbox("Would you like to run Code A(Yes), Code B(No) or Code
C(Cancel)?",vbyesnocancel)

Then code as if msgbox=vbyes, vbno, vbcancel, etc.

gl,
Bodi
 
Back
Top