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!
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!