Wildcards in Select statement
MVP Ken Snell showed a nice way to use wildcards in Select:
Select Case True
Case (MyVariableName Like "*10280")
' do things here if the match is valid
Case (MyVariableName Like "*99999")
' do things here if the match is valid
End Select
Cool!
Select Case True
Case (MyVariableName Like "*10280")
' do things here if the match is valid
Case (MyVariableName Like "*99999")
' do things here if the match is valid
End Select
Cool!
0 Comments:
Post a Comment
<< Home