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