Hi Garry,

Thanks for your help. I will take a look your link. For the second part, I
used oSheet.Range["A1"].Value = "Value", it does not work. Howevr, the same
syntax works for regular cells (cells that don't have a dropdown associated
with). Thank again.

Hugh

Note that the cell with a DV list (dropdown) can only hold values from
its DV list when being edited. That means if your text "Value" isn't in
the DV list then you can't insert it, and so it appears as though
nothing happened - assuming notification prompts for that cell are
turned off. Otherwise, you'll generate the 'invalid input' prompt.

--
Garry

Free uenet access at http://www.eternal-september.org
Classic VB Users Regroup
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion