View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
quartz[_2_] quartz[_2_] is offline
external usenet poster
 
Posts: 441
Default Appending special characters

I am using Office 2003 on Windows XP.

I would like to code certain buttons on a shortcut menu that when clicked
append certain symbols into the active cell always at the end of any text or
values that may already reside in the cell. I can code the shortcut menu bit
without a problem.

The characters I need are prime alpha ('A), beta, delta, and omega. I tried
recording the macro, which works ONLY for beta as: ActiveCell.FormulaR1C1 =
"ß"
The other characters come thru only as question marks.

Can someone please post some concise code illustrating how to do this?
Thanks much in advance.