ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   HOW TO USE HYPERLINK within a droplist? (https://www.excelbanter.com/excel-discussion-misc-queries/42485-how-use-hyperlink-within-droplist.html)

Bonny

HOW TO USE HYPERLINK within a droplist?
 
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".

JR

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".



All times are GMT +1. The time now is 08:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com