ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   go from input cell to input cell (https://www.excelbanter.com/excel-programming/321671-go-input-cell-input-cell.html)

Toinett

go from input cell to input cell
 
I would like to have cursor go from input cell to input cell as Enter or Tab
are clicked by user.

JulieD

go from input cell to input cell
 
Hi Toinett

if you protect the worksheet - other than the cells where you want data
entered - then Excel's default behaviour is for the tab key to do just what
you want.

Cheers
julieD

"Toinett" wrote in message
...
I would like to have cursor go from input cell to input cell as Enter or
Tab
are clicked by user.




Don Guillett[_4_]

go from input cell to input cell
 
protect all cellsunlock input cellsprotect worksheetuse tab key

--
Don Guillett
SalesAid Software

"Toinett" wrote in message
...
I would like to have cursor go from input cell to input cell as Enter or

Tab
are clicked by user.




Toinett

go from input cell to input cell
 
When I use Tools/Protection/Protect Sheet, Tab has no effect on the edited
cells. Am I using the protection you are talking about?

"Don Guillett" wrote:

protect all cellsunlock input cellsprotect worksheetuse tab key

--
Don Guillett
SalesAid Software

"Toinett" wrote in message
...
I would like to have cursor go from input cell to input cell as Enter or

Tab
are clicked by user.






All times are GMT +1. The time now is 05:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com