Automatically create checkboxes?

**devon1215** · 09-09-2011, 07:27 PM

Hi everyone! Total VBA newbie here, so please bear with me as I try to learn the ins and outs of this new language.

I have two questions:

1) Is it possible to create a userform that automatically creates a column of checkboxes?

2) Would it then be possible to automatically assign a macro to the created checkboxes?

Thanks so much for any help!

Cheers!
Devon

**MarvinP** · 09-09-2011, 08:17 PM

Hi devon1215 and welcome to the forum,

Your question is a little like a basic math student asking how to multiply matricies together. The answer is learn more and it might be easier using somethig else.

See http://support.microsoft.com/kb/204330 for the first answer.

The second question is like asking a machine to make its own decision. The phrase "automatically assign a macro to create" is advanced VBA at the least.

VBA and macros are very stupid. They only do EXACTLY what you tell them to do. The problem is to see if they have the capability to do what we want and harder to use their language to get them to follow our instructions. Many times we can't understand how we decide what we want.