autoformatting option buttons

[MAIjah]

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

[albertw]

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.