Hi,
I am trying to get a text box on a VBA user form in Excel to automatically calculate based on the inputs of 2 other text boxes on the same user form.
For example, let's call Text Box1 "Price" and Text Box2 "AmountPaid". I want Text Box3 (AmountOwing) to calculate the difference between the amounts manually typed in these 2 text boxes by the user and automatically populate Text Box3 with the result.
Any suggestions on the best way to do this? Does anyone have a good example I can replicate or feel like coming up with some code?
Much appreciated!
I am trying to get a text box on a VBA user form in Excel to automatically calculate based on the inputs of 2 other text boxes on the same user form.
For example, let's call Text Box1 "Price" and Text Box2 "AmountPaid". I want Text Box3 (AmountOwing) to calculate the difference between the amounts manually typed in these 2 text boxes by the user and automatically populate Text Box3 with the result.
Any suggestions on the best way to do this? Does anyone have a good example I can replicate or feel like coming up with some code?
Much appreciated!