Hi Teresse,

What about a change of method. When you double click on a cell you are
presented with a drop down list to select the required character. You could
have the letter and a description for the letter in the dropdown. Example:-

S - Sick leave.

The macro could just insert the one character or say all characters before
the hyphen sign if more than one character required.

Can include a cancel in the dropdown so that it leaves the cell as is in
case you double click by error and it gives you a way out.

If you want this then I need some more info.

What version of excel are you using? Will work with all versions since XP
(2002). Not sure about versions before that.

It is best if the worksheet can be set up so that the inserts are in a
specific column or columns. I need to know what the columns are. Also by
having specific columns the macro will only run when a cell in the specified
column/s is clicked.

A list of the options for the dropdown list (including descriptions if you
want them.)

Do you want the user to be able to add additional options for the dropdown
list?

There might be more questions before it is finished. It might sound complex
but it isn't really and I am prepared to do the work for you if you want it.

Regards,

OssieMac