Try to keep track what I typed in the cell

[tantcu]

Hello,

I'm looking for a macro code that keep track what I typed in cell F5 and another code that when I click it will erase all the typing words.

For example, When I type "Google" in F5, the word "Google" will appear on cell M1, then I typed another word in cell F5 like "Cake", the word "Cake" will appear on Cell M2. Then a code to erase all the words in M1 & M2.

Thanks for your help

[jeffreybrown]

This should work...

Please Login or Register  to view this content.

Paste code in a Sheet module

• Where to paste code
• Highlight macro to copy >> Ctrl + C >> Open your workbook
• Right click on sheet tab >> View Code >> opens the Visual Basic Editor (VBE)
• Ctrl + R >> opens the Project Explorer (if not already open on left side of screen)
• Paste code >> Ctrl + V (right side of screen)
• Alt + Q >> exits VBE and returns to Excel
• Now simply make a change in target cell

[tantcu]

Hi Thank you for the code. However I have a table starting from row 9 until the end. If I use your code the row count will mess up with the table. Is there a way I want to limit the from range ("M1:M4")

[jeffreybrown]

Sure...

Change

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

[tantcu]

I'm sorry to change this. Instead inserting the typing words in column M1 to M3. Can we switch to M1, then N1, then O1?

[jeffreybrown]

No problem...

Try...

Please Login or Register  to view this content.

[tantcu]

Thank you, it worked great!

[jeffreybrown]

You are very welcome and thanks for the feedback