Message box

[Pat]

The following messagebox contains two buttons. To have a message contained
in the messagebox also but not on the actual buttons what alteration should
I make?

ans = MsgBox("OK", vbOKCancel)
If ans = vbCancel Then Exit Sub

Pat

 

[Jan Karel Pieterse]

Hi Pat,

The following messagebox contains two buttons. To have a message contained
in the messagebox also but not on the actual buttons what alteration should
I make?

ans = MsgBox("OK", vbOKCancel)
If ans = vbCancel Then Exit Sub

Not sure if I understand what your problem is, but the "OK" part of the code
above can be changed, e.g. to this:

ans = MsgBox("Hit OK" & vbNewLine & "Or hit Cancel!",vbOKCancel)

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

 

[Guest]

You do not have the option of not showing any buttons: by default, the OK
button is shown.

 

[Pat]

The message I posted was not correct I have since realised the information
was what I wanted.

Thank you both for your help.
Pat