Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
lining up columns in messagebox
Does anybody have a (nearly) foolproof method to line up
columns in a message box? I know this can be done with vbTab and maybe padding the strings, but I haven't got a method that always does this job. I know I could do it with a form, but I prefer the simple message box. Thanks for any advice. RBS |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
lining up columns in messagebox
try
Sub messageboxv() MsgBox "hi there" & vbCr & "second line" End Sub -- Don Guillett SalesAid Software "RB Smissaert" wrote in message ... Does anybody have a (nearly) foolproof method to line up columns in a message box? I know this can be done with vbTab and maybe padding the strings, but I haven't got a method that always does this job. I know I could do it with a form, but I prefer the simple message box. Thanks for any advice. RBS |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
lining up columns in messagebox
I don't want to split the strings up with vbCr.
I need to align strings in columns. Something like this often works: MsgBox "string 1" & vbTab & "string 2" & _ vbCrLf & _ "s3" & vbTab & "s4" But not always. If you do for example this: MsgBox "stringxxxxxxxx 1" & vbTab & "string 2" & _ vbCrLf & _ "s3" & vbTab & "s4" It won't align anymore. I am just looking for a foolproof method like a general purpose function that will always gets the strings aligned, no matter what the lengths are. RBS "Don Guillett" wrote in message ... try Sub messageboxv() MsgBox "hi there" & vbCr & "second line" End Sub -- Don Guillett SalesAid Software "RB Smissaert" wrote in message ... Does anybody have a (nearly) foolproof method to line up columns in a message box? I know this can be done with vbTab and maybe padding the strings, but I haven't got a method that always does this job. I know I could do it with a form, but I prefer the simple message box. Thanks for any advice. RBS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lining up 3 excel sheets/ 4 columns/all different | Excel Worksheet Functions | |||
MessageBox with tick box | Excel Discussion (Misc queries) | |||
Sorting and lining up data into columns based off content | Excel Discussion (Misc queries) | |||
lining up 2 columns of zip codes | Excel Discussion (Misc queries) | |||
Printing messagebox | Excel Discussion (Misc queries) |