Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
centering text on textbox
I have a userform just to display some info. In the form I have a textbox
where I pull lots of info including some vbtab and vbcr. is there a way to center some of the lines texts I would like to put some titles in the middle but center in the textbox. my program looks like this Private Sub UserForm_Initialize() Me.TextBox1 = _ "Model:" & vbTab & vbTab & vbTab & Range("o12").Value & vbCr _ & "Customer: " & vbTab & vbTab & Range("n26").Value & vbCr _ & "Qty:" & vbTab & vbTab & vbTab & Range("J26").Value & vbCr & vbCr _ & "Part Description: " & vbTab & Range("O17").Value & vbCr _ & "Original P/N: " & vbTab & vbTab & Range("O14").Value & vbCr _ & "Replacement P/N: " & vbTab & Range("O20").Value & vbCr _ & "ECR Requested: " & vbTab & Range("F12").Value & vbCr & vbCr _ & "Description: " & Range("A30").Value & vbCr & vbCr _ & "Prevention: " & Range("A38").Value & vbCr & vbCr End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Centering and warping text | Excel Programming | |||
text centering | Excel Programming | |||
Centering Text Not Working | Excel Programming | |||
Centering the text in a message box | Excel Programming | |||
Centering the text in a message box | Excel Programming |