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

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.

Welcome to the forum.

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

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