I have a question aabout this:
eg.
I set row A with validation list "yes/no", i want that if choose "yes",
then open a word document named "checklist.doc".

Instead of using a validation list, you could use a "yes" button and a "no"
button. The yes button can be linked to a macro to open the word document.
The no button can be linked to a macro the will type the text "Go to next
step" or something like that.

"Bonny" wrote:

I have a question aabout this:
eg.
I set row A with validation list "yes/no", i want that if choose "yes",
then open a word document named "checklist.doc".