Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Binding data from database to excel drop down
Hi
I'm using Excel 2002. In one of the excel sheets, I have dropdown control (Combo box). I want to populate the dropdown with the data and values i.e. the data is visible to the user and value is the actual value associated with an item. The data is coming from sql server database. To be precise, two columns are fetched from database, itemType and itemName. I'm able to add the itemName using addItem method. But I'm not able to bind the itemType to the associated itemName. Can anyone help me out? Thanks Jignesh Gandhi |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Binding data from database to excel drop down
Assuming columncount for the combobox is set to 2
with combobox1 .AddItem Itemname .List(.Listcount -1, 1) = ItemType End with -- Regards, Tom Ogilvy "JigiSweetu" wrote: Hi I'm using Excel 2002. In one of the excel sheets, I have dropdown control (Combo box). I want to populate the dropdown with the data and values i.e. the data is visible to the user and value is the actual value associated with an item. The data is coming from sql server database. To be precise, two columns are fetched from database, itemType and itemName. I'm able to add the itemName using addItem method. But I'm not able to bind the itemType to the associated itemName. Can anyone help me out? Thanks Jignesh Gandhi |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Binding data from database to excel drop down
Thanks Tom
That works...... Regards, Jignesh Gandhi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Excel as a database and need macro or vba to take data entered on one tab and update the database by adding to the next avail row | Excel Programming | |||
Excel Drop Down box or check box data to Excel Database | Excel Discussion (Misc queries) | |||
Late Binding examples of binding excel application | Excel Programming | |||
XML Data Binding | Excel Programming | |||
EARLY binding or LATE binding ? | Excel Programming |