another Excel question. Does anyone know how to add a data validation dropdown to a cell in Exl2k?


thank you

This message has been edited. Last edited by: Kerry,

What type of validation ?

This just gives an idea of how to add it.

DEFINE FILE CAR
 Code/A500 = '<xml><x:DataValidation><x:Range>$D$5:$D$10</x:Range><x:Type>List</x:Type><x:Value>$D$5:$D$10</x:Value><x:InputTitle>Select</x:InputTitle><x:ErrorTitle>Error</x:ErrorTitle></x:DataValidation></xml>' ;
END

TABLE FILE CAR
HEADING
"Cell Validation <Code"
" "
" "
PRINT SEATS
BY COUNTRY
BY CAR
BY MODEL

ON TABLE PCHOLD FORMAT EXL2K

END

I want to give them a list of values to select from. eg, I - Incomplete
C - Complete
S - Suspended

I don't know much about this in Excel, but it seems that the list is pointed to via the x:Value tag.

The list would have to be in the spreadsheet.