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

1

1google

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

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Paste to excel from word - auto format problem 1
How can I unfreeze curser in Excel 2007? 1
can I insert a picture so it comes up when I put curser over cell 6
How can I vew my curser in typed table cells? 3
Place picture in Excel cell 0
cells selection 7
Excel - Wich Function should I use? 1

Top