News

A class module to let you treat time as a string. There are some reasons why you may want to treat time as as string. For example, I created a large scheduling appliction in excel through VBA. There ...
Create a UserForm containing a dynamic number of controls and make sure they are being triggered by certain events. To achieve this result, we will use a UserForm and a class module, and assign any ...
Excel-VBA-Sample-WithEvents-with-Class UserDefined Event-handlers for Multiple Controls of Same Type by Using Class (es) employing WithEvents On April 16th, 2021, someone on Reddit asked a question ...
It occurs when a module used in the project is hidden or protected or if the code written in Microsoft Excel is not targeting your application’s architecture. For instance, the excel file you are ...
The 'Master Microsoft Excel Macros and Excel VBA' class shows you how to automate and customize tasks for faster reports and more intuitive spreadsheets.
Encountered the Class not registered VBA error? Try repairing Microsoft Office, and registering a critical DLL file, amongst two other methods here.
Compile error in hidden module in Excel or Word occurs when the code is incompatible with the version or architecture of this application.
If you see Microsoft Visual Basic, Run-time error, Class not registered in Office Excel, follow these solutions that have helped many fix the issue.