Can I format a cell to have the curser automatically go to a different specified cell?
1 1google Jan 14, 2005 #1 Can I format a cell to have the curser automatically go to a different specified cell?
P Peo Sjoblom Jan 14, 2005 #2 No, you cannot format anything to go anywhere. Only way of doing this would be to use an event macro Regards, Peo Sjoblom
No, you cannot format anything to go anywhere. Only way of doing this would be to use an event macro Regards, Peo Sjoblom
G Gord Dibben Jan 14, 2005 #3 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
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
