Offset in a vlookup

[Bob Phillips]

Do you mean that on selecting a code you want to hide that description? Does
it occupy an adjacent cell?

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[beachcomber]

This maybe an easy question, I need to create a list of time codes
with descriptions, but once selected, I only want the code, not the
descriptions to display. I have been trying to incorporate an Offset,
Any ideas.

 

[beachcomber]

Yes it would, this is a time code descrption of work issue. As the
user selects their job description by the text description, I need to
offset to the appropriate code no.

 

[Bob Phillips]

So no hiding, just reselect?

'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.


Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 2 Then
Target.Offset(0, -1).Select
End If
End Sub


--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[beachcomber]

Thanks, I will try this approach.