Microsoft Visual Basic Automation Error

I'm an intern in a MNC. I have to use a design calculator that is built in Excel (Idk we could do that). The calculator works for my senior employees who have shared me the same file they're using but it doesnt work for me.

please refer to the images here & here

It has all macro script, some VBA project.. I'm not aware with excel features.

we use the same excel version, same macro settings, I tried restarting my laptop, running solely the excel file, still it doesnt work.
I already rasied a ticket for the issue, but they dont seem to have a soln as well..

I'm stuck! My project is halted without the calculator working. Even my senior employees couldn't figure out whats wrong with it...

The calculator in the excel was built by employees of my organisation itself.. but i can't contact them anymore because they're no longer in the organisation.

When we hit 'Run Form', ideally it should run and a new dialogue window should pop up with input parameters and stuff.. but I get an error instead.