Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
manipulate string
hi I got a string which is designed as follows XXXX/XX/XXXXX X = numbers which a user has inputted. I have three textboxs whic allow the user to only enter in the values like that. I have the following Sub test() Activecell.value=textbox1.value & "/" & textbox2.value & "/ textbox3.value End Sub Now the problem is that I want to check the spreadsheet for this recor which was created. If it is found then my userform is updated to show the details. How d I rectrieve the three bits of data and put them into the relevan textboxs -- funkymonkU ----------------------------------------------------------------------- funkymonkUK's Profile: http://www.excelforum.com/member.php...fo&userid=1813 View this thread: http://www.excelforum.com/showthread.php?threadid=47501 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Manipulate a Range | Excel Discussion (Misc queries) | |||
How do I manipulate a string to collect the address from it? | Excel Discussion (Misc queries) | |||
manipulate data | Excel Worksheet Functions | |||
Possible to manipulate Legend? | Charts and Charting in Excel | |||
Best way to manipulate CSV files | Excel Programming |