View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kurb kurb is offline
external usenet poster
 
Posts: 24
Default 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