I am trying to have the user choose a serial number in a list and from that the option box will change.
here is the partial code i am trying.
lsn=worksheetfunction.VLookup(lstSN.Value,worksheets("Serial Numbers").Range("a":"b"),2,False)
if lsn="" then exit sub
else if lsn="25 in_lbs +/- 6%"...