I am working on a spreadsheet where I enter a part number and I use vlook up to return a location. I want to set up a button, which will allow me to goto the cell where this part number is located.
I am not an advanced excel user, so do not know how to use macros. Is there a simple way to do this?
Welcome to the forum.
This can’t be done without VBA code. I’ll move the thread for you.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Can you attach a short Excel sample file to show how is your data and prepare more easely the macro.
A possibility could be to double click on the cell where is the Vlookup result but how is this result ...!
- Battle without fear gives no glory - Just try
Here is the file attachment. Thank you for your help.
See next code and file attached
Double click on the red cell
Please Login or Register to view this content.
Houps
Please Login or Register to view this content.
In my opinion, this can be done with the formula:If you use "Wrap Text" for this cell, you don't have to click exactly on the text, just keep the cursor over the cell and click (also outside the text).Please Login or Register to view this content.
Artik
Last edited by Artik; 07-18-2021 at 07:11 PM.
It came after that we don't need the cell address only the location is enough.
With next code, just double clic on H3
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks