how to update a cell by clicking on an image

[peterdominic]

I'm creating a dashboard that shows trucking lanes (picture a line image) on top of a map. My vision is to have the lines change colors based on a reference table <-- this part seems straight forward. But I'm struggling with the 2nd part of the vision -- I'd like the dashboard user to be able to click on any given line image (there will be dozens of lines) and have Excel populate the name of that image into a reference cell that would vlookup tables so charts would update. For instance, by clicking on the line between Dallas and Denver, I'd get my charts to show info related to that trucking lane.

Can anyone help me with how to click on an image and have a cell pull the name into it?

 

[Dim Me as xlNoob]

You can assign this macro to all your lines:

Sub LineClick()
    Range("A1").Value = Application.Caller
End Sub

Just change the range to where you need to update your reference for the vlookup function. As long as all your lines are named the same as your lookup column in the table.

 

[peterdominic]

Thank you!

you can assign this macro to all your lines:

sub lineclick()
    range("a1").value = application.caller
end sub

just change the range to where you need to update your reference for the vlookup function. As long as all your lines are named the same as your lookup column in the table.