Enter between Lines

[vikasbhandari2]

Hi Experts!!

I am stuck please help me!

Could you please let me know how can I insert enter between lines?

for example

I am storing some text in a varialble and I want after few characters rest of the characters should come in next time. Like we use \n in c and java.

What can be used in VBA Code?

tex="Hello how are you doing? what'up?"

I want when i print this code in excel sheet I "What's up" should come in the next line?

Thanks,

[RobDog888]

Weel to enter in line breaks you would do this.

tex="Hello how are you doing?" & vbNewline & "what'up?"

But Im just assumming that you already have the Excel part done. You may have to enable the word wrapping in Excel though.

[Static]

tex="Hello how are you doing?[B]" & vbCrLf & "[/B]what'up?"
 
'or
 
tex="Hello how are you doing?[B]" & vbNewLine & "[/B]what'up?"

[RobDog888]

Beat you Static

[penagate]

Use the vbNewLine constant.


Edit:

[Static]

Rob.. ahh.. well thats cause you took the cheap way out and did not give a thurough answer!! cheater!! lol

penagate - No.. use the vbCrLf!!!

[penagate]

Actually I believe vbNewLine is better as it is defined as a platform independent new line constant. vbCrLf is a hardcoded CR + LF sequence.

Could be wrong though.

[RobDog888]

Static: I did give the answer and c0d.

PG: thats what happens when you use that smiley too much, you get slow

There is no difference between vbNewLine and vbCrLf. They are the same, only up to your personal preference but vbNewLine is better

[Static]

yep looked in the object browser.. they are the same.. but vbCrLf just looks so much more cryptic.. that makes it better

[cssriraman]

There is no difference between vbNewLine and vbCrLf. They are the same, only up to your personal preference but vbNewLine is better

How?

Can you show an example or something?

[Static]

Yeah? how is it better?




--- still waiting!

[Al42]

In Windows they're both Chr(13) & Chr(10). If MS ports VB to *nix, vbNewLine would be Chr(10)

[RobDog888]

Yeah? how is it better?

Readibility in your code and like I posted, its a personal preference but you should all do as I say without question

From the immediate window....

?asc(mid$(vbnewline,1,1)) & " - " & asc(mid$(vbnewline,2,1))
13 - 10
?asc(mid$(vbcrlf,1,1)) & " - " & asc(mid$(vbcrlf,2,1))
13 - 10

[vikasbhandari2]

Thanks a bunch it wouked out.

However when I use & vbnewline it breaks the line and enters one space before the first character of next line.

Example

This is first line
this is second line

One more question. Is there any function to bold/italic the text

[Al42]

However when I use & vbnewline it breaks the line and enters one space before the first character of next line.

Example

This is first line
this is second line

Make sure you're not telling it to include that space. vbNewLine has no space in it.

One more question. Is there any function to bold/italic the text

Not in a variable, since it wouldn't make sense - bold and italic are display properties, not properties of the text.

If you want to display the text as bold or italic in a text box, it all has to be bold or italic (or both). If you want just some characters changed you'd have to display it in a rich text box.

[vikasbhandari2]

I am using Rich Text box, what options I have to make them bold.

I want some of the words should come in bold!!

Thanks in advance!!!