Hello all,

i have a form that contains a list box created in MS Excel
Visual basic.
i have got a list of values put into this list box when i
do a search... the values listed are...
cell.value + " " + cell.offset(0,2).value + " " +
cell.offset(0,3).value

when a user double clicks one of these values i try to
open a new form that will list values from that row, using
offset command. but i cannot get excel to recognise what
row i am after as i have tried to open where the row value
(from within the listbox) is equal to .. Cell.value...etc.
this produces an error, can anyone please advise or help
with this problem??

i can give more information if necessary.

Thank you,

Robert Couchman