Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting Data from Embed combo box in excel sheet to 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
|
|||
|
|||
Getting Data from Embed combo box in excel sheet to vb .net
Why don't you set the Linked Cell property of the combo box and then
read the value of that cell. Hope this helps Rowan CoolCyber wrote: 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
|
|||
|
|||
Getting Data from Embed combo box in excel sheet to vb .net
Thanks that worked
"Rowan Drummond" wrote in message ... Why don't you set the Linked Cell property of the combo box and then read the value of that cell. Hope this helps Rowan CoolCyber wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting Data from Embed combo box in excel sheet to vb .net
You're welcome.
CoolCyber wrote: Thanks that worked |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy data from one sheet to another using a combo box | Excel Worksheet Functions | |||
Formula to Embed a file object in my excel sheet. | Excel Worksheet Functions | |||
How do I embed a word doument in an excel spread sheet? | Excel Discussion (Misc queries) | |||
how to embed objects from other applications in 1 cell in excel sheet | Excel Programming | |||
HOW TO: embed binary data in Excel - an odyssey | Excel Programming |