VB.Net addin for Excel with UserForms using ExcelDNA

The next installment of my experience in migrating an add-in to ExcelDna is now updated (4-May) at:

 Migrating Excel VBA Add-in to VB.Net, ExcelDNA, NetOffice

This builds on the documents in the previous posts:

  • Getting Started with VB.Net using ExcelDNA.docx
  • Practice project converting XLAM to ExcelDna.docx

It describes how I converted UserForms, Ribbon interface complications, and easing compatibility with VBA code using helper functions. Nothing special here for anyone who uses ExcelDna or vb.net already, it is intended for people starting out.

Corrections and enhancements welcome!


About Patrick O'Beirne, Excel/VBA developer

Patrick provides consultancy and training in spreadsheet automation, data analysis, testing and model review; and the Excel spreadsheet auditing addin XLtest
This entry was posted in Excel/VBA, ExcelDna and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s