Dynamic Number of Check Boxes required in a Dialog Box

[amit_k74]

Can I create a Dialogbox (or write a macro ) that creates dynamic numbe
of Labels and Check Boxes based on a certain cell value.

Thus if my cell (say A1) has a value 3 then I need three check boxe
and three Labels in the dialog box. Naturally the state of boxes als
needs to be captured

If in the next run A1=7 then I need 7 checkboxes.

Can Somebody help.

Thanks in Advanc

 

[Tom Ogilvy]

You can look at John Walkenbach's example:

http://j-walk.com/ss/excel/tips/tip76.htm

You should be able to adapt it to your purpose.

 

[amit_k74]

Thanks for your help!!!

I tried testing the sample code but at the following line :


Dim NewOptionButton As Msforms.OptionButton


It gives a compile - user defined type not defined. Please Help. Thank
in advance