LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default checkbox code makes excel sloowwwww...

Thanks, Harald and Tom.

I'll probably go with Harald's suggestion - remove the checkboxes and
use some other visual indicator. I wanted to retain a consistent
appearance within the table of checkboxes (where a user selects one or
more practices, via the checkboxes, that apply to up to 10 distinct
land areas), but for these particular 2 practices, the user provides
input elsewhere in the workbook that amounts to selecting the
practice, and I want to report it somehow in the checkbox table. Not
sure if this makes sense without going into great, boring detail.
Anyway, imho the appearance of the grayed-out checkboxes can be
confusing to an audience who isn't used to seeing them. Thanks again
for your input. Yeah....recursive code without end does slow things
down a bit! <duh

-Scott



"Harald Staff" wrote in message ...
Oops. Thanks Tom. I missed the "I have 20 checkboxes that I do not want
users to be able to change" part, probably because it's meaningless to me.
Imo those boxes shouldn't be there. But enabled = false is definitely a good
option if "this is for the big guys and you're definitely not one of them"
is an important message for the users.

Best wishes Harald



 
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
Simple Checkbox Message Code nemadrias Excel Discussion (Misc queries) 10 June 21st 06 08:59 PM
A VBA code that clicks a checkbox nevaspb Excel Programming 2 August 19th 04 03:55 AM
Checkbox Code Edwin Tam[_2_] Excel Programming 0 January 14th 04 02:26 AM
testing the state of a checkbox in vba code Paul James[_3_] Excel Programming 10 December 5th 03 07:55 PM
Rob Bovey's Code Cleaner makes file larger. Why? Don Wiss Excel Programming 1 October 8th 03 07:23 AM


All times are GMT +1. The time now is 11:03 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"