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

Hi,
Try the macro in double-click event for the listbox.

OR
see samples similar at
http://au.geocities.com/excelmarksway

OR

Send instructions and worksheet to me. I will do it for
you.


see my "excel 2000" handiwork at
http://www.geocities.com/excelmarksway

regards
Mark

-----Original Message-----
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
.