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: 39
Default Exotic CheckBox

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
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
exotic jewelry box angedeRunda Excel Discussion (Misc queries) 0 October 12th 08 01:22 PM
checkbox Sandee Excel Discussion (Misc queries) 1 April 17th 08 04:43 PM
How to have Checkbox A uncheck with checked Checkbox B Texas Aggie Excel Discussion (Misc queries) 3 July 20th 07 10:58 PM
A Chart for breeding, incubation, eggs, of exotic birds Birdlover Excel Discussion (Misc queries) 0 December 18th 05 11:53 AM
Exotic Bets Spreadsheet - Need Help! Kevin Excel Discussion (Misc queries) 2 May 19th 05 08:12 PM


All times are GMT +1. The time now is 07:28 PM.

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"