Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Box Characters in a form
I have inherited a form on which is a label. When I edit the label's caption
property, I find 'box' characters which seem to represent linefeeds(?). How can I reproduce these please? Regards. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Box Characters in a form
"abc" & chr10 & "efg"
-- Regards, Tom Ogilvy "Stuart" wrote in message ... I have inherited a form on which is a label. When I edit the label's caption property, I find 'box' characters which seem to represent linefeeds(?). How can I reproduce these please? Regards. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Box Characters in a form
I'm pretty sure Tom meant:
"abc" & chr(10) & "efg" Tom Ogilvy wrote: "abc" & chr10 & "efg" -- Regards, Tom Ogilvy "Stuart" wrote in message ... I have inherited a form on which is a label. When I edit the label's caption property, I find 'box' characters which seem to represent linefeeds(?). How can I reproduce these please? Regards. -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Box Characters in a form
dim chr10 as String
chr10 = chr(10) Userform1.label1.Caption = _ "abc" & chr10 & "efg" guess the first three lines didn't copy. <G Thanks for the catch/fix. -- Regards, Tom Ogilvy "Dave Peterson" wrote in message ... I'm pretty sure Tom meant: "abc" & chr(10) & "efg" Tom Ogilvy wrote: "abc" & chr10 & "efg" -- Regards, Tom Ogilvy "Stuart" wrote in message ... I have inherited a form on which is a label. When I edit the label's caption property, I find 'box' characters which seem to represent linefeeds(?). How can I reproduce these please? Regards. -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Box Characters in a form
Very nice!
Tom Ogilvy wrote: dim chr10 as String chr10 = chr(10) Userform1.label1.Caption = _ "abc" & chr10 & "efg" guess the first three lines didn't copy. <G Thanks for the catch/fix. -- Regards, Tom Ogilvy "Dave Peterson" wrote in message ... I'm pretty sure Tom meant: "abc" & chr(10) & "efg" Tom Ogilvy wrote: "abc" & chr10 & "efg" -- Regards, Tom Ogilvy "Stuart" wrote in message ... I have inherited a form on which is a label. When I edit the label's caption property, I find 'box' characters which seem to represent linefeeds(?). How can I reproduce these please? Regards. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert 5 characters in a cell to 6 characters by adding a zero | Excel Discussion (Misc queries) | |||
Insert Leading Characters If String Is Only 7 Characters | Excel Discussion (Misc queries) | |||
Restricting Characters within a User Form | Excel Discussion (Misc queries) | |||
In Excel find characters when multiple characters exist w/i a cel | Excel Worksheet Functions | |||
HOW DO I EXTRACT ALL CHARACTERS AFTER 5 CHARACTERS ON LEFT | Excel Worksheet Functions |