PDA

View Full Version : I need a code to recognize a trigger value of....



kwik10z
11-30-2007, 11:28 AM
as the title states..i need an If statement... that has a trigger value of (number/letter)combo.

for example..if it scans ("F" & "row1") and finds J1 or anything that starts with a letter and is followed by a number.(U14, J12) Then do something....

but all i need is that If...End statement.

Can someone help me out?

tpoynton
11-30-2007, 01:59 PM
check out the 'like' operator in VBA help...

mikerickson
11-30-2007, 02:03 PM
In VB


If testString Like "[a-zA-Z][0-9]*" Then