multiselect

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

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

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

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

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

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

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

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

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

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

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

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?

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

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

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

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

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

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

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

On my excel userform I have two list boxes, one with peoples names and this transfers their email address into listbox2, which has multiselect activated, with a command button. That works fine. I would like to know, in really simple coding :), how to convert the Listbox2 results into an array...