I am trying to validate user input against data that is in the fourth column
of a worksheet named "data". The amount of rows in this sheet will vary

This is how I receive the input from the user:

Cliname = InputBox(Prompt:="Enter Client Name", Title:="Client Name")

How do I do this?

Thanks in advance.