0

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

2
Contributors
4
Replies
5
Views
6 Years
Discussion Span
Last Post by JJCollins
0

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

0

thanks for quick response
but how come i can start this in VBA....
Phaiz

0

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

0

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

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.