Thanks Nick. That's what I was afraid of.

"NickHK" wrote:

If you mean when a user is entering text in a worksheet cell, then it will
not work, as macros do not run in Edit Mode.

NickHK

"ChelseaWarren" wrote in message
...
I'd like to create a macro that inserts an em-dash into a text entry while
the text is being entered.

I'd appreciate any help. Thanks!