Missing vbTab in listbox
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
|