| 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 | |||
![Stuart[_21_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
