Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
G'day there One & All,
I have what I hope is a smallish problem that can easily be resolved by someone with more knowledge than me (which is a sizeable portion of the populace I might add). I have a userform with a collection of 9 optionbuttons inside a frame. There is also a single textbox. The optionbuttons describe mutually exclusive categories with the last being for "Other". I'm trying to make the textbox disabled & locked until the "Other" optionbutton is selected. I think I've got that bit worked out, however if the user has erred and then clicks one of the other options I can't find a way to again lock & disable the textbox as the optionbutton_onclick() event isn't captured unless you click in the option. Naturally, that's what selects that option, not unselects it. Elsewhere in the form I've used a checkbox to do the same thing, however that frame's "Other" is not intended to exclude other choices like this one is. I'd much prefer to use an optionbutton as my users are to a large degree not particularly computer literate and I want my forms and application to do as much of the work as possible. I don't trust any of my users to actually RTFM <g. Is there anyway that I can setup the "Other" optionbutton as a toggle? Will I have to use the Frame's "Click" event to determine which optionbutton has been selected and disable the textbox from that? (If that works) Any ideas would be appreciated, especially if they're simple enough that I can understand what the heck is going on. See ya Ken McLennan Qld, Australia |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Foramtting text in an option button | Excel Worksheet Functions | |||
Formatting the text in an option (radio) button | Excel Discussion (Misc queries) | |||
Formatting text of an option button | Excel Worksheet Functions | |||
Controlling numerical values of option buttons in a group? | Excel Discussion (Misc queries) | |||
Controlling an Option Group in a User Form | Excel Discussion (Misc queries) |