LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default getting focus on an optionbutton

Yes, that works!!!

Thanks Harald Staff

Len
-----Original Message-----
Hi

Private Sub OptionButton1_Enter()
OptionButton1.Value = True
End Sub

Private Sub OptionButton2_Enter()
OptionButton2.Value = True
End Sub

HTH. Best wishes Harald

"Len" skrev i

melding
...
I have a userform with three text boxes and nine
optionbuttons. The optionbuttons are in one group. When

I
tab through the optionbuttons I want the focus to move
from one optionbutton to another and have the

optionbutton
take focus (i.e. get the dot in the button). Tabbing
causes the caption on the optionbutton to be highlighted
but the option button actually does not get focus (i.e.
OptionButton1.Value = False). I

want "OptionButton1.Value
= True" to occur when I tab to the optionbutton. How do

I
get this to happen? Is this possible?



.

 
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
optionbutton - three options Sian Excel Discussion (Misc queries) 7 January 5th 08 10:29 AM
Optionbutton troubles Mats Samson Excel Worksheet Functions 2 September 27th 07 03:54 PM
OptionButton. Reset to 0 Eef Houniet New Users to Excel 7 September 3rd 06 12:14 PM
How Do I Tab From An OptionButton To A TextBox Minitman Excel Discussion (Misc queries) 0 February 23rd 05 09:34 PM
OptionButton type name? Charley Kyd[_2_] Excel Programming 4 January 8th 04 04:53 AM


All times are GMT +1. The time now is 02:37 AM.

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"