Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
go to worksheet on button name | New Users to Excel | |||
Problem: vba code for creating a button to save worksheet as Cell | Excel Programming | |||
How do I code VBA to hit button on a different worksheet? | Excel Programming | |||
print different worksheet by pressing visible button on worksheet | Excel Worksheet Functions | |||
Find button on worksheet | Excel Programming |