|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 28th 06, 11:26 PM
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 
|
| Ads |
|
#2
March 28th 06, 11:42 PM
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
March 29th 06, 01:36 AM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to insert a space between display results | Neall | Excel Worksheet Functions | 2 | July 5th 07 05:10 PM |
| Insert Space | sabegirl | Excel Discussion (Misc queries) | 2 | May 28th 06 04:44 AM |
| Macro to insert a space | Lame Dame via OfficeKB.com | Excel Programming | 2 | March 23rd 06 05:37 PM |
| How do I insert space between 2 consecutive columns of an XL Shee. | Shamshad Butt | Excel Discussion (Misc queries) | 4 | October 20th 05 12:28 PM |
| How can I insert a space before the last character in a range of cells | Jeff[_25_] | Excel Programming | 8 | November 13th 03 07:45 PM |
Linear Mode
