Altering buttons on MsgBox

[tbirdcarl]

I have a message box and I what to know the amount of doors the cabinet has.

However, I don't know how to change the button options from yes and no
I would like the options to be "One" and "Two"

Door_message = MsgBox("how many doors does the cabinet have", vbYesNo)
        If Door_message = 6 Then
        'insert the single door to the cabinet
        ElseIf Door_message = 7 Then
        'insert the double door to cabinet
        End If

 

[VoG]

You would need to use a userform or an add-in like ktMsgBox http://www.h3.dion.ne.jp/~sakatsu/ktMsgBox_Series_English.htm

 

[Sthrncali]

You would need to create a userform that mimicks a vba msgBox.

Search Google - VBA Userforms for help on creating if your not familiar.

 

[tbirdcarl]

Thanks for getting back to me so fast. I am going to mess around with the userform. I'll let you know how it goes.

Thanks again

 

[Tom Urtis]

You do not need a userform, you can do this either with an API message box as shown here:
http://www.mrexcel.com/forum/showthread.php?t=266194

or with a dialog sheet as shown here:
http://www.mrexcel.com/forum/showthread.php?t=331888

 

[tbirdcarl]

Ended up going with the userform
Perfect

I've only been doing VB excel coding for about 3 days now so the long code kinda freaked me out.