Custom MsgBox

[jbrouse]

Greetings,

Is it possible to make a customized message box? Basically, I want a message box similar to the vbYesNo type, but instead of having options of "Yes" and "No", I would like "Accept" and "Reject".

Is this possible?

Thanks in advance!

 

[Smitty]

Sure, you can build a User Form to mimic a message box.

HTH,

Smitty

 

[Datsmart]

Good source of Step by Step instructions for creating a UserForm.
http://www.contextures.com/xlUserForm01.html

 

[erik.van.geit]

Hi,

I think you will need a userform for this

never created one ?
I suggest you do a search on the Board + check out the helpfiles

basically you will need these steps
in VBA-editor
menu insert /userform
create a label
type any text in it
create two commandbuttons
change captions as needed
double-click them and write code

kind regards,
Erik

 

[DominicB]

Good morning jbrouse

It can be done only using API's - you might want to use a userform once you see the code, but just for the benefit of anybody else who wants to see how it's done, IvanF Moala shows here :

http://www.xcelfiles.com/API_11.html

HTH

DominicB