How do I get a carriage return?

**Excelski** · 07-11-2017, 05:58 AM

Hi,

When writing text in VBA how do I get the text on different lines

At the moment my text is

Gents, have a good day, Regards

I would like to see

Gents,
Have a good day
Regards.

Thanks
Kevin

**cytop** · 07-11-2017, 06:02 AM

Please Login or Register  to view this content.

**Excelski** · 07-11-2017, 06:23 AM

Thanks cytop

How do I get a carriage return?

LinkBack

Thread Tools

Rate This Thread

Display

How do I get a carriage return?

Re: How do I get a carriage return?

Re: How do I get a carriage return?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] return FROM TO values from custom defined range , and return all possible combination

Lookup and return rows based on layout entered, perform calc on return and output file

Double click row to return data to userform for edit then return back to sheet

If date is in future return no value, otherwise return in a new cell the month i.e june=6

Using Lookup to Return Column Header or Index Function to return revised pay rate

Calculate Annualized Rate of Return based on yearly return rates

Search...Return...give info based on the return address

Bookmarks

Bookmarks

Posting Permissions