Adding Checkboxes Programmatically
 

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.

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.