multi-select list box

  1. M

    Multi select list box selections replace anything in the target cell

    I have a worksheet with cells that are populated by a multi-select list box. I would like the list box selections to replace anything already in the cell, and also not allow any duplicate list box selections in the cell. This is the VBA for the worksheet Option Explicit Private Sub...
  2. D

    Multi-select listbox output into Worksheet Autofilter

    Hello all, I did some searches for this issue and there are some variations, but I can't seem to find my same issue. I am using Excel 2010 and have written/tweaked VBA code for a while now. I have a userform I created with 2 multi-select listboxes and 3 textboxes. The goal of my userform is to...
  3. S

    Click cell to display multiple options selected

    Hi everyone, Here's the situation or goal that I would like to achieve: Col A = Names Col B = Preferences Selected Each person in Col A has to have 4 Preferences. These preferences are not pre-defined but if I have to put them in a list, I don't think that should be a problem. What I would...
  4. A

    Creating a multi-select list that is dependent on another multi-select list

    I hope someone can help me. I am not a programmer so I struggle with code, but I have been managing with the form controls and data validation options in Excel and have created a pretty nifty form. However, I am struggling with one final piece: I need to create a multi-select list in Column...
  5. P

    Multi-Select List Box Code Not Quite Working

    Hi All, I'm trying to use a multi-select list box to determine the items in view on my form. Selecting 1 Item Works! Seclecting 2+ Items Doesn't Work - but there is no ERROR - each of my text boxes which show update, stay blank. The strange thing is that if I run the code and hover my curser...
  6. C

    Error 2585 This action cannot be carried out while processing a form or report event.

    Hi, thanks in advance for any help on this. I need to use a multi-select list box to filter a report. I would like to run the report, have the form display to enter criteria, select a preview bottom that would then display the filtered report. Here is what I have done. I created an unbound...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top