| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Msgbox prompt and tabbing
I have a need to present neatly lined up columnar data in the prompt of a
message box. (I am just beginning to learn about forms) the Tab function documentation seems to work only for print files. I suppose I can examine the data and put in some & space(varname) 'spacers' but that's a fair amount of work and will only get pretty close. Can anyone describe another way? thanks. -- Neal Z |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Msgbox prompt and tabbing
You want to look into these constants which will allow you to format the
message box to have a columnar appearance vbTab and vbCrLf (Carriage return line feed) Try this to see what I mean MsgBox "This" & vbTab & "That" & vbCrLf & "Mine" & vbTab & "Yours" -- HTH... Jim Thomlinson "Neal Zimm" wrote: I have a need to present neatly lined up columnar data in the prompt of a message box. (I am just beginning to learn about forms) the Tab function documentation seems to work only for print files. I suppose I can examine the data and put in some & space(varname) 'spacers' but that's a fair amount of work and will only get pretty close. Can anyone describe another way? thanks. -- Neal Z |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Msgbox prompt and tabbing
Jim -
Works like a charm. Thanks. It's always so simple when you "know". Neal "Jim Thomlinson" wrote: You want to look into these constants which will allow you to format the message box to have a columnar appearance vbTab and vbCrLf (Carriage return line feed) Try this to see what I mean MsgBox "This" & vbTab & "That" & vbCrLf & "Mine" & vbTab & "Yours" -- HTH... Jim Thomlinson "Neal Zimm" wrote: I have a need to present neatly lined up columnar data in the prompt of a message box. (I am just beginning to learn about forms) the Tab function documentation seems to work only for print files. I suppose I can examine the data and put in some & space(varname) 'spacers' but that's a fair amount of work and will only get pretty close. Can anyone describe another way? thanks. -- Neal Z |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VB - ignore a msgbox prompt | Excel Discussion (Misc queries) | |||
| save prompt for user exit, but no save prompt for batch import? | Excel Discussion (Misc queries) | |||
| Why does tabbing from A1 take me to L1 then to W1 | Excel Worksheet Functions | |||
| MsgBox Prompt w/ No "X" to close | Excel Programming | |||
| msgbox prompt when user selects data from combo box | Excel Programming | |||
Hybrid Mode
