Code to check ComboBox.Value doesn't already exist in range before attempting to delete

Im using the following code to delete usernames from a sheet, and consequently from a dynamic range. The code worked fine but Im trying to add some code that checks to make sure the username entered in the combo box Username is present in the dynamic range Usernames. If it is not present then it displays a message informing the user that the username does not exist.
I am currently getting runtime error 13 Type mismatch on the third line: If Username.Value = Rng Then

Please Login or Register  to view this content.

Thanks,
James