ThePigeon
02-09-2009, 04:53 PM
hey,
I want to make a function that returns a true or false value if one of cells in my excel database contains the same text as another cell. (The database is constantly changing (adding and removing records) so this needs to be factored in).
Let me try and give a vague example:
I want to make it so:
If 'the cell "firstname" contains the same text As any of the used cells In column A
Then
UserForm1.Label1.visble = True
Else
UserForm1.Label1.visble = False
Any help is much appreciated,
Regards,
Joe
I want to make a function that returns a true or false value if one of cells in my excel database contains the same text as another cell. (The database is constantly changing (adding and removing records) so this needs to be factored in).
Let me try and give a vague example:
I want to make it so:
If 'the cell "firstname" contains the same text As any of the used cells In column A
Then
UserForm1.Label1.visble = True
Else
UserForm1.Label1.visble = False
Any help is much appreciated,
Regards,
Joe