View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
lcoreilly lcoreilly is offline
external usenet poster
 
Posts: 11
Default Combobox display 1 value, access another

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.