How to set Tab order in Excel sheet VBA

[rafeemd]

Hi All,

Is there any way to set the tab order in Excel sheet.

I have a sheet with 12 columns.
what i required is when data entring, it go by next column.
when data is entering at A1, then the tab/enter presses the cursors must go to B1 till all the columns complete,
then only it go by A2 otherwise, if the user gone at A3 without entering data into A2, the cursor should go at A2.

Example

A---- B---- C---- D
1---- 2---- 3---- 4
5---- 6---- 7---- 8

9---- 10---- 11---- 12

Thanks in Advance.

[royUK]

You can aet the direction in Tool -> Options

[rafeemd]

Thanks Roy for your suggestion.
But i need to do it through VBA for a spreadsheet, when the user entering data it moves forward only till last column, after completion of record then it moves to first of next row. otherwise it select the next column of that incomplete row.

Thank you

[kvsrinivasamurthy]

After settig the direction in Tools-> options, Select the area in which you want enter data.Then start entering data. curser moves in the selected area only.

[rafeemd]

Thank You Srinivasamurthy for your early reply

But i need to do it through VBA code only. because it is not possible to select the range manually always and
we dont know the range how much data we will enter.
is it possible to do dynamically (VBA).

Thanks