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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top