After inserting a Data Validation List Combo Box the problem is that
sometimes the data entry officer is not able to locate the same. Any idea how
to keep the Combo Box's Drop Down Button to remain visible whether the cell
is active or not?

--
Best Regards,

Faraz

Hi Faraz

I would suggest you to use the ComboBox control from Control Tool Box
(ViewToolbars) and set the below properties of the controls to a cell range.
The linked cell will always have the selection value which can be used as a
reference in your formulas/macros..

ListFillRange
Linked Cell

If this post helps click Yes
---------------
Jacob Skaria


"Faraz A. Qureshi" wrote:

After inserting a Data Validation List Combo Box the problem is that
sometimes the data entry officer is not able to locate the same. Any idea how
to keep the Combo Box's Drop Down Button to remain visible whether the cell
is active or not?

--
Best Regards,

Faraz

Hi Faraz,

Yo can't do it with a data validation drop-down. Either format the data
validation cell with distinctive background and border, or change to a forms
drop-down or a control.

Ed Ferrero
www.edferrero.com