you' need either to add a third column c, where c1:= =A1 & "," & B1
then set your rowsource to column C
OR
don't set the rowsource , but load the listbox on the form's initialise
routine

for each cell in range("Aa:A12358")
listbox1.AddItem cell.value & "," & cell.offset(,1).value
next

"bjorn" wrote:


I have a Row Source which is working quite well, however I have two
columns.
I require that when I select, both of them are showed, for example A2
and B2 show next to each other with a comma (,)
------------------

Sheets("Sheet1").Select

LPC.RowSource = "a1:b12358"


--
bjorn
------------------------------------------------------------------------
bjorn's Profile: http://www.thecodecage.com/forumz/member.php?userid=897
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=137426