UserForm Screw Up - Help!

L

L.A. Lawyer

I created a beautiful, but very complex, UserForm with lots of OptionButtons
and programming. Then I realized that I should have used CheckBoxButtons!

Is there a quick way, presumably using VBA, to change all of the buttons to
CheckBoxes? If not, how do I that manually?
 
J

Jean-Guy Marcil

L.A. Lawyer was telling us:
L.A. Lawyer nous racontait que :
I created a beautiful, but very complex, UserForm with lots of
OptionButtons and programming. Then I realized that I should have
used CheckBoxButtons!
Is there a quick way, presumably using VBA, to change all of the
buttons to CheckBoxes? If not, how do I that manually?

If you created the form manually (Design Time) instead of creating the
controls at RunTime, then no, not really.

All the code you would need might be longer to figure out and run than it
will take you to make the changes manually.

Why do you want to change them?
 
Top