| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting Text to Separate Textboxes
Thank you. That worked perfectly.
"Ardus Petus" wrote: Dim res as Variant res=Split(Range("A1"),chr(10)) tbName.value=res(0) tbDept.Value=res(1) .... HTH -- AP "Nausett" a écrit dans le message de news: ... I have a userform where users input their name, department, phone#, fax# and email. This information is input into one cell on a worksheet. The cell is formatted using chr(10) between each. I want to be able to edit the user information by breaking it back out of the cell an into a userform with 5 textboxes. The text length varies by user. Is there a way to accomplish this in VBA? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting numbers and letters in a single cell to separate cells | Excel Discussion (Misc queries) | |||
| separate two dates from a text string into two separate cells | Excel Discussion (Misc queries) | |||
| Extracting excel worksheet data to separate files | Excel Discussion (Misc queries) | |||
| Clearing text in TextBoxes | Excel Programming | |||
| Text length and TextBoxes | Excel Programming | |||
Threaded Mode
