listbox multi select

I have successfully used a code to create the multi-selection drop down menus across an entire column but I was wondering there was a way to apply it to multiple columns on the same sheet. I currently have it for E(5) but want to apply it to F(6). I don't have a row limit as we plan the data...

Hey all, First post, hoping someone can help! I've been going at this for a while now: My original goal was to create a dropdown multi-select listbox with check boxes. I have about 20 selections going into the list box and didn't want to see the selections until I selected the cell and dropped...

Hello, 2nd time here today nagging you all :) What I'm looking for is: For each word in listbox find the word in the specified range, and copy a textbox value to the found column first empty cell. I get exacly that result with the first item of the listbox but it doesnt work with the second...

Hi I am building a userform that will add 3 fields to the next row in a worksheet. The worksheet has 3 columns with 2 command buttons in the 4th column labeled Add DAA and Edit DAA. Like below <tbody> DAA Career Path Skills/Strengths Add DAA Edit DAA </tbody> The UserForm has...

Hi everyone, Still pretty new to VBA and kind of learning as I go and have come to a halt with one thing I'm trying to do. I have a form built for a team to input data about meetings they hold and I want them to be able to choose multiple items from a list of "meeting purposes" and not have to...

I need to create 2 lists from which a user can select up to 10 items out of 155 and all 155 items need to be easily visible without having to move the page down. I would like to be able to do this by creating two listboxes that have checkboxes on each item from the form controls toolbox, but I...

Hi all, I am working with a checkbox listbox and am having trouble with getting the concept I have planned out of my head and into Excel. The userform has a combobox listed at the top (w/ free-form text entry), followed by the listbox, and finally a command button at the bottom of the form...

Hello everyone! Hopefully you can help me with this and I'm just missing something really simple :nya: I'm having an issue with a worksheet I have pasted into a PowerPoint slide using Paste Special>Paste Link>Microsoft Excel Worksheet (code) Object. The trouble is in the worksheet I have a...

I have a listbox defined as fmListStyleOption, fmMultiSelect with 2 columns. I want to insert two columns of data into the listbox. How to get this to work? For r = 1 To 10 If Sheets("Sheet1").Range("B" & r).Value = ComboBox1.Value Then ListBox2.AddItem...

Hey...I've made listboxes in the past where the single selection feature works in that the cell reference changes numbers based on the single selection of the list box. However, I would like to "upgrade" my listbox now so that multiple items in the listbox can be selected at once and there is a...

Hi, I've got a listbox in which the user selects multiple items (say 1, 3 and 5 from a list of 1 to 10). I want to take those selections and add them to an array in the main module. I can't seem to get the data from my listbox to an array outside of the userform...any ideas?

I get 'Error 424: Object required', and I can´t figure out why. I have a listbox named ListBoxforPrint in the Worksheet (not a userform). SmainMenu is the CodeName of the sheet. Can you please help? Tx

I have workbook that has a tab for each week in a month. I have used a VBA userform with a multiselect listbox to allow the user to select multiple worksheets to roll-up into a summary worksheet. My problem is writting the sum formula to accept the listbox's array. Here is my code. I have used...