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

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: DataValidation
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" wrote in message
...
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

thx that worked


"Max Potters" wrote in message
...
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: DataValidation
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" wrote in message
...
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