ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Userform problem (https://www.excelbanter.com/excel-programming/359778-userform-problem.html)

Andrew B[_4_]

Userform problem
 
Hi
I have created a simple userform which gives the user a choice between
three option buttons. When the userform first appears, the text for the
first option button is enclosed in a dotted rectangle. How do I remove
this rectangle so that it doesn't appear to be the preferred option ?

I tried this but it didn't change anything.

Private Sub OptionButton1_Click()
GotFocus = False
end sub

TIA

Andrew B

Gert-Jan

Userform problem
 
May the Tab-index? You can also set TabStop to "No"

"Andrew B" schreef in bericht
...
Hi
I have created a simple userform which gives the user a choice between
three option buttons. When the userform first appears, the text for the
first option button is enclosed in a dotted rectangle. How do I remove
this rectangle so that it doesn't appear to be the preferred option ?

I tried this but it didn't change anything.

Private Sub OptionButton1_Click()
GotFocus = False
end sub

TIA

Andrew B




Die_Another_Day

Userform problem
 
On Userform1_Initialize try this

OptionButton2.SetFocus 'Change out Button2 for whichever button you
want to have focus

Die_Another_Day


Andrew B[_5_]

Userform problem
 
The TabStop thing worked - thanks.


All times are GMT +1. The time now is 12:45 PM.

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