| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding a new text box to user form
Hello Somewhere in the middle of a user form I created I added a new text
box . When I test the user form the cursor skips the new text box , when the cursor gets to the end then it goes back to the new text box. I want the cursor to go from text box to tex box without skipping any text box. How do I correct this thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding a new text box to user form
They go in order. So the new Text Box is probably like TextBox8 or something
above the next TextBox. You'll have to change the order in the UserForm Sub or just change the TextBoxes around. "Marilyn" wrote: Hello Somewhere in the middle of a user form I created I added a new text box . When I test the user form the cursor skips the new text box , when the cursor gets to the end then it goes back to the new text box. I want the cursor to go from text box to tex box without skipping any text box. How do I correct this thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding a new text box to user form
While you're in design mode in the VBE, select a textbox.
Then hit F4 to see its properties. Take a look at the .tabstop and .tabindex properties. (Assuming you're writing about tabbing between the controls.) Marilyn wrote: Hello Somewhere in the middle of a user form I created I added a new text box . When I test the user form the cursor skips the new text box , when the cursor gets to the end then it goes back to the new text box. I want the cursor to go from text box to tex box without skipping any text box. How do I correct this thanks -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding a new text box to user form
Dave Thank you thank you problem solved
"Dave Peterson" wrote: While you're in design mode in the VBE, select a textbox. Then hit F4 to see its properties. Take a look at the .tabstop and .tabindex properties. (Assuming you're writing about tabbing between the controls.) Marilyn wrote: Hello Somewhere in the middle of a user form I created I added a new text box . When I test the user form the cursor skips the new text box , when the cursor gets to the end then it goes back to the new text box. I want the cursor to go from text box to tex box without skipping any text box. How do I correct this thanks -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display contents of a cell in a user form text box -- Excel 2003 VBA | Excel Discussion (Misc queries) | |||
| User Form: Cannot Update Text Box | Excel Discussion (Misc queries) | |||
| user form question: text box to display result | Excel Discussion (Misc queries) | |||
| user form question: text box to display result | Excel Worksheet Functions | |||
| Use a text box to calculate and show results in a user form | Excel Discussion (Misc queries) | |||
Linear Mode
