Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi NG
I am making a GUI with some checkboxes and i am VERY focused on making the everyday use of the GUI as uninterrupted as possible e.g. no popup windows with "you can't do this: click ok"-stuff. The GUI is like this: The user chooses some options with by using checkboxes. Some options exclude others or are dependant on others e.g option A can not be choosen if option B is choosen. Further B migth depend on C and so on. The way i handle this is that if i choose A then i do a CheckBox_B.Enable = False. if i click on A one more time (deselct it) then i do a CheckBox_B.Enable = True. In this way the user can never choose A and B at the same time. The user migth think: "why the heck cant i choose B?" and the logical thing might then to click on B - enventhough CheckBox_B.Enable = False. Here is then what i imagine should happen: When the user click on the non-enabled checkbox B, then the backcolor of checkbox A should be changed to red as to indicate the blocking option. Can this be done in ANY way in VBA. I.e i know that somehow the eventlistener stops listening to all the .enabled = false widgets (buttons etc.) in the GUI and thus cant catch a click on checkbox_B Any comments greatly appreciated Mark |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
exotic jewelry box | Excel Discussion (Misc queries) | |||
checkbox | Excel Discussion (Misc queries) | |||
How to have Checkbox A uncheck with checked Checkbox B | Excel Discussion (Misc queries) | |||
A Chart for breeding, incubation, eggs, of exotic birds | Excel Discussion (Misc queries) | |||
Exotic Bets Spreadsheet - Need Help! | Excel Discussion (Misc queries) |