Offset in a vlookup

[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.

[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" <[email protected]> wrote in message
news:[email protected]...
> 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.


On Fri, 29 Jul 2005 10:00:56 +0100, "Bob Phillips"
<[email protected]> wrote:

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

[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" <[email protected]> wrote in message
news:[email protected]...
> 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.
>
>
> On Fri, 29 Jul 2005 10:00:56 +0100, "Bob Phillips"
> <[email protected]> wrote:
>
> >Do you mean that on selecting a code you want to hide that description?
Does
> >it occupy an adjacent cell?
>

[beachcomber]

Thanks, I will try this approach.

On Fri, 29 Jul 2005 13:26:53 +0100, "Bob Phillips"
<[email protected]> wrote:

>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