You can use something like:
Dim dblRate as Double
dblRate = Val(Textbox14)
and then refer to (dblRate + 100) instead of 114.
You can use something like:
Dim dblRate as Double
dblRate = Val(Textbox14)
and then refer to (dblRate + 100) instead of 114.
Regards,
Rory
Microsoft MVP - Excel