View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default Read Dropdown list from Excel column

Hi,

How to retrieve all items in a dropdown list in a Excel cell using C#?
Furthermore, can the SelectedValue of the dropdown be set using C#? I am
using Office 2007.

Thanks very much for your help.

Hugh


Try doing it manually in Excel while the macro recorder is running.
This will give you the correct refs to use in your code. Just make the
necessary language syntax adjustments and you're done!

--
Garry

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