Hi,
I need to fill two textboxes on a userform with information from one cell.
In Range ("ClientName") is text "Last, FirstName". I need to fill Textbox1
with "LastName" and Textbox2 with the "FirstName". I have no problem
filling the textbox with the entire text from the cell, but I have no idea
how to split the information at the comma. The only information I could
find suggested using the Left function, but since the number of characters
can vary that didn't work too well. Any help would be greatly appreciated.
Thanks
Valerie