Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programmatically adding checkbox and attaching event handlers
Hello. I need programmatically add CheckBox to the worksheet and then attach
event handlers using C#. Any ideas? I am using Microsoft.Office.Interop.Excel library to do that. Unfortunately I have to use only interop library to do that. Any help would be appreaciated. thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programmatically adding checkbox and attaching event handlers
On Jun 10, 1:42 pm, guest wrote:
Hello. I need programmatically add CheckBox to the worksheet and then attach event handlers using C#. Any ideas? I am using Microsoft.Office.Interop.Excel library to do that. Unfortunately I have to use only interop library to do that. Any help would be appreaciated. thanks. Better to just create the checkbox with its code and toggle .Visible True/False. SteveM |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programmatically adding checkbox and attaching event handlers
I create the worksheet programmtically. So there is no design time support.
"SteveM" wrote: On Jun 10, 1:42 pm, guest wrote: Hello. I need programmatically add CheckBox to the worksheet and then attach event handlers using C#. Any ideas? I am using Microsoft.Office.Interop.Excel library to do that. Unfortunately I have to use only interop library to do that. Any help would be appreaciated. thanks. Better to just create the checkbox with its code and toggle .Visible True/False. SteveM |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programmatically adding checkbox and attaching event handlers
Chip Pearson shares some VBA techniques for writing code that writes code.
http://www.cpearson.com/excel/vbe.aspx Have you thought of creating a template workbook that's set up exactly the way you want, then using that in your code to create the worksheet. You could even use a hidden worksheet as your template--or an external workbook if you wanted. guest wrote: I create the worksheet programmtically. So there is no design time support. "SteveM" wrote: On Jun 10, 1:42 pm, guest wrote: Hello. I need programmatically add CheckBox to the worksheet and then attach event handlers using C#. Any ideas? I am using Microsoft.Office.Interop.Excel library to do that. Unfortunately I have to use only interop library to do that. Any help would be appreaciated. thanks. Better to just create the checkbox with its code and toggle .Visible True/False. SteveM -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help with adding Controls and event handlers at runtime | Excel Programming | |||
Need help with adding Controls and event handlers at runtime | Excel Programming | |||
Further Clarification with Event Handlers & Class Modules | Excel Programming | |||
Grouping Event handlers | Excel Programming | |||
Problems with event handlers | Excel Programming |