Hi all,
How to set alignment for part of the text in textbox to the left? This is part of code I am using (tb6 is textbox name). I need part of text after Chr(13) to be alligned to the left (so
should be centered, but
should be aligned to the left.
How to set alignment for part of the text in textbox to the left? This is part of code I am using (tb6 is textbox name). I need part of text after Chr(13) to be alligned to the left (so
VBA Code:
"This field displays the current mode and status the machine"
VBA Code:
& Chr(13) & Chr(13) & "Mode:" & " " _
& "Status:"
VBA Code:
If s.EN.Value = True Then
With tb6.TextFrame
.Characters.Text = "This field displays the current mode and status the machine" _
& Chr(13) & Chr(13) & "Mode:" & " " _
& "Status:"
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlTop
End With