Select next adjacent cell

[WAF875]

I want to use a command button to enter a number in a cell, on the second press it goes into the adjacent cell and third press the next adjacent cell and so on. I have tried using GoTo and GoSub if the cell is not blank but it only works for the first two number then stops. Thanks

 

[My Aswer Is This]

We need more details. what number do you want to put in first cell?
And what cell is the first cell?
What number do you want in adjacent cell?
When you say adjacent do you mean one row below?
Adjacent may mean up down left or right.

 

[WAF875]

We need more details. what number do you want to put in first cell?
And what cell is the first cell?
What number do you want in adjacent cell?
When you say adjacent do you mean one row below?
Adjacent may mean up down left or right.

When I click the button I need "1" to go into A1 on the next click I need "1" to go into B1 on the next click I need "1" to go into C1 and so on.
I will have numerous buttons with different numbers but once I get one sorted they will all fall in line