ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Box Characters in a form (https://www.excelbanter.com/excel-programming/328929-box-characters-form.html)

Stuart[_21_]

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.



Tom Ogilvy

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.





Dave Peterson[_5_]

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

Tom Ogilvy

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




Dave Peterson[_5_]

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


All times are GMT +1. The time now is 03:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com