Cursor problem Defcon Three

[ribhead]

Mr. Ribhead has a problem. I'm pretty sure the question has been asked before in some way but I couldn't find it. How can I move the cursor using command buttons? I see Application.cursormovement but that's not doing a whole lot for me. Can I use R1C1 in a formula somehow? I am very green so have some pitty on me.

I may not be very smart but I'm sure wirey!!!!

 

[ribhead]

Never mind I think I figured it out. I just assigned this code to the buttons. Maybe there is an easier way but this seems to work for me.

For Left
sub left()
ActiveCell(1,0).Select
End Sub

For Right
sub right()
ActiveCell(1,2).Select
End Sub

For Up
sub up()
ActiveCell(0,1).Select

For Down
Sub down(0
ActiveCell(2,1)
End Sub

I may not be very smart but I'm sure wirey!!!!