Convert xs: listings to XSD for dropdowns in Excel

Question

I have an XSD file containing a schema for my XML. The XSD file contains a definition xs:Enumerationthat allows me to choose between 5 parameters as a value for one of the nodes.

Now we want to be able to generate this data through Excel so that non-technical people can create it.

When I import this XSD file into Excel, I want the values ​​to xs:Enumerationappear as dropdown menus.

How should I do it?

Edit: Launch bonus. To win, for this I need a working code example :)

Answer 1

xcut, . . , :

• WorkbookAfterXmlImport MSXML .
• , . ListObject.
• Validation.InCellDropdown , .

Answer 2

, , , .

, : Excel Excel .

"" , :

• Excel (, A , B )
• , , " ..." XML-
• XSLT XML,

, , :) , VBA .