Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I'm trying to populate a combo box with two columns and an unknown number of rows. I would like to populate the items using a reference to row and column, such as box(nrow,ncol)="X". This code would ideally put the value "X" into the combo box at the specified row and column. In short, I would like to write to and access the box as if it were an array. And..once populated, I would like to be able to pull values out based on column. So, if I had a box containing: "Peanuts" 1 "Cashews" 3 "Brazil Nuts" 2 If someone selected "Cashews", I would like to access the number 3 which is associated with "Cashews". Can someone explain how to do something like this? thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Show Specific Item in Specific Field | Excel Programming | |||
extracting specific rows | Excel Discussion (Misc queries) | |||
extracting specific rows | Excel Discussion (Misc queries) | |||
Count Specific Item in Specific Row | Excel Discussion (Misc queries) | |||
Removing specific entries from comboboxes | Excel Programming |