Trouble with getting a checkbox to place a cell value when matching the textbox.

So I have a userform the has two textboxes and two checkboxes. The first textbox is the Guestname and the second is Roomnum. The two checkboxes are called MSbox and ONbox. When a user inputs the same username that is already there, the room number gets put into a separate column (up to 3 times).

What I am having trouble with is when the MSbox is true, then it puts a M/S in column F with the corresponding name if it already there.

Here is the current code for the MSbox:

Please Login or Register  to view this content.

Here is the other code I have for the textboxes (there is more code, but I left some out to simplify it, here is what I have):

Please Login or Register  to view this content.

I will also attach my workbook if you want to check it out.

Guess here's lies the problem:

Please Login or Register  to view this content.

The part marked red is a statement which probably always will be false and thus emptycol will always be set to 0 (=false). I don't think this line of code is like you intended.

I think the problem is in the part below

Please Login or Register  to view this content.

which I think should look like this

Please Login or Register  to view this content.

Also this line

Please Login or Register  to view this content.

puts the code "O/N" in the M/S column.
Guess this should be column 7 iso 6?

Glad I could help