ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Selecting the item in combobox in excel file through C# application (https://www.excelbanter.com/excel-programming/391527-selecting-item-combobox-excel-file-through-c-application.html)

Manikandan

Selecting the item in combobox in excel file through C# application
 
Hi,
I'm using excel 2000.
I'm working on .NET1.1 using VS.NET2003
I'm using Microsoft Excel 9.0 Object Library to access excel from c#
application.
I have one excel sheet with a combobox(only one combobox with five
items).
I need to select the item through c# application.
Could you please tell me the exact syntax to select an item in excel
sheet through c# application.
I also don't know the name of combobox in excel sheet(is there any
property window to see combo box name in excel).
I tried excel.oleobjects, but don't know exact syntax
Kindly help me out

Thanks,
Mani


Tom Ogilvy

Selecting the item in combobox in excel file through C# applicatio
 
If you don't get an answer, You might ask over in the Office Developer groups
- this group is more oriented toward VBA in Excel itself.

--
Regards,
Tom Ogilvy



"Manikandan" wrote:

Hi,
I'm using excel 2000.
I'm working on .NET1.1 using VS.NET2003
I'm using Microsoft Excel 9.0 Object Library to access excel from c#
application.
I have one excel sheet with a combobox(only one combobox with five
items).
I need to select the item through c# application.
Could you please tell me the exact syntax to select an item in excel
sheet through c# application.
I also don't know the name of combobox in excel sheet(is there any
property window to see combo box name in excel).
I tried excel.oleobjects, but don't know exact syntax
Kindly help me out

Thanks,
Mani




All times are GMT +1. The time now is 02:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com