ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Adding a new text box to user form (https://www.excelbanter.com/excel-discussion-misc-queries/142585-adding-new-text-box-user-form.html)

Marilyn

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

AKphidelt

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


Dave Peterson

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

Marilyn

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



All times are GMT +1. The time now is 06:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com