Mid$ gives you the character at a certain position, Asc() will give you the ascii code for a character, so Asc(Mid$(S$,T,1)) will give you the ascii code for the character at position T (which could be the counter in a For…Next loop, for instance). The letter A is ascii code 65, so just put your icons in the alphabetical order and subtract the difference between 65 and the position of the letter A in your bank and you'll get the correct icon number to paste.
|