Row source values in VBA

Hi ,

I have attached the sheet here and i am expecting the values from sheet 1 only applicable for textbox from userform called TriggerJob.

if am giving any values other than available from row source it should display the msg box .

if am giving valid values from the list it should navigate to another userform called Final.

Row source is available in Column S (Sheet 1).

Could you please help to solve this.

Thanks !!

Regards,
Praba