need of pop up message dynamically using data validation input message method

hii

i am facing a problem for using a pop up box for the T column.i need it for all the rows and a pop up should display watever text present in the T colomn dynamically.

Conditions are:

1.the pop up box shuld display for all rows > 42(since the data starts from that row).
2.it should be done using data validation-->input message-->title-->message(which is a pop up) method dynamically for all rows of T column.
3.The pop up boxes should be disabled so that user wont be able to modify anything in the pop up box.
4.The pop up box should display watever text present in the T column for each and every cell dynamically.
5.The looping should stop upto where the data ends dynamically and even the pop up boxes should be terminated when the data ends.
6.Basically It should show wateever data present in the T column in form of a pop up box using data validation control method but not comment box method dynamically.

I am attaching an excel sheet for a clear demonstration of a pop up box in T column for one cell.
I want the same to happen for every cell in T column upto where the data ends dynamically using data validation method.

I Dnt Want it in comment method please.

Thank you.

This will add Data Validation to every cell in Column("T") when the sheet is activated.
I don't think you can prevent anyone from modifying the Data Validation except by locking the cells and protecting the sheet, but they can unprotect the sheet unless you have it password protected..
Adapt this to whatever you need.

Please Login or Register  to view this content.

If you need the Validtion Message to change when the cell is changed, then put the code into the Worksheet_Change() event instead.