Appearance of Data Validation Combo Box

  • Thread starter Thread starter Faraz A. Qureshi
  • Start date Start date
F

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?
 
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
 
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
 
Back
Top