Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
format label text
I have a UserForm with a TextBox on it. I have initiated the text box with a
series of values. I would like to format the result of my displayed textbox. It reads as follows. Me.TextBox4 = _ "Model:" Range("o12").Value & vbCr & _ "Customer: " & Range("n26").Value & vbCr & _ "Qty:" & Range("J26").Value I would like to underline the words Model, Customer and Qty: Can I do it? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
format label text
I think the way it is built that you have to underline all or none.
"Alberto Ast" wrote in message ... I have a UserForm with a TextBox on it. I have initiated the text box with a series of values. I would like to format the result of my displayed textbox. It reads as follows. Me.TextBox4 = _ "Model:" Range("o12").Value & vbCr & _ "Customer: " & Range("n26").Value & vbCr & _ "Qty:" & Range("J26").Value I would like to underline the words Model, Customer and Qty: Can I do it? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
format label text
How do I underline it with programing?
"Alberto Ast" wrote: I have a UserForm with a TextBox on it. I have initiated the text box with a series of values. I would like to format the result of my displayed textbox. It reads as follows. Me.TextBox4 = _ "Model:" Range("o12").Value & vbCr & _ "Customer: " & Range("n26").Value & vbCr & _ "Qty:" & Range("J26").Value I would like to underline the words Model, Customer and Qty: Can I do it? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
format label text
Me.TextBox4.Font.Underline = xlLineStyleSingle
"Alberto Ast" wrote in message ... How do I underline it with programing? "Alberto Ast" wrote: I have a UserForm with a TextBox on it. I have initiated the text box with a series of values. I would like to format the result of my displayed textbox. It reads as follows. Me.TextBox4 = _ "Model:" Range("o12").Value & vbCr & _ "Customer: " & Range("n26").Value & vbCr & _ "Qty:" & Range("J26").Value I would like to underline the words Model, Customer and Qty: Can I do it? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
format label text
With Me.TextBox1
.Value = "hi there" .Font.Underline = True End With Alberto Ast wrote: How do I underline it with programing? "Alberto Ast" wrote: I have a UserForm with a TextBox on it. I have initiated the text box with a series of values. I would like to format the result of my displayed textbox. It reads as follows. Me.TextBox4 = _ "Model:" Range("o12").Value & vbCr & _ "Customer: " & Range("n26").Value & vbCr & _ "Qty:" & Range("J26").Value I would like to underline the words Model, Customer and Qty: Can I do it? -- Dave Peterson |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
format label text
Thanks you both...
I wanted to mix different font types in same textbox but as JLGWhiz stated looks like it is not posible.... too bad :(, thanks anyway "Dave Peterson" wrote: With Me.TextBox1 .Value = "hi there" .Font.Underline = True End With Alberto Ast wrote: How do I underline it with programing? "Alberto Ast" wrote: I have a UserForm with a TextBox on it. I have initiated the text box with a series of values. I would like to format the result of my displayed textbox. It reads as follows. Me.TextBox4 = _ "Model:" Range("o12").Value & vbCr & _ "Customer: " & Range("n26").Value & vbCr & _ "Qty:" & Range("J26").Value I would like to underline the words Model, Customer and Qty: Can I do it? -- Dave Peterson . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data label format | Charts and Charting in Excel | |||
Label Format to Column Format | Excel Discussion (Misc queries) | |||
How do I format text in a label in Excel? | Excel Worksheet Functions | |||
Data Label Format | Excel Discussion (Misc queries) | |||
add text to label (label from forms toolbar) | Excel Programming |