Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
RowSource command
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
RowSource command
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
RowSource command
I am quite new... I didn't quite understand this. How am I to create the sum? Using for each cell in A = (a1, b12358)... or initialise? Is it possible to help me abit more please? -- 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
RowSource command
I assume you have a userform with a listbox control?
then in then simply add this code Private Sub UserForm_Initialize() For Each cell In Range("Aa:A12358") listbox1.AddItem cell.Value & "," & cell.Offset(, 1).Value Next End Sub "bjorn" wrote: I am quite new... I didn't quite understand this. How am I to create the sum? Using for each cell in A = (a1, b12358)... or initialise? Is it possible to help me abit more please? -- 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
RowSource as a row | Excel Programming | |||
Refreshing ROWSOURCE | Excel Programming | |||
RowSource | Excel Programming | |||
help with rowsource | Excel Programming | |||
Using IF, Then with rowsource? | Excel Programming |