Excel Macro : Function that will return true or false if a value exist in a column

Hi guys,

I am finishing up a custom user form for an excel macro and was looking for a function you can send a value to it and it will return a true or false if the value exist in a specific column. (it needs to check all records on a specific column without specifying the length it has)

Ex:

Dim Check as Boolean
Dim Value as String
Check = LookItUp (Value)

Tried a few function but they did not work properly. Any help would be much appreciated!


Thanks!