Vikki_61
12-08-2007, 03:05 PM
hi folks
Attached is my Demo test file.
In Worksheet 1 you will see a dropdown picklist - it has been acheived by Using Data/Validation select list. However while it does work - to change the hyperlink what I would prefer it to do is as a user makes their choice/pick from the list they are taken straight away to the worksheet they have chosen -without the the need for the user to actually also have to click on the hyperlink then going to the worksheet. So what I am trying to achieve is one less interaction needed from the user.
Also how can I get the text in the listbox dropdown to be a slightly bigger font size so ti is easier to read for the user.
Thanks in advance :cloud9:
Vikki_61
Attached is my Demo test file.
In Worksheet 1 you will see a dropdown picklist - it has been acheived by Using Data/Validation select list. However while it does work - to change the hyperlink what I would prefer it to do is as a user makes their choice/pick from the list they are taken straight away to the worksheet they have chosen -without the the need for the user to actually also have to click on the hyperlink then going to the worksheet. So what I am trying to achieve is one less interaction needed from the user.
Also how can I get the text in the listbox dropdown to be a slightly bigger font size so ti is easier to read for the user.
Thanks in advance :cloud9:
Vikki_61