VBA Select Case condition does not recognizw 1st character numeral

  • I am trying to get the SECOND SELECT CASE to recognize the first numeric character invx2 = "305g" for further processing
    it does not recognize it


    If I convert it to an IF statement it processes fine, but it would be easier if it remains a Case statement as it is just one of several conditions


    Can anyone tell me why it doesn't work and or how to fix it
    Thanks


  • Re: VBA Select Case condition does not recognizw 1st character numeral


    I'm not sure what you're trying to do with the 'Select Case', but base on your If statement, you're trying to check if vx2 isNumeric. If it is then write Item to B3.


  • Re: VBA Select Case condition does not recognizw 1st character numeral


    I know that vx2 is non numeric, what I want to determine is whether or not the first character of vx2 is numeric or not



    Quote from OldFriend;769973

    I'm not sure what you're trying to do with the 'Select Case', but base on your If statement, you're trying to check if vx2 isNumeric. If it is then write Item to B3.


  • Re: VBA Select Case condition does not recognizw 1st character numeral


    Hi f_htn,
    No need to quote messages back. You will have to explain what you are doing as your request is solved with


    what is the problem not your anticipated result

  • Re: VBA Select Case condition does not recognizw 1st character numeral


    ops should be


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!