the listindex property of the form returns the item number in the list, a
value from 0 to n (where n = number of items in your list less 1), a value
of -1 indicates that no item is selected.

If you use the list index then a select case statement could be used to open
a separate form, something like with a value being set to indicate the row
to open in the relevant form which uses the value in xRow to load data.....


select case SNEM.ListIndex
case is = 0
xRow = "B"
userform0.show
case is = 1
xRow = "C"
userform1.show
end select

--
Cheers
Nigel



"Oreg" wrote in message
...

Hello,

In short, I have a listbox as part of a form called "SNEM", which
displays data located on Sheets("SP"). I would
like to be able to double click a row of data within that listbox, and
have a separate form appear
displaying the data I selected allowing me the ability to make and save
changes.

Currently I have a seperate form, called WMS, that finds the next blank
cell in column B of Sheets("SP") and
enters data in cells B thru M.

I can create code to call a form when the listbox is selected, but I
don't know what code to used that would recognize
the line selected and display that row (B - M) inside my new form. Is
this possible ?

Thank you in advance.


--
Oreg
------------------------------------------------------------------------
Oreg's Profile:
http://www.excelforum.com/member.php...fo&userid=9195
View this thread: http://www.excelforum.com/showthread...hreadid=474539