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

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

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
>