Using selected cell instead of typing input into vlookup?

**RWheldon** · 01-26-2009, 08:46 AM

Hi,

I am probably going beyond the realms of excel here. Is it possible to click on a cell and use the cell info as the input data for a search instead of typing data into a cell for a vlookup?

For example, I have a spreadsheet with numbers corresponding to stock codes. Would it be posible to just click on the stock number to return the information on the stock (levels, sizes etc...) instead of typing the stock code in for a vlookup calculation.

I am happy with how the vlookup works, just trying to cut corners.

Thanks,

**davesexcel** · 01-26-2009, 08:53 AM

What's supposed to happen when you click the cell?

**davesexcel** · 01-26-2009, 09:14 AM

Here's a small example

**RWheldon** · 01-26-2009, 09:30 AM

Thanks for reply. Were I work is a large sales yard containing many static caravans. These are always being moved around so I deceided to create a spreadsheet which would highlight a chosen caravan. (see attached). This can then be printed and taken as a 'map'. What I would like to do with it, is when a caravan (number) is clicked on, it will populate the detailed information on the right hand side of the spreadsheet (currently manually typed in using vlookup to my data spreadsheet).

I hope this explains a little clearer?

Thanks again.

**royUK** · 01-26-2009, 09:39 AM

Use this code,

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
    If IsNumeric(Target.Value) Then
        Cancel = True
        Range("ab4").Value = Target.Value
    End If
End Sub