multiselect

  1. P

    VBA EXCEL - Multiple Listbox With MultiSelect

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

    Deselect from Multiselect Dropdown / with vbNewLine / for 2 columns

    I am new to vba, and for two columns I am trying to create a multi-select drop down lists using with vbNewLine (rather than being separated by a comma), but now I want to add in the capability to "deselect" items. This is my current code, as I do not know how to add in the "deselect" code part...
  3. A

    Check Box in Drop down list

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

    How to Offset Column in this Multi Select Listbox?

    I got this code from OnlinePCLearning. How do I offset every other column? Private Sub cmdAdd_Click() Dim addme As Range, cNum As Integer Dim x As Integer, y As Integer, Ck As Integer 'set variables Set addme = Sheet1.Cells(Rows.Count, 4).End(xlUp).Offset(1, 0) cNum = 7...
  5. VBE313

    How do you get Listbox Multiselect values to paste into different pages in multiform?

    I have 10 pages of all the same textboxes but named "Page1Reg1.Text" or "Page10Reg.Text" for example. I would like to know if you could have the multiselect values paste in each page. ListBox1.List(ListBox1.ListIndex).Value = .Page1Reg1.Text ListBox1.List(ListBox1.ListIndex).Value =...
  6. M

    Listbox Selection

    Hi, I'm attempting to prioritize what is selected first in List box for example; I have source that has 1,2,3,4 The user will select 2,1,and 3. When the output comes out into a cell, I want it to show 2,1,3 not 1,2,3. Here is the code that I have; however, I'm getting a subscript Out of Range...
  7. G

    Iterating Over All Selected Items (rows) in MultiSelect ListView

    Hi, I am using a listview on a user form. I have multi-select enabled. I would like to select multiple items in the listview and then take the value found in some other text boxes and push that into the selected items subitems (columns). The listview is a somewhat new beast to me. I have it...
  8. Z

    Data Validation Multi-Select: Have code just need tweaked

    Hi All, I have code that allows for selecting multiple items from a data validation list and separates them by a comma. The code is below. It works fine, but there are 2 things a little weird that I am hoping you can help fix: 1) If a user enters the cell (double-clicking or F2) and hits...
  9. E

    Temporarily Change The Size of a ListBox

    I have a data entry spreadsheet where users can make multiple selections in various cells. In some cells I can use simple drop-down lists. In other cells I need to allow the users to make multiple selections. I know I can use ListBox with multiselect to do this but here is the challenge. I...
  10. H

    VLookup on a DataValidation multiselect column

    I am looking for some help with the following, I have two columns (BA and BD) where I set up (VBA code at the bottom, used with permission) a multi selection drop-down for each cell. The values available are (-,--,Ø,+,++) so that cell BA2 shows several of the symbols in a comma separated list...
  11. C

    Calling Multiple Folders

    So I am writing a program that needs to be able to access a sub-folder within a directory, and pull the necessary data from the 5 excel files within that sub-folder, then move on to the next folder within the directory and do the same thing for the next sub-folders automatically. I want to be...
  12. C

    union , multiselection with .Find method and static range

    Hi everyone! I'm struggling with the following code which you can see below. It is totally a pain in the *** now. I really need some help. This code is a search tool which looks for criteria from every worksheet except the summary and the list. After the .Find founds the word, then the code...
  13. M

    Activex Listbox Multiselect

    Hey there. Trying to use a listbox with the multiselect property. Before, when I wasnt using multiselect, I just had the listbox linked to a cell, but that doesnt work with multiselect. Is there a way to link the listbox to a cell, with the options seperated by commas?
  14. A

    Paste paths down column using file explorer - VBA

    I have this code below... Sub GetFilePath() Set myFile = Application.FileDialog(msoFileDialogOpen) With myFile .Title = "Choose File" .AllowMultiSelect = True If .Show <> -1 Then Exit Sub End If FileSelected = .SelectedItems(1) End With Range("A" & Rows.Count).End(xlUp).Offset(1) =...
  15. K

    Listbox MultiSelect

    I'm have a project at work where I want to make multiselections of a list. These selections will again appear in the next column (or next row). I've used datavalidation before, but I can then just make one selection, but I want to be able to make more than one selection from the list. Maybe me...
  16. N

    Paste Values Selected in a Single-Column MultiSelect Enabled Listbox to Another Worksheet

    I have a single-column multiselect enabled listbox that populates with data from a worksheet called "Testing". I would like to copy all the selected values in the listbox to column AG on another worksheet called "Admin" when the command button "OK" is pressed. Thanks in advance for any help! I...
  17. N

    MultiSelect ListBox with OFFSET-generated range as listfillrange

    Hi All, I've run into exactly the same problem in the linked post: http://www.mrexcel.com/forum/showthread.php?t=499431 But I confess to insufficient VBA "chops" to follow the solution proposed. My current range is something like: OFFSET($A$1,0,0,$C$1,1) where the length varies depending on...
  18. N

    MultiSelect ListBox losing its check marks

    I have a MultiSelect ListBox (ActiveX) applied directly to a worksheet (liststyle Option -- the checkbox version). I am using the ListBox_Change event to trigger a sub that moves the selected items to a list on another worksheet. So far so good. (see code) Private Sub ListBox1_Change() Dim i...
  19. J

    Write selections from Excel listbox to cell?

    Hi everyone, I would've thought this was a simple enough question but I've been searching online for an answer all week, including on this site. I've seen answers that seem to be close to what I'm looking for but when I attempt to extrapolate and modify the code I get nothing but error...
  20. T

    Multiselect listboxes

    Hello - I would greatly appreciate some help with a problem I have come across. I have a form that has two listboxes and listbox1 is populated with the column headers in my worksheet. I want to be able to have the user select columns on the left and "add" them to listbox2. Here is the code...

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