list box

  1. Y

    Getting one List (VBA ListBox) to filter into 5 categories based on selection

    I have a list box on my VBA form with a list of U.S. States. The person filling out the form will select states they wish to be licensed in for work. Following their selection and submitting the form I want the states they have selected to appear in 5 predetermined categories with a "," between...
  2. U

    Multiple Listboxes showing ranges from active sheets

    Hi Everyone, This is my First Ever Post: I am creating a user form that will function similarly to a school management system. One of the elements that are part of it is a Pupil Profile, which shows all information relating to the specific child. Currently, each pupil has its own sheet. When...
  3. Crimson Accilia

    Team randomiser based on selections in list box

    Hey all, In need of some help. I would like the names from all categories displayed alphabetically in the top listbox which is taken from the info worksheet. From there I want to be able to create two randomised teams based on selected names in the list box where each category is split evenly...
  4. S

    Reading in cells linked to multiple list validations

    I am trying to update 3 different list validation cells, running through all possible combinations of the 3, and then read in some cell values. The loop seems to work fine, and changes the list values correctly, but the final assignment of the cell values to my other workbook doesnt seem to...
  5. J

    Using list boxes to display distance data with multiple IF AND statements

    This is not about Nested IF statements. Hi I am trying to output data values when 2 list box selections are true. ie. List box 1 = Player position - Left Forward Pocket -Full Forward -Right Forward Pocket etc... List box 2 = Venue -Adelaide Oval -Bellerieve Oval -Carrara etc... When: List...
  6. R

    List Box Sizing

    is there anyway to loop through all my lists boxes and make them the same size when the excel file is opened?
  7. P

    List box

    Is it possible through VBA code to make a list box display its top value? How???
  8. A

    ListBox Range with Filtered Data From a PowerQuery

    Hello, I have a power query table on sheet2 that will have a different range each time the query is ran. I need it to populate a list box on sheet1. Kicker. It also has to be able to populate with filtered data also (filter selection is a combo box on Sheet1 "C26"). I tried a few different ways...
  9. R

    List Boxes Font Size

    I have 42 list boxes. When the file is opened on a different PC and then i reopen it on mine the font shrinks. Is there a way to loop through all 42 boxes when the file is opened and set the all to font size 24?
  10. M

    Read text file using ADO and populate a... Listbox in this example

    The below sub i created to populate a listbox using ADO to read a text file as Access and SQL were unavailable. I needed 2 columns from the txt file and one would differ per user so i used the persons computer username as the column name i would need (so it would work for anybody in the table)...
  11. W

    How to populate a userform listbox from excel data

    Process so far, the problem one is step 3 only: 1. Get file path of document and populate into a listbox (Code below) Private Sub CommandButton2_Click() 'GetOpenFile MultiSelect will return an Array if more than one is selected On Error Resume Next Dim FilePathArray As...
  12. X

    UserEntryForm Dependable multiple selection and entry of multiple rows at the same time

    Hello everyone, I would like to create a user entry form that would create multiple rows in the Worksheet in the following way: The user form would have 3 TextBoxes, 2 ComboBoxes, one multiple selection ListBox and a button for the entry An user of this form would write in the random...
  13. Q

    Create dropdown list with either listbox or combo box where dropdown list length is dynamic

    In Sheet 1, the user would would be choosing the options in the dropdown. I'm not sure whether to use a data validation drop down or a combo box to achieve my goals and how to do it. The items in the dropdown list is located on Sheet 2. The length of the dropdown list will change as new items...
  14. D

    Expanding List Box Beyond 32K rows.

    Hello, Does anyone know how I can increase my list box beyond the 32,000 rows. I have 130K employees that I am tracking and the list box only goes to ee's with last name starting with the letter "E"? Regards, Diesel24
  15. D

    List box selection to a number of tboxes

    Hello all,, please forgive me I posted a similar question a couple of days ago but did not explain very well Im trying for our local charity to write a medic logging VBA Excel,, one of the user forms is to log up eight drugs (ufmedication) the form consists of a listbox (lbdrugs) sourced from a...
  16. J

    Userform listbox populates after pressing enter

    I am new to VBA and am trying to teach myself while putting together some things for work. I am hoping that one of your geniuses can help me out. I have used this forum often and it has a ton of great people so lets get to it. Goal: I want to be able to add an item number and quantity to a...
  17. C

    Extracting Data from Multi Selection List Boxes in Excel Userform

    HI I have a userform that contains text boxes, combo boxes, data pickers and list boxes. There are 2 list boxes, both of these are set up to allow multiple selections. I have code that loops through each control in the form to extract the data to a worksheet. This works fine for everything...
  18. A

    Copy - paste multiple selections in a listbox to a cell

    Hi I have a named range set in Sheet 1. I have inserted a List box in Sheet 2 and provided the named range in the input cell. But How do I save the selected values from this list box to a cell separated by ", " Pls help.
  19. J

    Fill a ListBox with extracted data

    Hello, can anybody help with this? I have a list box that I want populated by extracted date from this code: Sub Listing_Cousrse_Titles() Application.ScreenUpdating = False Dim r, a, Lastrow As Long Lastrow = Cells(Rows.Count, "A").End(xlUp).Row a = 6 If Cells(a, 37) <> xlnull Then MsgBox...
  20. S

    ActiveX command buttons and list boxes not working in a UserForm

    Hello, I'm trying to write only my second UserForm and have bitten off more than I can chew! Here's hoping that some kind soul will be able to help me out. I'm using Excel 2010. My user form contains a series of frames which contain text boxes, labels, list boxes, option buttons and/or...

Watch MrExcel Video

This Week's Hot Topics

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
Top