Hi everyone. I am trying to create a message box to show the row number from a match function. For example, the word "revenue" in Sheet1 is also in Sheet2. I would like to return the row number in Sheet2 for the word "Revenue." Attached is an example of what I am working with and what I'd like returned. Any help is highly appreciated.
Not sure what Keebellah has suggested, but how about
=MATCH(A2,Sheet2!A1:A3,0)
If you are looking for a VBA solution, you have two options to find the row number of the string being searched on another sheet i.e. Match and Find.
You may try one of these codes to get the desired output.
Please Login or Register to view this content.Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
sktneer, maybe I should've specified my end goal because I'm definitely mis-communicating. In the end, when I click on cell A2, I'd like the message box to appear showing the value in the selected cell's row number in Sheet2. I super appreciate this though. Any help is highly appreciated. This has been causing me hours of confusion lol.
Keebellah & EdwardSnowden. That's enough. No more side swipes, please.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
My apologies Glenn.
Still, any feedback is welcomed. This has been quite hard and I'm not stopping until I figure it out and this forum has been a non-stop source of information for me.
Apologies not required... from anyone. It's late evening in India now. Hopefully sktneer will be back in the Indian morning. I hope he or AN Other it gets sorted for you.
How aboutThis needs to go in the Sheet1 modulePlease Login or Register to view this content.
It's the same (in the attached file)
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
Sorry, I was away from the system.
There is an Event called Worksheet_SelectionChange which gets triggered automatically when the selection on the sheet gets changed.Originally Posted by EdwardSnowden
e.g. if you select any cell in column A (of course the range can be specified which should trigger this event), the SelectionChange event will be triggered and it can perform some predefined actions but the SelectionChange event would be triggered each time you select a cell in the specified range which maybe a downside to this approach.
Instead, a Worksheet_BeforeDoubleClick event which will be triggered when you double click in a cell would be more practical for you.
Please have a look at the code proposed in Post#8 and see if that approach works for you, otherwise it can be easily changed to the SelectionChange event as you requested.
Also, find the attached with the code placed on the Sheet1 Module. To view the code, right click on Sheet1 Tab and choose View Code.
To test the code, double click in the cell A2 and a MsgBox will be popped up with the desired output.
Right now the BeforeDoubleClick event code in the attached will be triggered when you double click in any cell in Column A but if you want to have this functionality for the cell A2 only, the code can be easily tweaked to do so.
sktneer
This is exactly what I needed. Thank you for not only providing a solution, but giving a detailed explanation that will enable me to do this on my own in the future.
You're welcome Edward! Glad your issue is resolved and you found the explanation helpful.
Thanks for the feedback and rep.
My sentiments exactly.
Except that unfortunately you decided to totally ignore me
@Edward
I think you forgot that the solution in the file I uploaded was originally provided by Fluff in his post#8 so please acknowledge the contribution of Fluff in resolving your issue and you should thank him for the time he devoted to your question. 👍
Fluff, my apologies. After your comment there had been a debate between a moderator and I over an individual's comments, which led to my comments and his/her comments being deleted, and I was completely side tracked. I did not mean to ignore your well thought out response and have added to your reputation as is deserved. My apologies again.
Apology accepted & many thanks for the reply & the rep
You are more than welcome. I look forward to learning more from you in the future!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks