Hi, i have a listbox where the rowsource come from a name range
call ABC. Whenever, my user select one item and click on the button. The listbox value will go to cell A1 of Template sheet and print out. The content of Template is base on formula using Vlookup. However, they hope they can multi select and print. How can that be done?
Good morning jp16
Are you using a Forms listbox, or a ActiveX listbox?
It makes a difference, and if you are using the former, then you will need to change to the ActiveX version, which will involve a learning curve, which we can help with.
If you are already using the ActiveX version, then this code will insert all your selections into your linked cell as a comma separated list.
HTH
Please Login or Register to view this content.
DominicB
Hi, i am using user form listbox. I not sure whats the difference the Activex n Form control.
Anyway, I see that the form control also has the ability to multi select from the Multiselect option.
Hence i thot Form Listbox is possible.
Please have a look at my sample file and advice. =)
Hi jp16
It's not clear from what you've posted how you want this formatting (across, downwards, etc), so in this example I have shown what you need to do to capture the data.
In this instance, all we're capturing is the first column, as that is the basis of your lookup formula.
Edit your userform, click on the listbox and in the properties window, change MultiSelect to "1 - fmMultiSelectMulti". Then replace your code with my amended code below.
This will show a message box with your selections in it, as a string. You need to decide where you need to go from here.
HTHPlease Login or Register to view this content.
DominicB
Edit : As you are using a userform, the form / activex statement above is irrelevant. Userforms are different again.
Last edited by dominicb; 05-30-2018 at 06:20 AM.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks