Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello
I've tried a few things, but I cannot figure why the listbox does not reflect the Tabs properly: The code: For ArrayNumber = 1 To 3 Select Case ArrayNumber Case Is = 1 sArrayName = "MasterList" Case Is = 2 sArrayName = "MLIndex" Case Is = 3 sArrayName = "CxB" End Select sStartDate = vArray (ArrayNumber,1) sStopDate = vArray (ArrayNumber,2) sString = Format(sArrayName, "") + vbTab sString = sString + Format(sStartDate, "") + vbTab sString = sString + Format(sStopDate, "") + vbTab lstBox.AddItem sString Next I get this in the listbox: CATEGORY START DATE STOP DATE MASTERLIST 1/11/2000 1/11/2005 MLINDEX 1/11/2000 1/11/2005 CXB 1/11/2000 1/11/2005 I want this: CATEGORY START DATE STOP DATE MASTERLIST 1/11/2000 1/11/2005 MLINDEX 1/11/2000 1/11/2005 CXB 1/11/2000 1/11/2005 Appreciate any suggestions K |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
listbox B conditional of input in Listbox A | Excel Discussion (Misc queries) | |||
Multicolumn Listbox and ordinary listbox | Excel Programming | |||
listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
Is refreshing listbox rowsource in listbox click event possible? | Excel Programming | |||
Sorting ListBox results or transposing ListBox values to other cells for sorting | Excel Programming |