Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding multiple checkboxes in a single cell | New Users to Excel | |||
adding multiple checkboxes in a single cell | New Users to Excel | |||
Adding multiple checkboxes | Excel Discussion (Misc queries) | |||
Can i set a reference programmatically? | Excel Programming | |||
Adding Checkboxes | Excel Programming |