I know I have found this somewhere but I for got where. How can you make a Msgbox more than one line?
I know I have found this somewhere but I for got where. How can you make a Msgbox more than one line?
Peace of mind is found in some of the strangest places.
if I understand your question correctly, simply insert a "line feed" into the Prompt string each time you want to go to the next line. For example:Originally Posted by austenr
Msgbox "this is the first line" & vbcrlf & "and this is the second"
"It's not just the due date that's important, it's also the do date" [MWE]
When your problem has been resolved, mark the thread SOLVED by clicking on the Thread Tools dropdown menu at the top of the thread.
Thanks. Was missing an & sign. Solved.
Peace of mind is found in some of the strangest places.
Possibly easier to remember is vbNewLine. It does exactly the same thing.
Hope that helps.
Get the free Excel based Toolbar or click here for free examples & Excel Consultancy
RoyUK
More importantly, it also works on the Mac.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Posting Permissions
Reply With Quote
