Re: Drop Down Menu, Again (SOLVED)

[Vince <wa...@verizon.net>]

TNX for the reminder to use Data-Validity-Criteria (i.e., not use 
Data-Filter-Auto Filter)!  I have Cut & Pasted instructions into the 
tabbed-sheet for future reference.

I have incorporated my drop down choice listing in my application 
spreadsheet, and all seems to be working as expected.   This has made a 
difference for me when entering the names of common vendors, etc.


On 4/19/2016 5:05 PM, Vince wrote:
> AOO412m3(Build:9782) -  Rev. 1709696
> 2015-10-21 09:53:29 (Mi, 21 Okt 2015)
>
> Win 8x64
> ____________________________________
>
> I have done this once before, but am not able to repeat it.
>
> I want a drop down arrow that when clicked opens a list of pre-written 
> choices. This list is presently located on a separate worksheet, 
> titled "Lists", in AOO Calc; and it works locally there on the List 
> worksheet.
>
> But, I want to introduce this "drop down menu selection" within an 
> existing column within a separate worksheet; and not at the head of 
> the column.
>
> I have tried Data-Filter-Auto Filter, but that seems to require 
> beginning at the very top of a column.
>
> I will want to add additional choices at a later time; thus, I think 
> the List must be on a separate worksheet so that I can resort the 
> entries alphabetically.
>
> Thanks for reading this.
>
> Regards,
> Vince B.


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org