Text Box to List Box

[ManningFan]

Every month I get a huge list of product codes I need to track. I have
written a very detailed script to perform this task.

The problem is, I copied someone else's form because I was in a rush.
I have yet to sit down to tweak this, but I'm hoping I can use a
bandaid rather than re-write the process.

The form I use allows you to enter (or cut-and-paste) one product code
at a time into a combo box. You press a button and the contents empty
into a list box. You can do this however many times you need to, with
the list box adding a new record each time. My script reads the
listbox and works its magic, looping through each value.

This is fine and all, but I'd really love to be able to cut-and-paste
the original list into a text box, press a button and have that list
parse out into the list box. I'm feeling a little fried at the moment,
anyone got any code lying around that can perform this task?

[rkc]

ManningFan wrote:

Every month I get a huge list of product codes I need to track. I have
written a very detailed script to perform this task.

The problem is, I copied someone else's form because I was in a rush.
I have yet to sit down to tweak this, but I'm hoping I can use a
bandaid rather than re-write the process.

The form I use allows you to enter (or cut-and-paste) one product code
at a time into a combo box. You press a button and the contents empty
into a list box. You can do this however many times you need to, with
the list box adding a new record each time. My script reads the
listbox and works its magic, looping through each value.

This is fine and all, but I'd really love to be able to cut-and-paste
the original list into a text box, press a button and have that list
parse out into the list box. I'm feeling a little fried at the moment,
anyone got any code lying around that can perform this task?

Why don't you just work your magic and write some
code that reads the list you receive. Skip the other
guy's code that uses the form, listbox and whatever
else you don't understand.

[ManningFan]

I ended up doing it anyway. Pain in the butt because I had to strip
carriage returns and line feeds.

rkc wrote:

ManningFan wrote:

Every month I get a huge list of product codes I need to track. I have
written a very detailed script to perform this task.

The problem is, I copied someone else's form because I was in a rush.
I have yet to sit down to tweak this, but I'm hoping I can use a
bandaid rather than re-write the process.

The form I use allows you to enter (or cut-and-paste) one product code
at a time into a combo box. You press a button and the contents empty
into a list box. You can do this however many times you need to, with
the list box adding a new record each time. My script reads the
listbox and works its magic, looping through each value.

This is fine and all, but I'd really love to be able to cut-and-paste
the original list into a text box, press a button and have that list
parse out into the list box. I'm feeling a little fried at the moment,
anyone got any code lying around that can perform this task?

Why don't you just work your magic and write some
code that reads the list you receive. Skip the other
guy's code that uses the form, listbox and whatever
else you don't understand.