| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
display multiple lines in pop up when workbook opens
I have this code in my "thisworkbook"
Private Sub Workbook_Open() MsgBox "NOTES/DIRECTIONS:1....2...." End Sub however, i would like to display the 1 and 2 and so on in new rows in the pop up like this NOTES/DIRECTIONS 1. flaksdjfkldjfsdf 2. lkasdjfl;kasdjflkjsdf Can this be done?? Thank you in advance if anyone can help!!! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
display multiple lines in pop up when workbook opens
I think what you're looking for is:
msgbox "Notes/Directions" & vbCrLf & "Direction 1" & vbCrLf & "Direction 2" I'm pretty sure there's a limit on how much text a messagebox can contain, though, so if it's long, I suggest using a userform instead. wrote: I have this code in my "thisworkbook" Private Sub Workbook_Open() MsgBox "NOTES/DIRECTIONS:1....2...." End Sub however, i would like to display the 1 and 2 and so on in new rows in the pop up like this NOTES/DIRECTIONS 1. flaksdjfkldjfsdf 2. lkasdjfl;kasdjflkjsdf Can this be done?? Thank you in advance if anyone can help!!! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
display multiple lines in pop up when workbook opens
Thank you very much Jeremy
|
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
display multiple lines in pop up when workbook opens
Thank you very much Jeremy
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Opens multiple versions of workbook | Excel Discussion (Misc queries) | |||
| Excel opens multiple copies of workbook | Excel Discussion (Misc queries) | |||
| display 1 line of multiple worksheets into multiple lines on 1 wks | Excel Worksheet Functions | |||
| Display multiple lines of text within a cell from multiple column. | Excel Worksheet Functions | |||
Linear Mode
