Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello -
I have a msgbox that returns a concatenation of cell addresses that are blank. My problem is there could be as many as 64 cell addresses returned, which would make the message box extend completely across the screen. sStr is the cell address. Here's the code: MsgBox ("The blank cells a " & sStr _ & vbCrLf & vbCrLf & "You must fill them in before proceeding!"), _ [vbOKOnly], ["Blank Cells!"] Is there any way I can get it to display three sStr and then do a vbCrLf, then another three, etc.? Any help will be greatly appreciated! -- Sandy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
MsgBox line break | Excel Discussion (Misc queries) | |||
How do I format a MSGBOX to show text and variables in a macro? | New Users to Excel | |||
Line breaks | Excel Discussion (Misc queries) | |||
Line breaks | Excel Worksheet Functions | |||
New Line in MsgBox | Excel Programming |