View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jono1970 jono1970 is offline
external usenet poster
 
Posts: 1
Default help to speed up adding check box


hello,

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

Thanks in advance.

Jon

--
jono197
-----------------------------------------------------------------------
jono1970's Profile: http://www.excelforum.com/member.php...fo&userid=1565
View this thread: http://www.excelforum.com/showthread.php?threadid=27193