Drop Down Menu

[Daywalker]

Looking for a wee bit of help.

Is there a way of creating a dop down menu in a cell ?.

I have created a list of employee names and details, and want when clicking on name, a drop down menu appears with options that I will then hyperlink to other files ?. And each name drop menu will be unique. although same standard descriptions/menu name.

Cheers,

Daywalker.

[oldchippy]

Take a look at this link for Data Validation Lists

http://www.contextures.com/xlDataVal01.html

[Daywalker]

Thanks for that, actually really useful for another thing I'm working on.

But when I set this example up, I am setting up a hyperlink in the table, but in the drop menu it does not actually work, also, when using the drop menu, it changes the field name to the menu name.

Any way of it keeping the original cell info, and when clicking the drop menu choice, opening up the file hyperlinked to ?

Cheers again,

Daywalker.

[oldchippy]

Take a look at this suggestion

http://www.excelforum.com/showthread...rlink+dropdown