VBA to move from one cell to another cell

[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 .....

 

[Gord Dibben]

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

 

[Khalil Handal]

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.

 

[Khalil Handal]

Sorry,
Missread your solution.
How to unlock the columns?

 

[Gord Dibben]

Select both columns by CTRL + click

Format>Cells>Protection.

Uncheck "locked"

Tools>Protection>Protect worksheet.


Gord

 

[Khalil Handal]

Thanks. It worked fine.

Select both columns by CTRL + click

Format>Cells>Protection.

Uncheck "locked"

Tools>Protection>Protect worksheet.


Gord

 

[Gord Dibben]

Good to hear.

Gord

Thanks. It worked fine.