I need my drop down arrow to continuously appear wtih a data validation list

[dlefever]

I'm using data validation to create a drop down selection menu containing a list of four hyperlinks. My problem is that the drop down list selection arrow does not appear unless you click on the cell containing the list. I need the drop down arrow to continuously appear so my users know that there are more options to select.

User forms DO NOT owrk because I am using hyperlinks. I have learned that I cannot use a hyperlink with my selection list.

The goal is to have a user immediately see a drop down menu selection visible at all times regarles of the cell he/she has seleted. Once the user selects a hyperlink from a list of four, he/she will be automatically redirected to the hyperlink.

The key is to have the drown down selection box and arrow appear at all times so that the users intuitively knows that he/she has options.

Hope I am clear. Any suggestions will be appreciated.

[shg]

Welcome to the forum.

You can't make that happen. You could use a listbox control instead.

[dlefever]

I have a question regarding the use of a listbox control. It is my understanding that I cannot use a hyperlink in the listbox and have the user automatically redirected to the hyperlink upon selection? Is this correct?

My ultimate goal is to have a drop down selection listing as many as 6 items with a unique hyperlink associated with each of the 6 items on the list. As soon as a user makes a selection from the list, he or she is redirected to the page associated with the list item hyperlink.

[royUK]

You would need a VBA work around, adapt the code in the hyperlink in a UserForm example, use the ListBox click event & the value