Add button to worksheet cell
Hi,
We are adding button programmatically to the Excel Worksheet. So, button
will be available only at run time. There is no such option to double click
it and write desired code for the click action.
Thanks,
Crusader
"Mr.G" wrote:
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
|