Carriage Return in msgbox/inputbox

[jcvoth]

Dear all,

Parry, thanks for your help on my earlier query. The code is working flawlessly. I experimented for a bit with userforms, but I think spoonfeeding the user with one question at a time is the best course.

I did come across one minor problem. I have several msgboxes and/or inputboxes that come out in a poor format. example:

InputBox("What Type of Transaction do you wish to enter? (OE: Addition or Withdrawl from the Business, PMT: A Payment to the principle lender; MBNA, or CLS: A Journal entry to close the Accounting Period.)")

The inputbox is formatted as follows:

What Type of Transaction do you wish to enter? (OE: Addition or Withdrawl from the Business, PMT: A Payment to the principal lender; MBNA, or CLS: A Journal entry to close the Accounting Period.

I would like to find a way to format it as follows:

What type of Transaction do you wish to enter?

* OE: Addition or withdrawl from the Business
* PMT: A Payment to the principal lender
* CLS: A Journal Entry to close the Accounting Period.

Is there a way to enter a carriage return in msgbox/inputboxes?

 

[Joe4]

vbCrLF will create a carriage return in Message Boxes and Input Boxes, i.e.

MsgBox "*Message Line 1" & vbCrLf & "*Message Line 2"

 

[Iridium]

Check out 'Miscellaneous Constants' in the VBE help...

 

[jcvoth]

This is great. I printed myself a copy of the miscellaneous constants for future reference.

You guys are awesome.