I am creating a user form in Excel where the user needs to enter first the parameters necessary for the calculations I coded beforehand. However, there will be calculations that are user-specific. The calculations will require the same parameters the user entered so I can just use the text box name as reference but I can’t seem to think of a code that will recognize that the formula entered is the equation it will use.
My end-users are broad so as much as possible, I am creating an excel file that is as generic as possible I could get. Majority of the calculations are generic to all users so I can code it before they use it.
I haven’t tried anything yet since I have no idea yet how to create the code to solve my problem.