embeded if/then statements in visual basic

[jfoerch]

Looking for some help here. Using a userfom box, I'm trying to put the number that's in one of the text boxes into an existing tab in the form. I'm trying to search the destination cells to see if the number exists in the list already. If it does, I want to command to stop. If it does not exist, I want the command to put the textbox value in the next blank cell. Here is the code I've written so far.

Please Login or Register  to view this content.

As it's written, it seems to be just taking the textbox value and putting it in the next blank cell. Can someone help?

Thanks.

[JBeaucaire]

Something like this perhaps:

Please Login or Register  to view this content.

[jfoerch]

Perfect!!!!!

Many Thanks!

[JBeaucaire]

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.