Typing Unicode characters in Excel

[EDN Admin]

<span style="font-family:Times New Roman; font-size:small
<p style="margin:0cm 0cm 3pt http://office.microsoft.com/en-us/excel-help/insert-ascii-or-unicode-latin-based-symbols-and-characters-HA010167539.aspx <span style="color:#0000ff; font-family:Book Antiqua; font-size:small http://office.microsoft.com/en-us/excel-help/insert-ascii-or-unicode-latin-based-symbols-and-characters-HA010167539.aspx <span style="font-size:small <span style="font-family:Book Antiqua
describes how to type Ascii and Unicode characters. The Ascii method is fine in both Word and Excel. The Unicode method works in Word, so 0100 Alt+X produces Ā (Macron A) but it doesnât work in Excel.<br/>
The link indicates â<span lang="EN-US" style="color:#666666; font-family:"Segoe UI","sans-serif" Some of the Microsoft Office programs, such as PowerPoint and InfoPath, cannot convert Unicode codes to charactersâ,<span lang="EN-US" style="color:#666666; line-height:115%; font-family:"Segoe UI","sans-serif"; font-size:9pt
<span style="font-family:Book Antiqua; font-size:small no mention of Excel. Is there a plug-in needing to be activated or is Excel akin to Powerpoint.<br/>
<br/>
Found a URL with this VBA code<br/>
<span lang="EN" style="color:#3e3e3e; line-height:115%; font-family:"Tahoma","sans-serif"; font-size:10pt In the ThisWorkbook module insert code similar to:<br/>
<span lang="EN" style="color:darkblue; line-height:115%; font-family:"Tahoma","sans-serif"; font-size:10pt Private<span lang="EN" style="color:#3e3e3e; line-height:115%; font-family:"Tahoma","sans-serif"; font-size:10pt
<span lang="EN" style="color:darkblue; line-height:115%; font-family:"Tahoma","sans-serif"; font-size:10pt Sub<span lang="EN" style="color:#3e3e3e; line-height:115%; font-family:"Tahoma","sans-serif"; font-size:10pt Workbook_Open()<br/>
Application.OnKey "{F8}", "mySub"<br/>
<span lang="EN" style="color:darkblue; line-height:115%; font-family:"Tahoma","sans-serif"; font-size:10pt End<span lang="EN" style="color:#3e3e3e; line-height:115%; font-family:"Tahoma","sans-serif"; font-size:10pt
<span lang="EN" style="color:darkblue; line-height:115%; font-family:"Tahoma","sans-serif"; font-size:10pt Sub<span lang="EN" style="color:#3e3e3e; line-height:115%; font-family:"Tahoma","sans-serif"; font-size:10pt <br/>
<br/>
In a standard module:<br/>
<span lang="EN" style="color:darkblue; line-height:115%; font-family:"Tahoma","sans-serif"; font-size:10pt Sub<span lang="EN" style="color:#3e3e3e; line-height:115%; font-family:"Tahoma","sans-serif"; font-size:10pt my<span lang="EN" style="color:darkblue; line-height:115%; font-family:"Tahoma","sans-serif"; font-size:10pt Sub<span lang="EN" style="color:#3e3e3e; line-height:115%; font-family:"Tahoma","sans-serif"; font-size:10pt ()<br/>
âI intended to write a routine to convert to Unicode character here ...<br/>
The F8 key arrives here if the cursor is inactive but as soon as characters are typed, the F8 key stops responding<br/>
<span lang="EN" style="color:darkblue; line-height:115%; font-family:"Tahoma","sans-serif"; font-size:10pt End<span lang="EN" style="color:#3e3e3e; line-height:115%; font-family:"Tahoma","sans-serif"; font-size:10pt Sub<span style="font-size:small <span style="font-family:Book Antiqua <span lang="EN
<br/>
<br/>
Is it possible in Excel to intercept a Function key-press in the middle of an active keyboard buffer?
<span style="font-family:Times New Roman; font-size:small

View the full article