Creating a dynamic List of ASCII and Unicode Characters using VBA

[bearcub]

I would like to create a list of emoji, unicode, and ASCII codes using the CHAR and UniChar functions. Right now I have a number them all on several spreadsheets but it has gotten really unwieldy.

There are over 100,000 unicode codes and I would like to display some pf them on a spreadsheet or userform dynamically (the number then the symbol associated with it).

I would like the user to be able to add a range of numbers (like 10000 to 100099) to the spreadsheet then having the cells populate with the number and theassociated Code (e.g. (Char(131)-"ƒ")or UniChar(129374 -"?")
,

Is this feasible or am in dreaming? I was thinking about using labels on a userform but this might make the userform too big.

Thank you for your help,

Michael

 

[thisoldman]

Why not use the Character Map application included with Windows? It would accomplish the same thing, I think.

Using Windows 10, this app is located under Windows Accessories. You can also start the Character Map app from the Run menu, Winkey+R, then typing charmap (or charmap.exe).

 

[pgc01]

I would like the user to be able to add a range of numbers (like 10000 to 100099) to the spreadsheet then having the cells populate with the number and theassociated Code (e.g. (Char(131)-"ƒ")or UniChar(129374 -"丹")


Is this feasible or am in dreaming?

Hi Michael

I guess maybe I don't understand what you mean by this.

Is this not just something like, for ex., writing the numbers 10000 to 19999 in column A and in column B use the formula

=UNICHAR(A1)

???
Please clarify