S
sparx
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??
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??