MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How to control which will be the next cell for input.

Posted by MiltonJ on February 07, 2002 3:30 PM

I have a form, ie. invoice etc. I would want the user to fill in a certain cell, then hit enter, and continue to the next cell that I would want, not necessarily the adjoining cell. This would be similar to a data entry form in database programs. Is this possible without VBA/Macro?

Thank you.

Posted by anno on February 07, 2002 4:00 PM

select all the cells you want users to fill in (hold down ctrl key to select multiple cells). go to format menu>cells>protection tab, and uncheck the 'locked' checkbox. then go to tools menu>protection>protect sheet or protect workbook. after you have set the protection, users only have to press tab to go to the next cell to fill in.

Posted by MiltonJ on February 08, 2002 7:18 AM

Thanks Allan, it works fine!!!!