Code to match range with textbox and provide msgbox

[Templemind]

Hello,

I do not know what is wrong and why this code is not working. I tried it in two different places, and no error pops up but I don't believe the match function is working. Here is the code:

Please Login or Register  to view this content.

This is occurring after the textbox "Roomnum" is updated. In range J7:J17 there may be values that correspond to Roomnum, so if they match, then I want to msgbox to appear. I tried .Columns(10), but that doesn't work either (there are no other values in the column other than a title). What am I doing wrong?

[Naveed Raza]

Try this.......

Please Login or Register  to view this content.

[Templemind]

Thank you Naveed, but I did try that already and it still doesn't work.

[Naveed Raza]

Hmm Please provide sample workbook it will make very easy to understand.

[Templemind]

Here it is. The code is located in the Name_usrfrm