Changing the Name of the vbYesNo buttons

[chris3366]

Would anybody know how to change the text of the buttons of a msgbox? I want a 2 choice set up. But I don't want just a yes or no. This is what I have now.

Dim strPrompt As String, strStyle As String, strTitle As String
Dim varPress As Variant
Dim varPress1 As Variant

strPrompt = "Is this Project Review Complete?"
strStyle = vbYesNo
strTitle = "Project Review"

varPress = MsgBox(strPrompt, strStyle, strTitle)

This works but I would prefer a more customize text.

This then gets passed through an "If/Then" based on choosing yes or no.

Any help is always appreciated.

Thanks.

 

[MajP]

I have seen some pretty involved windows API code to do this. Or you could simply spend five minutes and build a custom form.

 

[Andrzejek]

This works but I would prefer a more customize text

So, what would you like to have?
Give an example, please.

Have fun.

---- Andy

 

[chris3366]

I just wanted more than a yes or no. It isn't crucial or vital. Jut something to make the user be more careful which button they click. But we all know that will never happen.

Thanks Guys!!

 

[MajP]

There are a few more options built in

vbOKOnly 0 OK button only (default)
vbOKCancel 1 OK and Cancel buttons
vbAbortRetryIgnore 2 Abort, Retry, and Ignore buttons
vbYesNoCancel 3 Yes, No, and Cancel buttons
vbYesNo 4 Yes and No buttons
vbRetryCancel 5 Retry and Cancel buttons