Cell P15 contains a bunch of job notes like the following:
"PROGRAM # 7046
LVL # 001
PANEL DOOR INNER DIVAN 650
INCLUDES 72.67 INCHES OF 5-AXIS TRIM
CUSTOMER TO SUPPLY .047 IN. THK. CARBON FIBER FORMED PARTS
PART SHARES A COMMON FIXTURE WITH 39593
RESET-UP OF JOB #17052
GREEN TRIM LINE ON CUSTOMER FIXTURE"
What I need to do is get the program number (7046 in this case) and populate textbox1 on a userform with it. Also, I would like to populate textbox 2 with the lvl number (001 in this case). how would I go about doing this? My first thought was to search for the terms "PROGRAM" & "LVL" within the cell, but I dont know how to select what I need after that. Program number isnt always on the first line & I have seen them use "PRG" sometimes, so it gets even more complicated...
"PROGRAM # 7046
LVL # 001
PANEL DOOR INNER DIVAN 650
INCLUDES 72.67 INCHES OF 5-AXIS TRIM
CUSTOMER TO SUPPLY .047 IN. THK. CARBON FIBER FORMED PARTS
PART SHARES A COMMON FIXTURE WITH 39593
RESET-UP OF JOB #17052
GREEN TRIM LINE ON CUSTOMER FIXTURE"
What I need to do is get the program number (7046 in this case) and populate textbox1 on a userform with it. Also, I would like to populate textbox 2 with the lvl number (001 in this case). how would I go about doing this? My first thought was to search for the terms "PROGRAM" & "LVL" within the cell, but I dont know how to select what I need after that. Program number isnt always on the first line & I have seen them use "PRG" sometimes, so it gets even more complicated...