Move to a specific cell on exit of current

  • Thread starter Thread starter jafo1
  • Start date Start date
J

jafo1

I'd like to move to a specific cell on exit of the current cell. Can
do this?

Thanks
 
Private Sub Worksheet_Change(ByVal Target As Range)
Range("B3").Select
End Sub

Put this in the appropriate sheet module.
 
I want to enter a value in cell b1 then hit the enter key an
automatically move to cell d8
 
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

Move cursor to specific cell on exit 5
Trying to run excel vba code when cell value changes from empty to entered value. 1
Moving a bunch of data 1
Help with formula 1
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Excel Need assistance with modifying a Duplicate declaration. 13
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
Excel Msgbox runing beyond posted cell range. 1

Back
Top