How can I check if a userform label has a "*" (without quotes)?
How can I check if a userform label has a "*" (without quotes)?
You could check if character 42 is in the label caption. Something like...
[vba]If InStr(1, Me.Label1.Caption, Chr(42)) <> 0 then
'has an asterisk character
Else
'does NOT have the character
End If[/vba]
HTH
Regards, Zack Barresse
Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables
Thanks Zack :-)