How do I manually edit acell during an excel Macro

**Roger Mortimer** · 04-05-2016, 10:39 AM

I want to do this:-

1. Copy named range "Date" to active cell.
2. Enter edit mode at active cell (Like pressing F2).
3. Move pointer 1 character Left.
4. Pause Macro to allow manual edit of active cell contents.
5. Resume Macro when "ENTER" is pressed.
6. Copy active cell contents to named range "Date".
7. End sub.

Any ideas welcome.

Roger Mortimer.

**Norie** · 04-05-2016, 11:06 AM

Roger

Code can't be executed when in Edit mode.

What is it you want to enter in the cell anyway?

**Roger Mortimer** · 04-06-2016, 08:38 AM

I want to edit a date ie. 6/04/2016 without the bother of typing the whole date. This was easy in Lotus 123.

**TMS** · 04-06-2016, 09:36 AM

If you just type 6/4 and press Enter, you get a date with the current year as default. For example, 6/4 gives 06/04/2016. You need the cell formatted as Date first or you might not get the format you want. Formatted as General, I got 06-Apr.