Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Next line in header
I am adding headers to a worksheet using VBAs. Users are
prompted to enter the client's name in an input box, and this info is added to the rest of the header. My problem is that I want part of the information to be on a second line in the header. I cannot figure out how to add a line return in VBA. Can someone tell me how to do this? Thanks, Lee |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Next line in header
Line 1 & vbNewLine & Line 2
-- Vasant "Lee" wrote in message ... I am adding headers to a worksheet using VBAs. Users are prompted to enter the client's name in an input box, and this info is added to the rest of the header. My problem is that I want part of the information to be on a second line in the header. I cannot figure out how to add a line return in VBA. Can someone tell me how to do this? Thanks, Lee |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Next line in header
Lee,
Use vbCrLF constant x= "something" & vbCrLf & " else" -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Lee" wrote in message ... I am adding headers to a worksheet using VBAs. Users are prompted to enter the client's name in an input box, and this info is added to the rest of the header. My problem is that I want part of the information to be on a second line in the header. I cannot figure out how to add a line return in VBA. Can someone tell me how to do this? Thanks, Lee |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
header and footer boarder line | New Users to Excel | |||
Is there a way (Excel 2003) to make a TWO LINE header in a column | Excel Discussion (Misc queries) | |||
How do I change one line of a 3 line header | Excel Discussion (Misc queries) | |||
"&" character in header line | Excel Discussion (Misc queries) | |||
Blank Line in Header Text | Excel Programming |