Ok this is strange, using data validation, I do NOT have a in-cell dropdown
option in the Data Validation dialog box.
If I open a file with data validation and select a cell with it the option
is there, but if I select another cell the option is not there. I can copy
the cell with validation and the drop down will show up when I paste it but
if I change the validation rule it goes away! ???
Using Excel 2002 (10.6501.6626) SP3

Any Ideas
Thanks Paul B

I must have lost it, are the drop down boxes only for a list!! I could swear
I have used it for the other options before. :(

--
Paul B

"Paul B" wrote in message
...
Ok this is strange, using data validation, I do NOT have a in-cell
dropdown
option in the Data Validation dialog box.
If I open a file with data validation and select a cell with it the option
is there, but if I select another cell the option is not there. I can copy
the cell with validation and the drop down will show up when I paste it
but
if I change the validation rule it goes away! ???
Using Excel 2002 (10.6501.6626) SP3

Any Ideas
Thanks Paul B

The in-cell dropdown option will appear when you select "list" from the "Allow"
dialog.


Gord Dibben MS Excel MVP

On Wed, 18 Oct 2006 17:26:42 -0400, "Paul B"
wrote:

Ok this is strange, using data validation, I do NOT have a in-cell dropdown
option in the Data Validation dialog box.
If I open a file with data validation and select a cell with it the option
is there, but if I select another cell the option is not there. I can copy
the cell with validation and the drop down will show up when I paste it but
if I change the validation rule it goes away! ???
Using Excel 2002 (10.6501.6626) SP3

Any Ideas
Thanks Paul B

The arrow only shows for the list option in data Validation. Is that what
you mean?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Paul B" wrote in message
...
I must have lost it, are the drop down boxes only for a list!! I could
swear
I have used it for the other options before. :(

--
Paul B

"Paul B" wrote in message
...
Ok this is strange, using data validation, I do NOT have a in-cell
dropdown
option in the Data Validation dialog box.
If I open a file with data validation and select a cell with it the
option
is there, but if I select another cell the option is not there. I can
copy
the cell with validation and the drop down will show up when I paste it
but
if I change the validation rule it goes away! ???
Using Excel 2002 (10.6501.6626) SP3

Any Ideas
Thanks Paul B