PDA

View Full Version : [SOLVED] Check Label for certain text



av8tordude
02-07-2014, 10:34 AM
How can I check if a userform label has a "*" (without quotes)?

Zack Barresse
02-07-2014, 01:34 PM
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
02-07-2014, 02:40 PM
Thanks Zack :-)