Yeah, I wondered what you were fishing for...

Seems ok to me.

But if the listbox only supports a single selection, you could use .value, too.
But the index seems nicer if you're populating the original listbox using
..rowsource (well, and you want to use that worksheet info for the next
userform).

bach wrote:

That was the easy bit lol.

I was thinking along the lines of storing the listbox index of the item
selected. Using this variable to select the row in the spreadsheet and
display the data in the appropriate form elements does this sound
right.

Bach.

--
bach
------------------------------------------------------------------------
bach's Profile: http://www.excelforum.com/member.php...o&userid=26134
View this thread: http://www.excelforum.com/showthread...hreadid=468634

--

Dave Peterson