Change "Name" within Command Button

[golf4]

Hi, everyone -

I think I've seen this addressed a while ago, but couldn't find it with the Search option.

I have a number of command buttons, within my worksheets, that I use to print the worksheets. I'm using the standard "YES", "NO", "OK", etc. I'm wondering whether there is a method in which I can modify the VB code strip to have the name within the command button state "PRINT"?

Thanks for the help,

Frank

 

[Peter van Vliet]

Hi Frank,

Right-click the command button, select properties and edit the caption box

Regards,
Peter

 

[Zack Barresse]

Heya Frank, howzit?!


Do you mean regular CommandButtons or MsgBox buttons? What exactly are we talking about here?

 

[golf4]

Thanks for the response, guys -

Hey Zack -
Things going pretty good in the Valley. How about out East?

Sorry about the misunderstanding from my post. What I'm actually referring to is the msgbox code like I've pasted below:

Paperwarning = MsgBox("I HAVE HEARD THE WARNING MESSAGE AND HAVE VERIFIED WHETHER ANY FAMILY MEMBER QUALIFIES FOR THE EARNED INCOME DISREGARD. If you have verified all household members, press YES to continue the printing your worksheets. If not, press NO and enter the MEID income data.", vbYesNo, "REMEMBER TO CHECK ALL HOUSEHOLD MEMBERS FOR FOR MEID!!!")

What I would like to show is the YES button to show "Print" or other options like that. Is there a relatively easy way to modify my code?

Thanks for the help and stay safe out there,

Frank

 

[Norie]

Frank

You can alter the buttons on a MsgBox but it would involve using Windows API, which I don't think would be that easy?

Have you looked into using a userform?

 

[Zack Barresse]

Norie has it Frank. You can't without API. Ivan Moala shows how here: http://www.xcelfiles.com/API_11.html

But, imho, it is far easier doing the UserForm. But I try to stay away from API whenever possible; too many variables to screw up.

 

[golf4]

Hi, guys -

Thanks for the info. To tell you the truth, never thought about going with userforms. It certainly seems the easier way to go though. I'll give your suggestions a shot.

Thanks again for the help,

Frank

 

[golf4]

Hi, Zack, Peter & Norie -
Just wanted to thank you guys again for the help. Tried the Userform suggestion, rather than the msgbox option, and it works GREAT!!!

Thanks again.

Frank