How to set alphanumeric condition in my if statement?

The code below adds 6,8 weeks and 18,24 months to userinput Date1a based on its location like TDS( Tear Down station) & storage shelf(SS) and change colors after the product passes the date thresholds. Currently it is accepting only strings("TDS", "SS") at if and elseIf conditions, and I would like to do the same process with TDS1,TDS2, SS34, SS45... and so on. So that it is more general. I tried doing

Please Login or Register  to view this content.

along with Asc case 48 to 57 ( for 0-9). Unfortunately, both of them has not worked. Can anyone please take a look at it and let me know on how to solve this problem

Please Login or Register  to view this content.

Thanks,
excelkann

Hi

its a little unclear as to your goal or purpose for the textbox, im guessing your using this to do other things apart from what you posted here.....

if it doesnt matter what the number is as long as the TDR or SS part is in the text then you could try using LIKE as the condition, its a simplified regex function.......LINK

so in your case you might have something like this

Please Login or Register  to view this content.

this will match any text starting with TDS

Delete.......................

This would work but not for anything with more than 1 digit after the text

building on both Jindon's advice and my own it is probably better to do

Please Login or Register  to view this content.

this would allow "TDSR01" to be seperated from "TDS01" for example but allow any number of characters after the first number assuming your using logic like [Name][IndexNumber] for the text here

No idea about what he is asking.