If cell value exists on textbox.value row, then display msgbox

[Templemind]

I don't really have code for this because I don't know where to go. Here is the background information (I may have given too much).

I have a range of cells (C6:E38) that when double clicked input a "1" in the a cell on the same row in range (V6:X38). So if cell C6 was double clicked a "1" would go into cell V6. Because cell V6 is true, C6 would then go red and vice versa for the rest of the range of cells. (I do this so conditional formatting can be acknowledged, which is important for this). In the B column are names, so there is a name and three columns after the name.

The way these are put into excel is through a userform. The names are GuestName.Value and the numbers beside the name in the columns is Roomnum.Value. GuestName puts the names in column B and Roomnum gets put into column C, D, and E each time the name goes through the userform (3 times max as there are only three columns)

What I'm wondering is if there would be a way to Match the names up with numbers in the range of V6:X38. So say, like in the picture below, Jimmy was put into the userform. I would like a msgbox saying "NO" (I can change this later) coming up because cell W6 does not have a 1 in it, and conversely because cell D6 is still green and not red, therefore he cannot have another roomnum entered..


All I have so far is:

Please Login or Register  to view this content.

Here is what it kind of looks like:
Untitled.jpg

*Update*
In the example, I want to say No because the cell D6 is showing that Jimmy is not red (which would have a 1 in cell W6 if it was red). I realized that Roomnum doesn't really mean anything other than entering another column. I have that down and know where to put it.

[Templemind]

Here is a shell of the workbook I will be using.