Help making a macro to modify Left arrow key behavior when editing

[zxyzgt]

Hi there,

When editing/input text in cells, I need to move the cursor back 'in-between' characters using the left arrow key. However, Excel would simply select the cell left of the current cell unless I press F2 to enter into editing mode. I was wondering if there is any way to make a macro to:
1. Check the status of the cursor.
If the cursor is in cell-selecting mode, keep the default behavior;
elif in text inputting mode, sendkeys "{F2} {Left}".

2. This macro could be triggered by the left arrow key.

Thanks in advance!

[Squeaky]

Hi zxyzgt,
I am not certain of what you are describing. I can double click to get right into insert mode, at which point I can select anywhere in the cell, or click on the cell and then select where I want to go inside the cell using the formula bar.
Under Options>Advanced do you have Allow editing directly in cells selected?

[zxyzgt]

Hi Squeaky,
Thanks for your reply.
Double-clicking to enter into the text box is a good habit. But, try to select cell and type contents directly, you will understand the awkwardness for the Left arrow key.