| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check if text box has more than one entry seperated by a comma
Hi all,
I have a text box that the user can put in either a single 7 digit part number or more than one part number, seperated by a comma ",". I am wanting to test the condition - either one 7 digit number or more than one 7 digit number seperated by the comma. Any help would be much appreciated.. -- Les |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Check if text box has more than one entry seperated by a comma
You can use InStr to look for a comma.
You can use Split (xl2k or newer) to parse the string into an array. Les wrote: Hi all, I have a text box that the user can put in either a single 7 digit part number or more than one part number, seperated by a comma ",". I am wanting to test the condition - either one 7 digit number or more than one 7 digit number seperated by the comma. Any help would be much appreciated.. -- Les -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Check if text box has more than one entry seperated by a comma
Thanks Dave
-- Les "Dave Peterson" wrote: You can use InStr to look for a comma. You can use Split (xl2k or newer) to parse the string into an array. Les wrote: Hi all, I have a text box that the user can put in either a single 7 digit part number or more than one part number, seperated by a comma ",". I am wanting to test the condition - either one 7 digit number or more than one 7 digit number seperated by the comma. Any help would be much appreciated.. -- Les -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing Text File with Comma Seperated Data - Need Help Pls | Excel Discussion (Misc queries) | |||
| Comma Seperated File | Excel Worksheet Functions | |||
| How to split a value seperated by comma? | Excel Discussion (Misc queries) | |||
| Importing Comma Seperated Text Please Help ? | Excel Discussion (Misc queries) | |||
| Combine names seperated by comma | Excel Discussion (Misc queries) | |||
Linear Mode
