Please help with this filter

P

pantelis

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 sheet 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
 
M

Max Potters

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
 
P

pantelis

thx that worked


Max Potters said:
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
Click to expand...
 
Top