Hi,
How to say this :
at cell K1=Vlookup(Cell Click,Range,2,0) ?
so Lookup_Value to be the cell I have click
Thank you
Hi,
How to say this :
at cell K1=Vlookup(Cell Click,Range,2,0) ?
so Lookup_Value to be the cell I have click
Thank you
Last edited by ionelz; 02-02-2023 at 08:24 AM.
What is range you are clicking?
Lets assume it is Column A
You don't need vlookup, just get the value next to the clicked cell
Please Login or Register to view this content.
I have attached a small sample workbook. Right click on the sheet tab and select "View Code"
See here for worksheet events and where the code goes in the worksheet module
https://www.excelforum.com/tips-and-...et-events.html
Last edited by davesexcel; 02-02-2023 at 08:44 AM.
I am Clicking in Range J9:J15
I V looking in Range AA2:AB50
So I7=vlookup (value click from J9:J15,aa2:ab50,2,0)
So range J9:J15 is in range aa2:aa50
I do need vlookup
Last edited by ionelz; 02-02-2023 at 08:52 AM.
Okay, replace with this code instead
Please Login or Register to view this content.
All Ok now, thank you
Could you help a little more ? I have 3 Ranges where I click : J9:J15 , N9:N15 , R9:R15
For all , I am looking in same Range AA2:AB50
So change is only (I hope) here .....Me.Range("J9:J15") where I have 3 ranges not only one
And another change, when I click outside of these 3 ranges then nothing(clear) at I7
Attach a sample workbook
Did you look at the link I sent you in Post #2
All Ok, but I get an error message when I select , Left corner, Entire sheet...
Run-time error 440, method find an object failed
Ya, you need to make sure there is not more than 1 target selected.
Try counting the target first
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks