Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi All,
I have a combobox that gets filled with the following code: 'load combobox with list of grantee institutions With ComboBox1 For i = 5 To LastRow .AddItem Worksheets("data").Cells(i, 2) Next i End With End Sub The drop down menu contains a list of schools, but the data element I really need access to is the ID number, which is in column A. Is there a way to access this value? Maybe using the offset function? I can't seem to figure it out. Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
MultiColumn ComboBox Display | Excel Programming | |||
Combobox display on startup | New Users to Excel | |||
MultiColumn ComboBox Value set/display | Excel Programming | |||
Combobox & Display | Excel Programming | |||
Format Display in ComboBox | Excel Programming |