Hi, Does anybody know their way around listboxes in userforms.

I have created a userform that has a listbox inside it that lists a
range of cells ( an area defined as "Test" ) from a worksheet ( Sheet1
) that is made up of 5 columns and 48 rows each row being called "R1"
"R2" and so on.

The listbox does list the 5 columns from the "Test" range and does show
"R1" and "R2" etc including the other text on the same rows as the
Sheet1 info.

I would like to be able to select one of the displayed selections "R1",
"R2" or so on from within the listbox, ( using the double click code )
and have only the "R1" or "R2" or so on, written inside a cell say A1
on Sheet3

The same cell can be re-written over as many times as you would want
to.

Is this possible??


--
sparx
------------------------------------------------------------------------
sparx's Profile: http://www.excelforum.com/member.php...o&userid=16787
View this thread: http://www.excelforum.com/showthread...hreadid=566838