Solved: separate text

[av8tordude]

In the cell is the City, State (i.e. Miami, Florida). I have this code that populates txtCity text box with the City, State. I would like to separate them and populate two different textboxes (i.e. txtCity & txtState). Currently the txtCity textboxes displays both the city & state in one textbox. I only what txtCity to show the City (i.e Miami) and txtState to only show the State (i.e. Florida). Can someone assist with modifying this code to achieve this. Thank you.

[vba] txtCity = Application.WorksheetFunction.VLookup(Range("CB10").Offset(frmCalc.ListBox3 .ListIndex + 1, 0).Value, rRange, 8, False)

txtState =
[/vba]

[macropod]

Try:
[vba]txtCity = Split(Application.WorksheetFunction.VLookup(Range("CB10").Offset(frmCalc.Li stBox3.ListIndex + 1, 0).Value, rRange, 8, False),", ")(0)
txtState = Split(Application.WorksheetFunction.VLookup(Range("CB10").Offset(frmCalc.Li stBox3.ListIndex + 1, 0).Value, rRange, 8, False),", ")(1)[/vba]

[av8tordude]

Works great. Thank you macropod