Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 94
Default TextBox focus 3

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default TextBox focus 3

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 94
Default TextBox focus 3

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,120
Default TextBox focus 3

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 94
Default TextBox focus 3

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
TextBox focus 2 Tim Coddington Excel Programming 2 July 28th 04 05:15 AM
textbox focus Arne Excel Programming 1 June 15th 04 10:44 AM
TextBox Focus Tom Ogilvy Excel Programming 0 June 3rd 04 04:55 PM
TextBox Focus John Wilson Excel Programming 6 January 16th 04 09:59 PM
Which textbox have focus? Tom Ogilvy Excel Programming 0 August 27th 03 03:12 PM


All times are GMT +1. The time now is 11:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"