Excel Tabs or Form

What version of Excel are you using. I think from 2002 onwards if you set the cells in column B to be unlocked (format>cells>protection - uncheck the Locked box) then protect the worksheet and make sure that the option for users to select locked cells is turned off.

Then, as you should only be able to select the unlocked cells in column B, pressing tab should automatically move you down to the next row in the column.

However, depending on your specific requirements, it may be more appropriate to create a UserForm.

Hi, Susan,
Welcome to the Board !!!!!


Not sure why your tab would go to another sheet.
Why not use the enter or return key?

Anyway you can select your cells and use "tab" (or enter or return) to move through them.

and make sure that the option for users to select locked cells is turned off.

Then, as you should only be able to select the unlocked cells in column B, pressing tab should automatically move you down to the next row in the column.

Click to expand...

Even if you do not uncheck the option, tab will move through the unprotected cells only: that's how it works for me.

kind regards,
Erik

and make sure that the option for users to select locked cells is turned off.

Then, as you should only be able to select the unlocked cells in column B, pressing tab should automatically move you down to the next row in the column.

Click to expand...

Even if you do not uncheck the option, tab will move through the unprotected cells only: that's how it works for me.

Click to expand...

So it does