Offset & Combobox's returned Value

  • Thread starter Thread starter Anat Sn
  • Start date Start date
A

Anat Sn

I have a combobox on a Userform.
The form is supposed to display a bunch of details
describing the Item selected in the Combobox (the data is listed in
a worksheet ,of course).
How do i refer to the C e l l
containg the data the user chose?
I will appriciate your response
T h a n k s in Advance
Anat
 
If the combobox is filled using the rowsource property then

Dim rng as Range
set rng = Range(combobox1.rowsource)(combobox1.listindex+1)
' or
set rng = range(combobox1.rowsource).offset(combobox1.listindex)
msgbox rng.Address & " - " & rng.Value
 
Back
Top