| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to insert a space between display results | Excel Worksheet Functions | |||
| Insert Space | Excel Discussion (Misc queries) | |||
| Macro to insert a space | Excel Programming | |||
| How do I insert space between 2 consecutive columns of an XL Shee. | Excel Discussion (Misc queries) | |||
| How can I insert a space before the last character in a range of cells | Excel Programming | |||
![dok112[_108_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
