Chris Macro
Well-known Member
- Joined
- Nov 2, 2011
- Messages
- 1,345
- Office Version
- 365
- Platform
- Windows
I know I can probably do this with a userform but don't really want to mess around with recoding at this point.
I have a routine that eventually outputs something like the msgbox displayed below. The only problem is my tabulated spacing gets messed up when one of my words is too long (as shown in my example). Can anyone think of a workaround to address this?
I have a routine that eventually outputs something like the msgbox displayed below. The only problem is my tabulated spacing gets messed up when one of my words is too long (as shown in my example). Can anyone think of a workaround to address this?
Code:
Sub Example()
MsgBox ("Zoo" & vbTab & vbTab & 10 & vbTab & "1.0%" & vbNewLine & _
"Exhibition" & vbTab & vbTab & 3 & vbTab & "1.9%" & vbNewLine & _
"Popular" & vbTab & vbTab & 4 & vbTab & "1.7%" & vbNewLine & _
"Manchester" & vbTab & vbTab & 9 & vbTab & "0.6%" & vbNewLine)
End Sub