Row source values in VBA

[Prabakaran3003]

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

[Arkadi]

I'd start by saying that you are comparing a value to a range of more than one cell, that will not work. Here is a suggestion:

Please Login or Register  to view this content.

[Prabakaran3003]

Hi... Thanks lot for the help. Again i have updated the code and expectations are

1. If am entering employee id in trigger job userform , then msgbox should shows name (Names are available in the T column) of the user with Yes or No . (Ex. Hi User 1, are you sure to run the job).

2. If it is Yes another user form (Final) should get display else nothing should happen.

Thank you in advance!