Check if value exists in a range, if not add it to that range.Thank you!

[kiki13140702]

Hi everybody,

I am trying to create a macro to check if the entered username exists in a range. The range are set up as all "A" column in the worksheet called "UserName"

I will start with asking " enter a name" in a userform and then I need to check if this name already exist in the range. If not exist in the range, it will return to the message box "congratulation!" and also the new username will be added into that range, if yes, it will return to the message box "please enter another name.."

After reading some other posts, I am a little confused how to do it. Match function? or Countif ? or LookUp?

I am very thankful for any help.

Thank you!

[stnkynts]

Either match or find. Match is a little better I believe. Here is example of both:

Please Login or Register  to view this content.