Insert Tab Space

[dok112]

Hey everyone,

I have a macro that is generating an email based on input into a userform. How can I tell it to insert a tab space into the email? I've tried just tabbing the text in the macro and that doesn't work. I've also tried just spacing it, but that doesn't line up straight. I know of Chr(10) for entering a linebreak, is there a similar code to enter a tab?

TIA for your help everyone!

[Harald Staff]

Hi

Tab is Chr(9)

HTH. Best wishes Harald


"dok112" <dok112.25ei7z_1143585002.5092@excelforum-nospam.com> skrev i
melding news:dok112.25ei7z_1143585002.5092@excelforum-nospam.com...
>
> Hey everyone,
>
> I have a macro that is generating an email based on input into a
> userform. How can I tell it to insert a tab space into the email?
> I've tried just tabbing the text in the macro and that doesn't work.
> I've also tried just spacing it, but that doesn't line up straight. I
> know of Chr(10) for entering a linebreak, is there a similar code to
> enter a tab?
>
> TIA for your help everyone!
>
>
> --
> dok112
> ------------------------------------------------------------------------
> dok112's Profile:
http://www.excelforum.com/member.php...o&userid=10581
> View this thread: http://www.excelforum.com/showthread...hreadid=527351
>

[Dave Peterson]

or vbTab


dok112 wrote:
>
> Hey everyone,
>
> I have a macro that is generating an email based on input into a
> userform. How can I tell it to insert a tab space into the email?
> I've tried just tabbing the text in the macro and that doesn't work.
> I've also tried just spacing it, but that doesn't line up straight. I
> know of Chr(10) for entering a linebreak, is there a similar code to
> enter a tab?
>
> TIA for your help everyone!
>
> --
> dok112
> ------------------------------------------------------------------------
> dok112's Profile: http://www.excelforum.com/member.php...o&userid=10581
> View this thread: http://www.excelforum.com/showthread...hreadid=527351

--

Dave Peterson