multi select

Hi all! I am using the code below to get cell K2 to become a multi select dropdown (not allow duplicates). How would I change the code to have K2 and all cells below it to also become multi select drop downs? Thank in advance! Private Sub Worksheet_Change(ByVal Target As Range) 'Code by...

I really hope that the thread title adequately describes the issue I currently have... @John_w has kindly given me a very good solution for deselecting from a multi-select dropdown, which was an issue that had me puzzled for a long time. I now have a workbook with 3 worksheet (sheet 1, sheet...

I have a sheet within my workbook where I'm trying to do a couple related things at once that I think may be messing with each other. I am applying data validation on the fly first -- in other words, every time I click on a cell in a given range on my sheet "User Lists" it checks the header of...

Hi all, Newbie here in need of some help..... I have a cell which is a data validation dropdown that will eventually contain a lot of values. What I am trying to do is make this multi-select. I have already entered some code to make it multi-select but in the following format: Value1, Value2...

Hello All, I'm looking for a way to select values and filter a set of values in a cell based on another value in a separate cell. Example: <tbody> Type of Candy Subtype of Candy Candy Bars Snickers, Milky Way Candy Bars, Fruity Candy Snickers, Starburst </tbody> You are able to select...

When new users open the file they receive a "Compile error: Can't find project or library" error. Below is my VBA written to open up a worksheet when the field is selected and and also is a multi select drop down box data validation. Any help would be appreciated.... Also when looking at...

I have this code that is to place selections out of a multi-select list box and place them into a worksheet "Production". So what the code is currently doing is, if you select 3 Row in the list box it will place 3 Entry into the worksheet but they are all the same entry date from the last...

HI. I'm currently running a number of pivot tables that are used to extract data for the generation of graphs showing daily progress. To do this, i have a report filter that is used to limit the scope of the pivot table. However, i'm finding that i have to re-apply the filter whenever a new...

I have a listbox with about 15 items with multi-select enabled. I want to copy the selected items to a range in excel. However, if an item is unselected, it should be removed from the range as well. I will be using these selected items to do a vlookup and set flags. I have the following...

Hi! I'm trying to make two multi select listboxes in excel. I have tried I myself, but I know the excistence of VBA only since one week :(. In sheet1 I have a number i.e. 50 in "A1" . First I want to make a list of this number, so cell "A2" = 1, "A3" = 2, .... "A51" = 50. This range has to...