![]() |
How to bind events for formsControls inside Excel
Hi,
I am developing an Excel Addin using VS2008 and VSTO3.0,On click of one of the buttons of 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 |
All times are GMT +1. The time now is 12:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com