Modifying Existing Code to Check if the entry exists

Hi There,

I need your help,

I have a code below that works well with a userform that adds my data from my userform to an excel worksheet. It works great and all, but id like to modify it to have it check and see if the file number (fn) exists before writting it back to the worksheet, if it exists, then msgbox "Error: Record Cannot be added - (Duplicate Entry)" and do nothing else, if the file number does not exist, proceed as normal and execute the rest of the code.

Please Login or Register  to view this content.

Any help with this is greatly appreciated.

Much thanks for all your help in advance.

Thanks,

Jay

Couldn't you just run an If statement like:

Please Login or Register  to view this content.

Mayhap I am over simplifiing the matter.

As Mordred suggests you can compare the variable to the cell before populating it.

You can also reduce the duplication in your code by simply assigning the reference to the correct worksheet before transferring values.

I have assumed if the value already exists then no information is transferred

Please Login or Register  to view this content.