multiselect listbox

I've 2 listboxes, both with MultiSelect option. The 1st listbox is LstCustomer and the 2nd listbox is LstTransaction. In LstCustomer it only showing the customer name and in LstTransaction it showing the customer name, invoice number, and transaction date. How do I make it so that when a...

Hello expert, I have 2 Listboxs (txtActionby & Listbox1), i would like to do a multiselect in txtActionby separated by comma and will be displayed in the Listbox1 once the Add button is pressed. And whenever i want to update the data, the previous multiselected person separated by comma will be...

Hi all, I'm in need of a Check Box in Drop down list for multiple selection. The code which i had is given below. The disadvantages of the given code was duplication and unable to edit the selection. Private Sub Worksheet_Change(ByVal Target As Range) Dim Oldvalue As String Dim Newvalue As...

Hi, Currently I am into a project where I was stucked writing code for the below mentioned activity. I have created an userform with a multiselect Listbox and a Command Button ListBox populate the Items from a Table Source with 2 Columns. <tbody> Zone Region North N1 North N2 North...

I've been trying to create an UserForm for printing from a dinamically generated ListBox of available Sheets on my workbook. It looks like this: I set 1 - fmMultiSelectMulti in the ListBox properties to allow multiselection. Usually, I need the sheets printed in color, as well as a copy...

Dear all, I've been trying to create an UserForm for printing from a dinamically generated ListBox of available Sheets on my workbook. It looks like this: I set 1 - fmMultiSelectMulti in the ListBox properties to allow multiselection. Usually, I need the sheets printed in color, as well as a...

I have created a small macro to display a checklist that can by checked off and says "Complete" once all items have been checked. I created this using ActiveX Listbox with multiselect. However, when the file is saved and reopened, all the check marks clear out. Is there a way to fix this so...

I have Part IDs in Column C and my userform has Listbox containing Part IDs. If I select Part ID in Listbox then whole row containing that PartID should be selected. My Listbox is multiselect. So if I select multiple IDs then it should select corresponding multiple rows

Hi there! I am working on creating a userform for quality assurance data entry. Basically I want my form to find the next blank row in my sheet and enter in the data selected on the form. I currently have it working where a single entry can be made into each cell, but I have a few list boxes...

Hi guys, I'm new here and probably the most noob in the world of excel and VBA programming. Recently, we are creating a sort of calculator for Tuberculosis (TB). One part of which is the generation of graph based on the data provided by the World Health Organization. I have successfully...

So I have created a form for people to fill out, and I want them to be able to pick several options from a listbox. Then, when they save the form, I want the options they selected to populate in the next available row as an array. Here's what I have: Private Sub btnsave_click() Dim irow As...

Hello All, I currently have a sheet that lists our sales by item by brand. There are 2 tables, one at the top that represents units and another below that to represent dollars. I'd love to use a multiselect listbox to allow users to choose which brands they want displayed. (If the...