Dynamic Number of Checkboxes

Hello All,

I'm having a bit of problems with a certain macro I'm trying to put together. This one is very tempermental, and works here or there, and crashes my excel; and also does a lot of other weird things to the excel program.

I'm trying to make check boxes appear, based on a value in cell("a1").

Please Login or Register  to view this content.

the error occurs when I try to insert the following line within the IF statement, underneath the object deleter.

Please Login or Register  to view this content.

and change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

I don't know what rules I'm breaking... Can someone help me out?

Thanks,
1980

If anyone is following this post, the errors I'm getting are

Run-time error '02147417848 (80010108)

Error 438

After doing some research, I think it has to do with the objects getting pulled away from the sheet.

1980

If anyone is following this post, the errors I'm getting are

Run-time error '02147417848 (80010108)

Error 438

After doing some research, I think it has to do with the objects getting pulled away from the sheet. Also, other weird things that are happening are:
1. the letters at the top change to numbers, if my mouse moves over them.
2. the value in the formula bar starts to flicker
3. everything just freezes, to the point where I have to go to the task manager to stop excel; alt+break won't work.

1980

If anyone is following this post, I think I came up with some solutions.

1. the code that deleted objects also delted the drop down list objects. I found a really good page that offered solutions and explanations to what is occurring.
http://www.rondebruin.nl/controlsobjectsworksheet.htm

2. I seperated the c and myRange Dim statements
3. I found a workaround for trying to delete the linked cell values. I think this is where the main problem was. Something was happening in the background of Excel when I was trying to insert clearcontents into the For Each Loop that wrote the checkbox objects.

1980