Drop-down lists

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-

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" <zeugma@toucanspam.com> wrote in message
news:C0B77AAB.2926%zeugma@toucanspam.com...
> 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-
>

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


On 15/6/06 21:26, in article #d7N8nLkGHA.3304@TK2MSFTNGP03.phx.gbl, "Bob
Phillips" <bob.NGs@xxxx.om> wrote:

> 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" <zeugma@toucanspam.com> wrote in message
> news:C0B77AAB.2926%zeugma@toucanspam.com...
>> 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-
>>
>
>

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

Jay wrote:
> 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
>
>
> On 15/6/06 21:26, in article #d7N8nLkGHA.3304@TK2MSFTNGP03.phx.gbl, "Bob
> Phillips" <bob.NGs@xxxx.om> wrote:
>
>
>>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" <zeugma@toucanspam.com> wrote in message
>>news:C0B77AAB.2926%zeugma@toucanspam.com...
>>
>>>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-
>>>
>>
>>
>


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html