SilverSixx
New Member
- Joined
- Jul 6, 2020
- Messages
- 2
- Office Version
- 2010
- Platform
- Windows
I'm new to VBA and I've come across something that's causing me a problem and hopefully someone can help me out.
I have 3 text boxes, one of which is a total cost and this figure is populated automatically. I have one text box which is where a currency amount can be typed in (a portion of the total cost) and another one where a percentage (again, a percent of the total amount) can be typed in.
What I am trying to do is to have the user either type in an amount which will them show the percentage of the total amount, or a percentage of the total amount which will then show the currency amount in relation to that percentage.
As an example:
The total amount is £1000.00. The user knows they will be paying £500.00 so that is typed in the currency text box and the percentage text box shows 50%.
I can do the calculations individually but when I run the form the code contradicts itself and I don't get the correct results.
Any ideas?
I have 3 text boxes, one of which is a total cost and this figure is populated automatically. I have one text box which is where a currency amount can be typed in (a portion of the total cost) and another one where a percentage (again, a percent of the total amount) can be typed in.
What I am trying to do is to have the user either type in an amount which will them show the percentage of the total amount, or a percentage of the total amount which will then show the currency amount in relation to that percentage.
As an example:
The total amount is £1000.00. The user knows they will be paying £500.00 so that is typed in the currency text box and the percentage text box shows 50%.
I can do the calculations individually but when I run the form the code contradicts itself and I don't get the correct results.
Any ideas?