View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Adding Checkboxes Programmatically

What kind of checkbox - control toolbox toolbar or forms toolbar

Put you your code that creates the checkbox.

--
Regards,
Tom Ogilvy

Mark D'Agosta wrote in message
. net...
Anyone know how to programmatically add check boxes to a worksheet? I'd
like to add a check box in the first column of each new row that is added

to
a worksheet. The number of rows is not known at design time and the check
box should be completely contained within the cell in the first column. I
had some success using the Worksheet_Change event to create a checkbox,

but
am unable to control the positioning of it. Any help will be greatly
appreciated.

Thanks,

Mark D.