View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mr.G[_3_] Mr.G[_3_] is offline
external usenet poster
 
Posts: 11
Default Add button to worksheet cell

I hope I understand correctly.
If you go into design mode and you double click the button.It will give you
a on click event. Then add code.
G

"Crusader" wrote:

Hi,

I am able to add a button in an excel worksheet cell in C# code. Now I want
to handle its click event in the C# itself.

Here is the code I have tried:

Excel.Buttons buttons = activeSheet.Buttons(System.Reflection.Missing.Valu e)
as Excel.Buttons;
Excel.Button button = null;
button = buttons.Add(5, 5, 100, 20);
button.Caption = "Trend Chart";

Now, there is one property of button class named ".OnAction". I guess we can
only define the macro name in this.
Kindly let me know how to handle its click event in C# instead of calling
macro?

Thanks,
Sunil