Hello,
Apart of the Excel file which contains the VBA program and any other files this program uses (sample files at least), I will need to know the Excel version(s) you are using, the OS system version, as well as the system's architecture (32-bit or 64-bit).
A few words about me: I'm developing VBA programs for more than 15 years and I'm a trainer of Excel and VBA (all levels) for 12+ years. As you can guess, I have not only created a plethora of VBA macros of any kind, but also fixed a plethora of VBA macros for both training purposes and business.
Looking forward to hear from you,
Kind regards,
Chriskerpini