vba: insert comment box upon value in cell and write in other cell

[tomatski]

Dear experts,

I have been looking for a solution for hours with regard to the following problem, but unfortunately without luck.

If in cell A1 a user selects "KO criterium" out of a validation list, I'd like a msgbox to appear to request additional text input from the user (e.g. "Dear user, please motivate your answer in the textbox below"). Once the user has entered some text and presses an OK button, I'd like this input to be copied to another cell, say B1.

Any help is much appreciated!

Kind regards,

Thomas.

[Kelshaer]

Paste the below code in the codepage of the worksheet

Please Login or Register  to view this content.

[tomatski]

Dear Khaled,

Many thanks for your quick reply. Exactly what I was looking for!

Kind Regards,

Thomas