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