VBA to move from one cell to another cell

  • Thread starter Thread starter Khalil Handal
  • Start date Start date
K

Khalil Handal

Hi,
Certain cells in a sheet needs to be filled with data. These cells are in
successive rows from 10 to 49
Data is filled in cell C10 then F10
after that cell C11 then F11
C12 and F12
until I reach C49 and F49
It is annoying to use the TAB key or the mouse to move to the next cell. Is
there a way to move to the next required cell just by pressing enter after
filling in the data.

i.e. data entered n cell C10 (press enter) go to cell F10, type the data
and press enter to go to C11,then F11 .....
 
One method

Unlock columns C and F. Protect the worksheet and use Tab key to move from C10
to F10 to C11 to F11 etc.


Gord Dibben MS Excel MVP
 
I didn't think of that. Still I need to see the content of cells in colomn
D. Hiding colomn E only will still not a practical solution.
 
Select both columns by CTRL + click

Format>Cells>Protection.

Uncheck "locked"

Tools>Protection>Protect worksheet.


Gord
 
Thanks. It worked fine.

Gord Dibben said:
Select both columns by CTRL + click

Format>Cells>Protection.

Uncheck "locked"

Tools>Protection>Protect worksheet.


Gord
Click to expand...
 
Back
Top