short message box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

learningMikey - 01 Nov 2005 19:41 GMT

Hi All ....How can I create a short message box as opposed to very wide? I
want the following message to be displayed in similar format.

This cassette has been rented by:
FirstName LastName
(xxx)-xxx-xxxxx
Please return before renting.

when i put msgbox comman the same appears as

This cassette has been rented by: FirstName LastName (xxx)-xxx-xxxxx Please
return before renting.

And I don't want it this way. Thanks for your help.

Reply to this Message

Ofer - 01 Nov 2005 19:49 GMT

Try this

msgbox "This cassette has been rented by: " & chr(13) & _
"FirstName LastName " & chr(13) & _
"(xxx)-xxx-xxxxx " & chr(13) & _
"Please return before renting"

Signature

If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck

> Hi All ....How can I create a short message box as opposed to very wide? I
> want the following message to be displayed in similar format.
[quoted text clipped - 10 lines]
>
> And I don't want it this way. Thanks for your help.

Reply to this Message

Gerald Stanley - 01 Nov 2005 19:55 GMT

Use the constant vbCrLf to produce the message in the format that you require
e.g.

MsgBox FirstName & " " & LastName & vbCrLf & ... etc

Hope This Helps

Signature

Gerald Stanley MCSD

Reply to this Message