Tootip with vlookup

[simon_ives]

Hi all.

I'm wondering if anyone can share a method to add a tooltip that displays the results of a vlookup?

For example, I have a large vehicle tracking spreadsheet with a variety of worksheets for collating monthly data on logbook page numbers, KMs travelled, private usage, missing KMs, etc. What I'd like to do is have a tooltip appear over certain cells on one worksheet that displays the vehicle's contact person's name, as pulled from the vehicle details worksheet.

At the moment we can either add a new row and include a vlookup, but this adds too much duplicate data as the information is present on another worksheet. Or we just navigate to the vehicle details worksheet and search for the vehicle via the rego number.

Thanks in advance.

 

[JoeMo]

Sorry Michael - thought you missed post #7 while you were replying in post #8.

 

[Michael M]

Man, I miss lots of stuff....Seniors moments are the main cause...

 

[simon_ives]

Thanks for the assistance.

Unfortunately, I've added the code and I'm still not getting any comments.

I have the following code in the worksheet:

Sub Worksheet_Change(ByVal Target As Range)
If Not (Target.Comment Is Nothing) Then Target.Comment.Delete
If Target.Count > 1 Then Exit Sub
 If Intersect(Target, Range("C6:C69")) Is Nothing Then Exit Sub 'change cell range to suit
        With Target.AddComment
        .Text "The Contact Person for This Vehicle is " & _
            WorksheetFunction.VLookup(Target.Offset(0, -2), Sheets("Vehicle information").Range("$A$2:$F$72"), _
            5, False)
        End With
End Sub

The contents of column "C" is text values output from a VLOOKUP. for example, "C6" has the text "ACAT" derived from the following VLOOKUP:

=VLOOKUP(A6,'Vehicle information'!$A$2:$F$72,4,FALSE)

Thanks again.

 

[Michael M]

Have you tried stepping through manually.
At each step you can hover over a particular item and it should provide the expected outcome.

Are you getting bad data or actual errors or nothing at all
AND
I don't have Excel at the moment, but shouldn't this

If Not (Target.Comment Is Nothing)

be

If Not (Target.Comment) Is Nothing

 

[simon_ives]

Thanks for the reply Michael.

No, I just get nothing.

If I change the parentheses, as you suggested, I get an error (Compile Error: Syntax Error). When I change the code back I get nothing again.

I assume that the code is executing without error, I guess it's just not triggering the insertion of a comment.

 

[Michael M]

Can you share the workbook ??
If so, send me a PM

 

[simon_ives]

Sorry, the spreadsheet contains a chunk of confidential data so I won't be able to share it.