MrExcel Publishing
Your One Stop for Excel Tips & Solutions

msgbox questions

Posted by John on November 25, 2001 6:06 AM

I would like a message box to preview an invoice before it is filed in the database for the user to preview. I'm unsure how to format the message box. I would like to put information such as

"would you like to file this invoice?"
"name" (name data from invoice form)
"Address" (address data from invoice form)
"Item 1" (Item 1 from invoice)

and so forth.

All of the information that I want to display I have as named cells that I can put there but I'm not sure how to format the message box as far as line feeds and so forth. Any info would be helpful.


Posted by Luis B on November 25, 2001 7:54 AM

Try this:

Response = MsgBox ("Would you like to file this invoice?" & Chr(10) & Range("name") & Range ("Address") & Range ("Item 1"), Style of MsgBox, Title on MsgBox)

The Chr(10) gives the line feed. Move it around as needed.