Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I am developing an Excel Addin using VS2008 and VSTO3.0,On click of one of the buttons on the ribbon it creates check boxes inside Excel.to create checkBox i followed the following approach Excel.Range cell = _mWorkSheet.Cells[i, 1] as Excel.Range; Microsoft.Office.Interop.Excel.Shape shape; // shape = _mWorkSheet.Shapes.AddFormControl(Microsoft.Office .Interop.Excel.XlFormControl.xlDropDown, Convert.ToInt32(cell.Left), Convert.ToInt32(cell.Top), Convert.ToInt32(cell.Width), Convert.ToInt32(cell.Height)); shape = _mWorkSheet.Shapes.AddFormControl(Microsoft.Office .Interop.Excel.XlFormControl.xlCheckBox, Convert.ToInt32(cell.Left), Convert.ToInt32(cell.Top), Convert.ToInt32(cell.Width), Convert.ToInt32(cell.Height)); shape.Name = "checkbox"+i.ToString(); Now i want to know how can i bind any event to checkboxs inside excel cell. Thanks, Patro |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to bind events for formsControls inside Excel | Excel Programming | |||
ExcelAddIn - Excel Crashes under User Account - tool to troubleshoot | Excel Discussion (Misc queries) | |||
How to use mouse events inside an Excel Sheet ? | Excel Programming | |||
Creating a Checkbox inside a cell for each line | Excel Programming | |||
Capturing Checkbox Events | Excel Programming |