467,151 Members | 920 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,151 developers. It's quick & easy.

autoformatting option buttons

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
  • viewed: 1194
Share:
1 Reply
100+
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.

Similar topics

1 post views Thread by Shawn Melton | last post: by
1 post views Thread by Stephen D Cook | last post: by
3 posts views Thread by brian210 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.