Re: Drop Down Menu, Again

2016-04-22 Thread Vince
Just a small variation to make it work easier for me, Shown below: On 4/20/2016 2:19 AM, Brian Barker wrote: At 17:05 19/04/2016 -0400, Vince Bonly wrote: 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,

Re: Drop Down Menu, Again (SOLVED)

2016-04-22 Thread Vince
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.

Re: Drop Down Menu, Again

2016-04-20 Thread Brian Barker
At 17:05 19/04/2016 -0400, Vince Bonly wrote: 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

Re: Drop Down Menu, Again

2016-04-19 Thread Martin Groenescheij
> On 20 Apr 2016, at 7:05 AM, 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

Drop Down Menu, Again

2016-04-19 Thread Vince
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