HI ALL,

I have a VLOOKUP function that automatically fills in Column E for me, when I
put data into Column D. So how can I get Excel to automatically go to Column
F instead of Column E when I hit the TAB button?

Thanks!


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200510/1

One way to skip over a cell (or a column) with the TAB key
is to protect the cell(s) and turn on protection. That would not
work for you if you are adding more information, like inserting rows.

Another way would be to use an Event Macro.
http://www.mvps.org/dmcritchie/excel/event.htm#ws_sc


Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.column < 5 then exit sub
On error resume next 'MUST reenable events...
Application.EnableEvents = False
ActiveCell.Offset(0, 1).Select
Application.EnableEvents = True
End Sub
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"eternal_cat via OfficeKB.com" <u14645@uwe wrote in message news:55cc70c20d566@uwe...
HI ALL,

I have a VLOOKUP function that automatically fills in Column E for me, when I
put data into Column D. So how can I get Excel to automatically go to Column
F instead of Column E when I hit the TAB button?

Thanks!


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200510/1

oK, and how do I do this?



David McRitchie wrote:
One way to skip over a cell (or a column) with the TAB key
is to protect the cell(s) and turn on protection. That would not
work for you if you are adding more information, like inserting rows.

Another way would be to use an Event Macro.
http://www.mvps.org/dmcritchie/excel/event.htm#ws_sc

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.column < 5 then exit sub
On error resume next 'MUST reenable events...
Application.EnableEvents = False
ActiveCell.Offset(0, 1).Select
Application.EnableEvents = True
End Sub
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

HI ALL,

[quoted text clipped - 3 lines]

Thanks!


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200510/1

Hi Eternal_cat,

As explained in the link supplied by David

http://www.mvps.org/dmcritchie/excel/event.htm#ws_sc

right-click the sheet tab and paste the code. Return to Excel with Alt-F11


---
Regards,
Norman



"eternal_cat via OfficeKB.com" <u14645@uwe wrote in message
news:55cd17522c8b2@uwe...
oK, and how do I do this?



David McRitchie wrote:
One way to skip over a cell (or a column) with the TAB key
is to protect the cell(s) and turn on protection. That would not
work for you if you are adding more information, like inserting rows.

Another way would be to use an Event Macro.
http://www.mvps.org/dmcritchie/excel/event.htm#ws_sc

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.column < 5 then exit sub
On error resume next 'MUST reenable events...
Application.EnableEvents = False
ActiveCell.Offset(0, 1).Select
Application.EnableEvents = True
End Sub
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

HI ALL,

[quoted text clipped - 3 lines]

Thanks!


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200510/1

nO, i WANTED TO GO TO THE NEXT CELL, SO SKIP E AND GO TO F. YUP. NOT THE NEXT
ROW.


Norman Jones wrote:
Hi Eternal_cat,

As explained in the link supplied by David

http://www.mvps.org/dmcritchie/excel/event.htm#ws_sc

right-click the sheet tab and paste the code. Return to Excel with Alt-F11

---
Regards,
Norman

oK, and how do I do this?

[quoted text clipped - 23 lines]

Thanks!


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200510/1

Hi Eternal_Cat,

Try:

'=================
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Columns("D:D")) Is Nothing Then
Target.Offset(0, 2).Select
End If
End Sub
'<<=================


---
Regards,
Norman


"eternal_cat via OfficeKB.com" <u14645@uwe wrote in message
news:55cf47fba1f30@uwe...
nO, i WANTED TO GO TO THE NEXT CELL, SO SKIP E AND GO TO F. YUP. NOT THE
NEXT
ROW.


Norman Jones wrote:
Hi Eternal_cat,

As explained in the link supplied by David

http://www.mvps.org/dmcritchie/excel/event.htm#ws_sc

right-click the sheet tab and paste the code. Return to Excel with Alt-F11

---
Regards,
Norman

oK, and how do I do this?

[quoted text clipped - 23 lines]

Thanks!


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200510/1

You could also place your "looked up" column somewhere else.
Key sorting data like postcodes can be very handy placed in the column
to the left, but I often place "looked up data" waaaaay over to the
right.

HTH
Geoff