Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Focus on Command Buttons
I have a simple form with two command buttons. The user votes for one
of two options by clicking the appropriate button. Currently, when the form opens it appears that the first button has focus. I don't want either button to have focus to avoid "leading" the user to one button over the other. How can I disable focus on the form? Thanks. - John |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Focus on Command Buttons
John,
Add a Frame to the form and make it first in the tab order. Do not place the buttons on it, but place it between the two buttons and set its height (or width) to ~1. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "John Michl" wrote in message I have a simple form with two command buttons. The user votes for one of two options by clicking the appropriate button. Currently, when the form opens it appears that the first button has focus. I don't want either button to have focus to avoid "leading" the user to one button over the other. How can I disable focus on the form? Thanks. - John |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Focus on Command Buttons
Hi John,
Set the commandbutton with Tabstop = false like : Private Sub UserForm_Initialize() CommandButton1.TabStop = False End Sub -- Regards, Halim "John Michl" wrote: I have a simple form with two command buttons. The user votes for one of two options by clicking the appropriate button. Currently, when the form opens it appears that the first button has focus. I don't want either button to have focus to avoid "leading" the user to one button over the other. How can I disable focus on the form? Thanks. - John |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Focus on Command Buttons
Jim - Thanks for the advice. Worked like a charm.
www.johnmichl.com Jim Cone wrote: John, Add a Frame to the form and make it first in the tab order. Do not place the buttons on it, but place it between the two buttons and set its height (or width) to ~1. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "John Michl" wrote in message I have a simple form with two command buttons. The user votes for one of two options by clicking the appropriate button. Currently, when the form opens it appears that the first button has focus. I don't want either button to have focus to avoid "leading" the user to one button over the other. How can I disable focus on the form? Thanks. - John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable cell focus | Excel Discussion (Misc queries) | |||
Disable Min Max restore buttons | Excel Programming | |||
Set focus on command button | Excel Programming | |||
Control Buttons vs. Command Buttons | Excel Programming | |||
Disable Menu and command buttons | Excel Programming |