Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a userform with a textbox on it and several other controlls. I want
only the text box to have focus so the user can repeatedly input a number, press return to process, and enter the next number. On one form I have, after the return, focus comes back to the text box like it should. On another form, it leaves to another control. What could be the difference between the two forms? I don't see anything in my code that would do that. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a userform with a textbox on it and several other controlls. I
want only the text box to have focus so the user can repeatedly input a number, press return to process, and enter the next number. On one form I have, after the return, focus comes back to the text box like it should. On another form, it leaves to another control. What could be the difference between the two forms? I don't see anything in my code that would do that. TextBox Property TabIndex TextBox Property TabStop -- ---------------------------- Mauro Gamberini |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
TabIndex, TabStop made no change. There is no tab used.
"Mauro Gamberini" wrote in message ... I have a userform with a textbox on it and several other controlls. I want only the text box to have focus so the user can repeatedly input a number, press return to process, and enter the next number. On one form I have, after the return, focus comes back to the text box like it should. On another form, it leaves to another control. What could be the difference between the two forms? I don't see anything in my code that would do that. TextBox Property TabIndex TextBox Property TabStop -- ---------------------------- Mauro Gamberini |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
show the code on both.
-- HTH ------- Bob Phillips "Tim Coddington" wrote in message ... I have a userform with a textbox on it and several other controlls. I want only the text box to have focus so the user can repeatedly input a number, press return to process, and enter the next number. On one form I have, after the return, focus comes back to the text box like it should. On another form, it leaves to another control. What could be the difference between the two forms? I don't see anything in my code that would do that. |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Just looking at the from that fails, this is all the code. I found nothing
in the other text box's code to help. Private Sub OptionButton1_Click() TextBox1.SetFocus End Sub Private Sub OptionButton2_Click() TextBox1.SetFocus End Sub "Bob Phillips" wrote in message ... show the code on both. -- HTH ------- Bob Phillips "Tim Coddington" wrote in message ... I have a userform with a textbox on it and several other controlls. I want only the text box to have focus so the user can repeatedly input a number, press return to process, and enter the next number. On one form I have, after the return, focus comes back to the text box like it should. On another form, it leaves to another control. What could be the difference between the two forms? I don't see anything in my code that would do that. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
TextBox focus 2 | Excel Programming | |||
textbox focus | Excel Programming | |||
TextBox Focus | Excel Programming | |||
TextBox Focus | Excel Programming | |||
Which textbox have focus? | Excel Programming |