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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

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

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
cells selection 7
Mouse pointer or curser 1
Excel Curser Settings 1
cell selection appears locked. How do I unlock it. 1
Cells with formulas won't update unless I click in browser Why? 3
How do I unlock highlighting when I move the curser 2

Back
Top