Hello,
I have two columns with numbers and two textboxes. When I put a number (=unique) in textbox1. I want my userform to search for that number in column A and give me the value in the same row of column B and put in textbox2. I have the following code (which is working). The problem I am experiencing is when I type something in textbox1 that is not in column A I get an error. Is there a way to say something like: if not exists do nothing?
Please Login or Register to view this content.
Try this.
Please Login or Register to view this content.
If posting code please use code tags, see here.
Hi, Norie,
shouldn´t it only be
due to the offset used before?Please Login or Register to view this content.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Holger
Oops, the Offset(0,1) should be removed from the Find.
Which I should have remembered.Please Login or Register to view this content.
Thank you !
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks