I am learning Spanish and creating my own dictionary as I go. I want to make a macro that will let me quickly insert one of the accented Spanish characters (like á, for example). I can write a macro that does that, but it will only let me insert the symbol as a single letter in the cell, not after other characters in the word that come before the á. nor can I add additional text in the cell after the insertion. What am I doing wrong and what should the macro read like to allow special characters to be inserted in the middle of a text string being entered by the user?
TIA.