PC Review


Reply
Thread Tools Rate Thread

Check if text box has more than one entry seperated by a comma

 
 
Les
Guest
Posts: n/a
 
      15th Sep 2008
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
 
Reply With Quote
 
 
 
 
Dave Peterson
Guest
Posts: n/a
 
      16th Sep 2008
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 With Quote
 
Les
Guest
Posts: n/a
 
      16th Sep 2008
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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to remove duplicate text with comma seperated geniusideas Microsoft Excel Programming 5 15th Dec 2009 06:48 AM
Importing Text File with Comma Seperated Data - Need Help Pls Brando Microsoft Excel Misc 1 17th Apr 2008 04:59 AM
Two values in the text field seperated by a comma find that value. =?Utf-8?B?cXVlcnk=?= Microsoft Access Queries 1 28th Jun 2007 01:16 PM
merge text from a column into on cell seperated by comma's Craig Microsoft Excel Programming 3 18th Nov 2005 10:44 PM
Importing Comma Seperated Text Please Help ? =?Utf-8?B?Qnlyb24=?= Microsoft Excel Misc 1 16th Aug 2005 10:36 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:32 AM.