Re: Please help with this filter

From: pantelis (pantelis_at_totalise.co.uk)
Date: 08/18/04 

Date: Wed, 18 Aug 2004 14:39:08 +0300

thx that worked

"Max Potters" <max.potters@planet.nl> wrote in message
news:cfvaqp$nso$1@reader10.wxs.nl...
> I think, if I understand you correct, that you have a dropdown list; not a
> listbox or combobox.
>
> If you want to put any value in the cell you want, try this:
>
> 1) select the cell(s) you want to put any value in
> 2) Goto: Data>Validation
> 3)In the Settings-tab, u see Allow.
> 4) Set this box to ANY VALUE
>
> Now your list is gone, and you can type in whatever you want.
>
> Max
>
>
> "pantelis" <pantelis@totalise.co.uk> wrote in message
> news:uwqlxrQhEHA.2620@TK2MSFTNGP10.phx.gbl...
> > Hi all,
> >
> > I have a cell in a spreadsheet "sheet1" which when you put your go to
that
> > cell i.e. cell "A1", it gives you the option to select from a dropdown
> menu
> > a list of occupations which is in "sheet2".
> >
> > There is no macro associated with it and its not a combo box or a list
box
> > that you can draw, in a *** and link to a specific list of occupations
> so
> > that a combo box e.g. can display.
> >
> > It looks like some kind of filter embeded in the cell.
> >
> > If someone can help it will really be appreciated as this thing is
driving
> > me crazy. If anyone would prefer I can sent the excel file for review.
> >
> > Thanks
> > Pantelis
> >
> >
>
>