Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform problem
On Userform1_Initialize try this
OptionButton2.SetFocus 'Change out Button2 for whichever button you want to have focus Die_Another_Day |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform problem
The TabStop thing worked - thanks.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
userform problem | Excel Discussion (Misc queries) | |||
Userform problem | Excel Programming | |||
userform problem | Excel Programming | |||
Userform from a Userform Problem | Excel Programming | |||
SOme problem on VBA Userform | Excel Programming |