Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
here is the code i was using to split the variable, however
the information is put together like this : FirstName,Lastname,Mother:1,Mychild,10/12/2007 ,10/11/2007 now the problem im having is when it gets to the date, it doesnt return the date so TxtServed and TxtIssued are still blank vntX = Split(strToSplit, ",") If intChoose = 0 Then SplitMe = vntX(0) & "," & vntX(1) ' First Name Last Name ElseIf intChoose = 2 Then SplitMe = vntX(2) ' MoFa CBo Box ElseIf intChoose = 1 Then TxtFirstName = vntX(0) ' First Name TxtLastName = vntX(1) ' Last Name CBOMoFa = vntX(2) ' parent type TxtChild = vntX(3) ' Childs Name If UBound(vntX) = 4 Then TxtIssued = vntX(4) ' issued Else TxtIssued = "" End If If UBound(vntX) = 5 Then TxtServed = vntX(5) ' served Else TxtServed = "" End If End If |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Splitting strings, error subscript out of range | Excel Programming | |||
Excel Dates w/ No Slashes | Excel Worksheet Functions | |||
Splitting comma separated lines of an address for mail merge. | Excel Discussion (Misc queries) | |||
hyphen to forward slashes? | Excel Discussion (Misc queries) | |||
Splitting Cell Contents with a comma | Excel Worksheet Functions |