Drop down lists

[edmac]

I'm using drop down list in Excel, and when a specific cell has been defined to contain a dorp down list it shows an arrow to the right that can be clicked to check all the values of the list; the problems is, how do I maintain the arrow "fixed" even when I'm not positioned on that specific cell? I want the user to notice all the fields with lists.

Thanks.

 

[byundt]

If you are using a Data...Validation dropdown, the arrow is visible only when that cell is active. As a workaround, consider changing the font color to dark blue or adding a light background shading to make your dropdowns stand out.

It is also possible to create dropdowns using a listbox or combobox, such as found on the Forms and Controls Toolbox toolbars. These float above the cells, so they don't look as neat in my opinion--but they do offer the advantage of a permanently visible arrow.

 

[KenWright]

Another option is to simply add a comment to the cell, even if you leave it blank, and then have the comment indicator be your list indicator.

Regards
Ken...............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------