Trying to create dropdowns in excel using vb.net

[raj]

How can I create the dropdowns in excel using vb.net without using any third
party controls? Basically I have an export excel feature in my site and I
need to create the dropdowns when the user trying to export the excel.

Can somebody publish the sample code?

 

[Chip Pearson]

It depends on what version of Excel you are using, what exactly you mean by
"drop downs", and whether you are using VSTO (and the version of VSTO). Is
this in an add-in or a code-behind workbook or what?

More details are necessary.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

 

[raj]

Hi Chip,

I am using the excel component in the vb.net but not using any third party
tools. And I am using .Net 2.0 with the excel 2003. Basically I am trying to
export the values from the vb.net website and exporting these values to the
excel file as dropdown. Appreciate your help.

Thanks,
Raj