View Single Post
Old 23 April 2018, 14:18   #4
idrougge
Registered User
 
Join Date: Sep 2007
Location: Stockholm
Posts: 4,337
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.
idrougge is offline  
 
Page generated in 0.04688 seconds with 11 queries