Change Caption of MSG BOX buttons from Yes No to....

[bitech]

I would like to change the message box buttons to say something else.... right now, they say "Yes" "No" "Cancel"

I would like for them to say

"All" "Current Year" "Cancel"

Is this possible? I'm afraid I'm going to have to make my own message box using a form.

 

[GingerR]

i think you'll have to make your own form. look in HELP for MsgBox Function and it will tell you the diff buttons available.

you could use an input box instead, then you could have it say, i.e.

"Which do you want? A = All, C = Current Year"

there are OK and CANCEL buttons automatically
you can set the default answer to be A (or whichever makes more sense)
then the user only has to type a C which is a small thing to have to do

g

 

[andylec]

Have a look at planet-source-code.com. In the Visual Basic section search for "messagebox hack". I haven't personally tried it,but it looks like it should do what you require.