When using Data Validation in EXCEL 2003 and Choose to have your numbers in a
"List" such that when you highlight that cell a drop down menu will appear
does ANYONE know how to keep that drop down menu still there even when it is
not the active cell.

If you know you can post here or email me at

Thanks.

If you use Data Validation to create a drop down list in a cell, the
arrow is only visible when the cell is active.

If you want arrows that remain visible at all times, you could use a
combo box from the Forms toolbar, or from the Control toolbox.

Or, you can colour code the cells with data validation, to guide your users.

Ritchie wrote:
When using Data Validation in EXCEL 2003 and Choose to have your numbers in a
"List" such that when you highlight that cell a drop down menu will appear
does ANYONE know how to keep that drop down menu still there even when it is
not the active cell.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html