User form Linking

[Svmaxcel]

I made some textbox and made background color Grey to let user know that its not editable.
Example I have Names in Col A and in Col B have Emp I'd.
Col C is for Manager name but is blank.
My text box are
txt1 for Name, txt2 for Emp I'd, txt3 for Manager.
Names and I'd are there in Excel sheet.
I want that when I click on Col 3 row 2, userform should open and txt1 and txt2 should get a2,b2 values from sheet.
I will type Manager name in 3rd text box and click submit
After Submitting Col C should get Manager Name which I typed.
How can I code

 

[AlanSidman]

Upload a sample workbook with your userform for analysis and testing of code that will need to be written.

 

[shrivallabha]

You can use Labels if you are expecting them to be non-editable always!

 

[Svmaxcel]

File Attached.
I have coloured the column for easy understanding.

Col in grey is the Raw Dump.
Col in Pink are fields which I use from User form

 

[Svmaxcel]

I am sorry, forgot to update events and Dsat Driver list.
It should be in same file, different sheet.