Offset in a vlookup

  • Thread starter Thread starter Bob Phillips
  • Start date Start date
B

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)
 
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.
 
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.
 
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)
 
Back
Top