By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,593 Members | 2,006 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,593 IT Pros & Developers. It's quick & easy.

autoformatting option buttons

P: 1
Sorry, just a newbie and what I call a 'bruteforce' programmer. I'm using a VBform in EXCEL to pass info to a worksheet. I have 7 option buttons (exclusive?, only one can be true) and want to highlight the option button that has been selected and 'gray-out' those not selected. I can do this by writing code for each of the option buttons as Button_Click procedures but there must be an easier way (I actually have 6 groups of 7 buttons on the form). There must be an easier way to accomplish this. Can anyone provide an example?

Thanks, John
Nov 10 '06 #1
Share this Question
Share on Google+
1 Reply


100+
P: 267
Sorry, just a newbie and what I call a 'bruteforce' programmer. I'm using a VBform in EXCEL to pass info to a worksheet. I have 7 option buttons (exclusive?, only one can be true) and want to highlight the option button that has been selected and 'gray-out' those not selected. I can do this by writing code for each of the option buttons as Button_Click procedures but there must be an easier way (I actually have 6 groups of 7 buttons on the form). There must be an easier way to accomplish this. Can anyone provide an example?

Thanks, John
hi

fyg
optionbuttons have no grayscale
when you press one, the others well be de-selected if the are positioned on the same form (no frames etc)
checkboxes however have a grayscale.
think you need to revaluate the ones you want to be 'grayed'.
best option is create checkboxes in an array

do checkbox_clik (index as integer) stuff, where all but index is grayed.
Nov 10 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.