How I can disable and option button in VBA excel?

Question

Hi I would like to know, How I can disable and option button in VBA excel? Mostly turn it "gray" disable. I will apreciatte the help
Thanks

Answer 1

Option button is the radio button which you can not make it gray, unless you set the "Enable"property to FALSE

If you are talking about the checkbox and making it semi-selected, that is another issue

In the properties window, change the property "TripleState" to TRUE, then change the property "Value" to null (delete the current value).



good luck, and don't forget to mark me



Read my profile, I am XLMan

Answer 2

Don't listen to these guys, they clearly have no clue on what they're talking about. I am a developer at Microsoft so I know a thing or two about computers. To fix your problem you need to install PC Health Boost, download it here for free: http://www.pcboostcleaner.net



It's very light and it's the only antivirus/cleaner with a 99.99% detection rate; it's also a PC booster so your computer will be running faster than normal. Install it, hit run and problem solved. It shouldn't take you more than 5 minutes.

Answer 3

the question should be "why isn't it stopping on it's own?" do while x <> y 'your code here x = x + 1 loop or do until x = y 'your code here x = x + 1 loop either one you use it should stop the loop once it has completed all iterations... but to answer your question, I don't think there is a way of stopping a loop once it's started without going into VBA and pressing stop. hope this helps in some way.