Open an Excel workbook on your PC. You can now close the VBA window and go back to your Excel sheet. Pick a cell, type ...

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

Advanced Excel Formula Writing. In addition to its core features, AFE also integrates with GitHub, allowing users to import modules directly into Excel.

Right now it only works in a formular but i really need to be a function with input / output in a module so i can call it from the whole project.

This is why you should put any code which acts on Cells directly in the Worksheet objects module.<BR><BR>If you would like to see a sample VBA Excel project, send me a PM, and I'll send you one ...