I'm currently getting my VB userform to look at a certain cells contents then just display based on whatever that box is. But If i move those boxes etc it crashes out on the userform and I have to go change location of where to lookup etc.

Is their a way I can to get it to read in the 3 values I set then do the calculation fromVB rather than do the calculation on the excel form then display thats output?

Thanks in Advance