| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Carriage return in macros
Hi I would like to write a list of words on a TextBox of a UserForm; how can I specifiy the Carriage return character in the "TextBox.Text=" sentence? Thanks!! -- Manu Palao ------------------------------------------------------------------------ Manu Palao's Profile: http://www.excelforum.com/member.php...o&userid=16205 View this thread: http://www.excelforum.com/showthread...hreadid=278272 |
|
#2
|
|||
|
|||
|
Manu,
Try code like the following: Me.TextBox1.MultiLine = True Me.TextBox1.Text = "Line One" & vbNewLine & _ "Line Two" & vbNewLine & _ "Line Three" For aesthetic reasons, you might want to use a ListBox control rather than a TextBox control. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Manu Palao" wrote in message ... Hi I would like to write a list of words on a TextBox of a UserForm; how can I specifiy the Carriage return character in the "TextBox.Text=" sentence? Thanks!! -- Manu Palao ------------------------------------------------------------------------ Manu Palao's Profile: http://www.excelforum.com/member.php...o&userid=16205 View this thread: http://www.excelforum.com/showthread...hreadid=278272 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to find replace text or symbol with carriage return | New Users to Excel | |||
| Transferring toolbars and macros to other computers | Excel Discussion (Misc queries) | |||
| The available macros list in XL; how to suppress filename from showing | Excel Discussion (Misc queries) | |||
| Macros disappear after a file is imported | Excel Discussion (Misc queries) | |||
| Carriage Return in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
