Macro to select cells in column enter data then press enter

N

NP

I need to create a macro and assign it a macro button at the top of the
worksheet (with the text Enter Hours) . This macro needs to select the cells
in Colum E (called Hours) enabling me to enter hours in, pressing Enter after
each figure.

Can someone help me with a formula and how to record this macro?

Thanks in advance.
 
G

Gord Dibben

Excel has no way of knowing when to press ENTER while you are typing in a cell.

It does not know what is in the cell until you leave the cell.

Use your finger to hit the ENTER or downarrow key when you want to leave the
cell.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Assign macro to enter 1
Macro to copy value in field and insert it into filter 2
macro to move to another cell 8
move to the right after hitting enter using macros 2
Access Macro Repeat Expression using value of a field in table 0
Prevent event macro from executing on ALT-Enter 5
VBA Excel - Select a value from one cell in Excel to update a SQL table 1

Top