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