View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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