Greetings,
I am trying to use the following code. What I want to happen is if value Sheet8.Range("R3").Value does not equal any number found on "Master" range A:A, then a Userform would appear. If Sheet8.Range("R3").Value does equal any number found on "Master" range A:A, then the rest of the macro would run. However, when a value that does match, I am still getting the Userform.
Please Login or Register to view this content.
I asked you to amend the title of your original thread, not open a new one.
In the circumstances, I have closed the original thread in favour of this one.
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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Please Login or Register to view this content.
Good Luck...
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
Also....Add a comment if you like!!!!
And remember...Mark Thread as Solved...
Excel Forum Rocks!!!
without the sheet the code is build for it is always difficult to debug. But your code looks overcomplicated, all you want to know is if a certain value is available in a specific column
I think this can do the trick too
Please Login or Register to view this content.
Roel,
Thank you much!!!! The code works GREAT!!!
Sintek,
Thank you as well for your suggestion!
Glad I could contribute...Tx for rep +
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks