Programmatically query Excel drop-down list ?

[diglas1 via OfficeKB.com]

Can I programmatically query an Excel drop-down list and programmatically
update the drop-down cell ?
I am trying to populate one spreadsheet with data from another using an Excel
macro, but one column contains drop-down boxes. Can I query the drop-down
list from my controlling macro and populate the cell with one of the entries.

Thanks in anticipation.

 

[Guest]

Are you talking about data => Validation using the list option.


If so, do you know where the data is that is used to populate the list? If
so, just get a value from that. Data validation doesn't react to entries
made by code.

 

[diglas1 via OfficeKB.com]

Tom,
Yes re Data ==> Validation.
Thanks for your response; unfortunately, when I select the drop-down "List"
cell, then Data from the toolbar, the Validation option is greyed out. I
know the workbook is unprotected as the formulae for all cells are visible,
so presume it's not a security issue.
Could the source for the drop-down list box be created and it's whereabouts
protected somehow in a macro ? (the macros for this spreadsheet are greyed
out, so must be protected.)
Thanks

Are you talking about data => Validation using the list option.

If so, do you know where the data is that is used to populate the list? If
so, just get a value from that. Data validation doesn't react to entries
made by code.

Can I programmatically query an Excel drop-down list and programmatically
update the drop-down cell ?

[quoted text clipped - 3 lines]

Thanks in anticipation.