hi
I want to write a VBA program, where i want to convert the currency notes into coins. I made a userform with one label, one textbox and one command button. Simply i want to write the codes under command button and want to run the program. After running the program i want to write the one number for example 55 dollor and wanted to convert into different coins.
or if some one have better idea how to start this can also be welcomed
Can any one please help me....
thanks in advance
There's a LOT of combinations for each note though surely?
For example a £5 note in UK Sterling can be made up of
5 x £1
2 x £2, 1 x £1
25 x 20p
50 x 10p
1 x £1, 8 x 50p
1 x £2, 2 x £1, 2 x 50p
and more
- Jordan
thanks for quick response
but how come i can start this in VBA....
Phaiz
Well it's just a case of mathematics i suppose, how many times can you divide the value by other values, I'd recommend looking on Google first for basic VBA tutorials before even attempting to make this program.
- Jordan
Alternatively, I could have misinterpreted your original question.
Do you want to know the possible coin combinations that would go into a note or do you want to know how many of each coin go into the note?
For example, £5 sterling
500 x 1p
250 x 2p
100 x 5p
50 x 10p
25 x 20p
10 x 50p
5 x £1
2.5 x £2
1 x £5(coin)
I'd like you to clarify, as the method i've just posted is relatively simple to achieve :)
- Jordan
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.