How do I add command button to tab order on a worksheet?

[Charlie4]

Hi All
I'm using cells in a worksheet for data entry (rather than a user form). User enters Name, Make and Price then clicks a command button ("ADD") to add the data to separate worksheet.

It would be much quicker if the user could just use Tab key to highlight the command button (then Enter key to "click" it) rather than using the mouse each time.


[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Name
[/TD]
[TD]Make
[/TD]
[TD]Price[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]

[enter name]​

<strike></strike>
[/TD]
[TD]<strike></strike>[enter make]
[/TD]
[TD][enter price
[/TD]
[TD][Command button: "ADD"]
[/TD]
[/TR]
</tbody>[/TABLE]


Is there a way/code to do this/add it to the tab order?

(i.e. tab order goes cell A2 > cell B2 > cell C2 > command button "ADD")

This would be hugely appreciated...

C.

 

[cooper645]

Why not use worksheet protection.

If if you make all cells locked less those you want the user to select and the command button, and then protect the sheet only allowing them to select unlocked cells, you should achieve your desired result.

HTH

Coops