LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 90
Default Option button controlling text box

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Foramtting text in an option button Iriemon Excel Worksheet Functions 1 May 24th 07 07:09 PM
Formatting the text in an option (radio) button Iriemon Excel Discussion (Misc queries) 0 May 24th 07 06:58 PM
Formatting text of an option button Iriemon Excel Worksheet Functions 2 May 24th 07 04:03 PM
Controlling numerical values of option buttons in a group? Jay Weiss Excel Discussion (Misc queries) 2 May 7th 07 05:51 PM
Controlling an Option Group in a User Form SaeOngJeeMa Excel Discussion (Misc queries) 0 November 29th 06 08:17 AM


All times are GMT +1. The time now is 01:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"