Excel Application Settings
2016-01-25
Short Description Create an Excel Add-in that allows you to add Application Settings functionality on any Workbook. Store and retrieve setting names and values on a centralised location and accessible anywhere from your VBA modules and classes. Ingredients Microsoft Excel The Need Sometimes when you are creating an Excel tool or application, you need a centralised place where you can save and retrieve settings form. As you express the business logic of your application in the form of code on the Visual Basic for Applications (VBA) environment, you’ll realise that it’s handy to have a place where you could store and retrieve key-value pairs from any partRead More →