Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
accessing excel combo box control data from vb .net
Hi,
I have a spread sheet with a EMBED combo box. I select an item in the combo box and save the sheet. Now i am reading the spreadsheet values from VB .NET using Microsoft.Office.Interop library. I am able to get the values of regular cell in the sheet. Can anyone tell me how to get the data of the combo box from vb .net. Any help is appreciated. Prn |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
accessing excel combo box control data from vb .net
Hi
You can use the linkedcell property of the combobox to link a cell on the sheet Maybe there is a better way but this will work i think ? -- Regards Ron de Bruin http://www.rondebruin.nl "CoolCyber" wrote in message ... Hi, I have a spread sheet with a EMBED combo box. I select an item in the combo box and save the sheet. Now i am reading the spreadsheet values from VB .NET using Microsoft.Office.Interop library. I am able to get the values of regular cell in the sheet. Can anyone tell me how to get the data of the combo box from vb .net. Any help is appreciated. Prn |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
accessing excel combo box control data from vb .net
Thanks that worked
"Ron de Bruin" wrote in message ... Hi You can use the linkedcell property of the combobox to link a cell on the sheet Maybe there is a better way but this will work i think ? -- Regards Ron de Bruin http://www.rondebruin.nl "CoolCyber" wrote in message ... Hi, I have a spread sheet with a EMBED combo box. I select an item in the combo box and save the sheet. Now i am reading the spreadsheet values from VB .NET using Microsoft.Office.Interop library. I am able to get the values of regular cell in the sheet. Can anyone tell me how to get the data of the combo box from vb .net. Any help is appreciated. Prn |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can one combo box control the data in a different combo box | Excel Discussion (Misc queries) | |||
accessing graphics with combo box or drop down list | Excel Discussion (Misc queries) | |||
Problem accessing control in another form | Excel Programming | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) |