list box

  1. L

    list of worksheet and dialogbox to select

    Hi I am trying to get list of all worksheets, popup Dialog box to select a worksheet, then work with it. I thought cud store the sheetname in array, but does not work, please suggest. Thank you Sub ListSheets() Dim ws As Worksheet Dim i As Integer Dim ArrayValues As ArrayList ' This...
  2. V

    Display clicked List Box value in cell to the whole Column

    I have searched whole web looking for answers. Hopefully someone can help me out here. I want the client to be able to click on any cell in Column "R" so the list box will pop out and the client can make multiple selections, hit Save and the cell populates with those values. If there are couple...
  3. T

    Selecting from source : Data Validation

    Hi! I am having a difficult time figuring if I need a VBA for this as I have a source or list with all the items and each cell, I want to select some of the items into a drop down list is that possible? Thank you.
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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?
  10. P

    List box

    Is it possible through VBA code to make a list box display its top value? How???
  11. 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...
  12. 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?
  13. 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)...
  14. 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...
  15. 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...
  16. 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...
  17. 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
  18. 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...
  19. 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...
  20. 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...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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