Start VBA macro when editing a cell

You can’t. The code engine won’t run while Excel is in Edit mode. You have to have the user enter the text in something other than a cell – like a control on the worksheet or a control on a userform.

Leave a Comment