That wouldn't matter as it's based on the change event of
the "other" option button amd the option buttons are
mutually exclusive.
If "other" was clicked then it changes to true and the
textbox is enabled.
If any of the other option buttons are clicked
then "other" will change to false and the textbox will be
disabled.

-----Original Message-----
There are 8 other buttons.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Libby" wrote in
message
...
Can't you just put something like following in the
change
event for the "other" option button?

Private Sub OptionOTHER_Change()
TextBox1 = ""
TextBox1.Enabled = OptionOTHER.Value
End Sub


-----Original Message-----
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
.



.