Consulting

Results 1 to 3 of 3

Thread: I need a code to recognize a trigger value of....

  1. #1
    VBAX Regular
    Joined
    Nov 2007
    Posts
    24
    Location

    I need If.....end statement

    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?
    Last edited by kwik10z; 11-30-2007 at 12:15 PM.

  2. #2
    VBAX Mentor tpoynton's Avatar
    Joined
    Feb 2005
    Location
    Clinton, MA
    Posts
    399
    Location
    check out the 'like' operator in VBA help...

  3. #3
    Mac Moderator VBAX Guru mikerickson's Avatar
    Joined
    May 2007
    Location
    Davis CA
    Posts
    2,778
    In VB

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •