Compare user input with range (with an if statement)

I'm trying to do the following:

The user enters a name in an input box
The name is compared to a range (in this case, the range is called "Names")
If the name is contained within the range, copy it to A1
If the name is not contained in the range, close 2 files("status change" and "vacation") and show a msgbox UserEntry & " not found!!"

Please take a look at my code and let me know what I'm doing wrong:

Please Login or Register  to view this content.

I don't know how to combine the code to get it to copy if it is there and do the other commands if it is not.

Thanks in advance for any help you can provide.

with an incorrect name (one that is not found in the range) - it jumps to the else statement, but does not close the two files.

with a correct name it also jumps to the else statement.

If it is not in the range, It should close the files, display the msgbox & exit

If it is in the range it should copy the user input to cell A1 and continue

Thank you for the help