| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fill Textbox from cell
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Fill Textbox from cell
Valerie
Try this: for last name =LEFT(ClientName,FIND(", ",ClientName)-1) and for first name =RIGHT(ClientName,FIND(",",ClientName)-2) That is dependant on names being separated by comma then space, if no comma then in the formulas instead of comma between inverted commas, use a space and perhaps alter the numbers to suit Regards Philip "V. Roe" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Fill Textbox from cell
Left(ClientName, WorksheetFunction.Find(",", ClientName) - 1) and
Right(ClientName, Len(ClientName) - WorksheetFunction.Find(",", ClientName) - 1) "V. Roe" wrote: 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Fill Textbox from cell
Thanks to both of you this worked great.
"bigwheel" wrote in message ... Left(ClientName, WorksheetFunction.Find(",", ClientName) - 1) and Right(ClientName, Len(ClientName) - WorksheetFunction.Find(",", ClientName) - 1) "V. Roe" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| remove fill in text from a cell from an unpopulated fill-in cell | Excel Worksheet Functions | |||
| using a map to fill in a textbox | New Users to Excel | |||
| HELP! I Lost The Ability To Advance From TextBox To TextBox With the ENTER Or The TAB Keys | Excel Programming | |||
| Textbox Bug? Missing/delayed update of textbox filled via VBA | Excel Programming | |||
| Textbox Bug? Missing/delayed update of textbox filled via VBA | Excel Programming | |||
Linear Mode
