Is there a way to have a userform show when the result of a vlookup is #N/A? My userform is called UserForm1 and anytime I get an #N/A returned from a lookup I would like for this to show. The user will enter data in cells B4,B19,B34,B49,B64,B79,B94 and B109. The lookup formulas are all in the same row but in column C.
So probably you shall prepare event handler for Worksheet Change event
something similar to:
in the code of your Sheet (not in standard module)
Please Login or Register to view this content.
Best Regards,
Kaper
I love it. It's perfect. Thank you very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks