Can I use WinForms "Button" from an Excel spreadsheet (VBA)?

Question

Traders are lazy and they don’t want to switch applications to buttons. When they click a button in Excel, it should be the same as pressing another button in my WinForms application (in which a dialog box appears). Doable?

Answer 1

Yes.

You need to add your functionality to the DLL [ComVisible(true)]and add a link to it in VBA.

Alternatively, you can write an Excel add-on in C #.

Answer 2

• COM-, WinForms, .
• Excel
• VBA COM-

COM WinForms , VBA GetObject. , COM, .NET.