MrExcel Publishing
Your One Stop for Excel Tips & Solutions

newbie question

Posted by Tim on August 14, 2000 11:00 AM

Hello all,

I'm new to excel97 and was wondering if I could get some
help here.
Problem:I would like to be able to enter data in a certain
cell and when the (enter key)is pressed, I would like
for the cell pointer to goto another cell elsewhere on the
worksheet....any solutions?????

Thanks in advance for your time and help.
Please reply direct.

Posted by David on August 14, 0100 11:25 PM

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Dim Ans As Integer

If Target.Address = "$J$3" Then 'change this and copy as many times as you need
end if
end sub