Turn on the macro recorder while you do it manually. then generalize the
code and put in a loop.

--
regards,
Tom Ogilvy

"jono1970" wrote in message
...

hello,

I need to place 50 check boxes in column D of my worksheet. Currently
I go to *view*, *toolbox*, *forms* and drag a check box object in to a
cell. I then have to edit, size and place it within the cell. Is there
a way to quickly replicate this in VBA. I would appreciate it if
somebody could show me how to do this.

Thanks in advance.

Jono


--
jono1970
------------------------------------------------------------------------
jono1970's Profile:
http://www.excelforum.com/member.php...o&userid=15658
View this thread: http://www.excelforum.com/showthread...hreadid=271931