I was wondering if it is possible to change the text of buttons on message boxes. I currently use the constant vbYesNo which works great but to increase usability it would help if I could replace 'Yes' with something like 'View Data' and 'No' with 'Add More'. Does that make sense? I don't want to change the functionality of the message box, I only want to replace the button text. Is this possible? Thanks in advance for any help.
'sample code I currently use
strMessage = "Successfully Saved to Database."
intResponse = MsgBox(strMessage, vbYesNo + vbInformation, "Saves Complete")
If intResponse = vbNo Then
'do something
elseif intResponse = vbYes then
'do something else
end if
'sample code I currently use
strMessage = "Successfully Saved to Database."
intResponse = MsgBox(strMessage, vbYesNo + vbInformation, "Saves Complete")
If intResponse = vbNo Then
'do something
elseif intResponse = vbYes then
'do something else
end if