| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Macro to select cells in column enter data then press enter
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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Macro to select cells in column enter data then press enter
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 On Tue, 19 Feb 2008 21:10:00 -0800, NP wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I press enter inside a cell? | Excel Discussion (Misc queries) | |||
| Can I enter/sort multiple data within cells of a column? | Excel Discussion (Misc queries) | |||
| How do I make the cursor move down 8 cells each time i press enter | Excel Worksheet Functions | |||
| Is there a way to skip over fields when I press the ENTER key? | Excel Discussion (Misc queries) | |||
| When I Press the Enter Key Nothing happens. | Excel Discussion (Misc queries) | |||
Linear Mode
