Appearance of Data Validation Combo Box

[Faraz A. Qureshi]

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?

 

[Jacob Skaria]

Hi Faraz

I would suggest you to use the ComboBox control from Control Tool Box
(View>Toolbars) 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

 

[Ed Ferrero]

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