| 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 |
| 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 | |||
Threaded Mode
