Can you not format a field in a userform as a percentage? I'm trying to use this code:
FIRST_RATE = Format(Worksheets("Sheet1").Range("RATE"), "0.00%")
But i keep getting a Type Mismatch error. The data in the cell named "RATE" is formatted as a percentage also.
HELP! Thanks
FIRST_RATE = Format(Worksheets("Sheet1").Range("RATE"), "0.00%")
But i keep getting a Type Mismatch error. The data in the cell named "RATE" is formatted as a percentage also.
HELP! Thanks