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 ...

Modules are just bags of code, intended to be shared between more than one worksheet or object. You can't explicitly place modules into the Objects folder; code that lives there is actually contained ...

On the Developer tab, click the Visual Basic button in the Code group. A Microsoft Visual Basic for Application window will open. Click the Insert tab and select Module in the menu. A new model is ...

This is essentially a republish of Jan Karel Pieterse’s article https://jkp-ads.com/Articles/performanceclass.asp. So all credits go to him! The main reason for ...

Hamza is a certified Technical Support Engineer. The “Compile error in hidden module” error occurs when you open a VBA project in Microsoft Excel. It occurs when ...