multiselect listbox

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...