How to change from single select value to multiple select?

[trade-market]

Hi guys,

We paid a developer to help us develop an automatic way to print shipping labels from excel with addresses and names, however it was left so that only single customer names could be selected. We now require multiple customers names to be selected as our business is growing and we print multiple labels.

I was wondering if anyone could give me any pointers on what to change in this code?

Please Login or Register  to view this content.

Thank you in advance.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

[6StringJazzer]

I don't see anything in the code that explains how a customer name is "selected". What exactly do you mean by that?

Also, there is a loop in the code; to me it looks like it processes everything in column F until it finds a blank cell. That doesn't sound like just doing a single name to me.

It would help if you attach your file.

[ptmuldoon]

I see reference in the code to a second sub calling a UserForm.

Can you possible post the file, or the UserForm code.

Just guessing here. But thinking the userform needs to allow for a multiselect and then modify onclick event to loop though each selection.

[trade-market]

I've attached an anonymised file.

Thanks for the responses thus far greatly appreciated.

[trade-market]

Here's the code for the userForm:

Please Login or Register  to view this content.