Insert Tab Space
 

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

Insert Tab Space
 

Hi

Tab is Chr(9)

HTH. Best wishes Harald


"dok112" skrev i
melding ...

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

Insert Tab Space
 

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