Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Events for CheckBox inside Excel using ExcelAddIn project

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to bind events for formsControls inside Excel patro Excel Programming 0 November 18th 08 01:52 PM
ExcelAddIn - Excel Crashes under User Account - tool to troubleshoot elime Excel Discussion (Misc queries) 0 July 3rd 07 08:06 AM
How to use mouse events inside an Excel Sheet ? mike Excel Programming 7 July 28th 04 12:23 PM
Creating a Checkbox inside a cell for each line Randy Reese Excel Programming 2 March 4th 04 02:45 AM
Capturing Checkbox Events Mark D'Agosta Excel Programming 8 October 13th 03 01:29 AM


All times are GMT +1. The time now is 02:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"