Check Label for certain text

[av8tordude]

How can I check if a userform label has a "*" (without quotes)?

[Zack Barresse]

You could check if character 42 is in the label caption. Something like...

If InStr(1, Me.Label1.Caption, Chr(42)) <> 0 then
'has an asterisk character
Else
'does NOT have the character
End If

HTH

[av8tordude]

Thanks Zack :-)