Message box

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

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

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

"Pat" wrote:

> 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
>
>
>

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

Thank you both for your help.
Pat
"AA2e72E" <[email protected]> wrote in message
news:[email protected]...
> You do not have the option of not showing any buttons: by default, the OK
> button is shown.
>
> "Pat" wrote:
>
>> 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
>>
>>
>>