| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Link Text Boxes (As can do in Word)
Hi,
I have text box controls (inserted from the Control Toolbox) in my worksheet and am wondering if there is any way to program them so that text flows from one into another when the text is longer than the text box. I know this is easy with Word, and that there isn't an option in Excel, but was wondering if this is something that could be programmed. Thanks for any advice. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Link Text Boxes (As can do in Word)
Try something like.
Option Explicit Private Const TextMaxLength As Long = 10 ' Change to Suit Private Sub TextBox1_Change() If Len(TextBox1.Value) = TextMaxLength Then TextBox2.Activate End If End Sub 'This is pretty basic 'Every time a character is added 'The code counts the total 'if it equals then specified max 'Then it moves to the next textbox "Joyce" wrote: Hi, I have text box controls (inserted from the Control Toolbox) in my worksheet and am wondering if there is any way to program them so that text flows from one into another when the text is longer than the text box. I know this is easy with Word, and that there isn't an option in Excel, but was wondering if this is something that could be programmed. Thanks for any advice. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Link Text Boxes (As can do in Word)
Hi Jeff,
Thanks for the response. I tried this, but it didn't work. Am I missing something? I tried it in both the sheet and a module and added text boxes from the Control Toolbox, but it didn't limit me to 10 characters. Thanks. "Jeff" wrote: Try something like. Option Explicit Private Const TextMaxLength As Long = 10 ' Change to Suit Private Sub TextBox1_Change() If Len(TextBox1.Value) = TextMaxLength Then TextBox2.Activate End If End Sub 'This is pretty basic 'Every time a character is added 'The code counts the total 'if it equals then specified max 'Then it moves to the next textbox "Joyce" wrote: Hi, I have text box controls (inserted from the Control Toolbox) in my worksheet and am wondering if there is any way to program them so that text flows from one into another when the text is longer than the text box. I know this is easy with Word, and that there isn't an option in Excel, but was wondering if this is something that could be programmed. Thanks for any advice. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Link Text Boxes on Form? | Excel Discussion (Misc queries) | |||
| Text boxes and word art NOT printing | Excel Discussion (Misc queries) | |||
| How do I link Text Boxes to Cells, not Cells to Text Boxes? | Excel Worksheet Functions | |||
| Allow Word type formatting in Excel text boxes | Excel Discussion (Misc queries) | |||
| I want to link, not just copy,Word source text to a text box in Ex | Excel Worksheet Functions | |||
Linear Mode
