Drop-down lists

[Jay]

Hi,

If I create a drop-down list in a cell using Data-Validation is there any
way I can make the drop-down button visible all the time, even when the cell
isn't selected?

I'm trying to create a form for data input and want the buttons available
all the time.

Any help greatly appreciated.

-Jay-

 

[Bob Phillips]

You could use a combobox, or do what I do shade the cells another colour.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

 

[Jay]

I've been struggling to find any help resources re using controls. Any
pointers where I could find some. Do you have to use the AccessLinks add-in
to use a combo box?

Jay

 

[Debra Dalgleish]

There are instructions here for adding a combobox from which you can
select one of the values from the data validation list.

http://www.contextures.com/xlDataVal11.html