In excel, can I format a cell to automatically take the curser to.
 

Can I format a cell to have the curser automatically go to a different
specified cell?

No, you cannot format anything to go anywhere. Only way of doing this would
be to use an event macro

Regards,

Peo Sjoblom

"1google" wrote:

Can I format a cell to have the curser automatically go to a different
specified cell?

Which could look like this........

''moves from C2 through E5 at entry
Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Target.Address
Case "$C$2"
Range("C5").Select
Case "$C$5"
Range("E2").Select
Case "$E$2"
Range("E5").Select
End Select
End Sub


Gord Dibben Excel MVP

On Fri, 14 Jan 2005 06:19:02 -0800, "Peo Sjoblom"
wrote:

No, you cannot format anything to go anywhere. Only way of doing this would
be to use an event macro

Regards,

Peo Sjoblom

"1google" wrote:

Can I format a cell to have the curser automatically go to a different
specified cell?