list box

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

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

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

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

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.

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

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

Hi, Is there a way of adding data that has been selected as drop down boxes into a table? - I have added a list box as a data validation in cells D3, D5, D7, D9 - Can I add a button that takes this data and adds it to a table and then deleting the data in cells D3, D5, D7, D9 to allow the form...

I am creating a dashboard from survey data. I have created a comment box that will generate comments into a nice box with a scroll bar. However, the box changes sizes, moves location, and the font is barely legible after saving or reopening the dashboard. I don't have any of issues with any of...

Hi from reviewing the forums I think VBA might be able to help solve my problem but I'm not sure how... Any thoughts gratefully received! I have a list of sections that will be selected as installed or not installed and all part numbers within that section need to first be switched to match...

For some reason the code below will end up deleting every item in the listbox when you select the last item in the list. If I select any other item besides the last item in the list it will only delete that selected item. Private Sub DeleteIngredientButton_Click() Dim Index As Integer...

Hi, This question has no doubt been asked hundreds of times but for some reason I can't find it anywhere on google which is incredibly frustrating. I have a listbox (listbox1) with data in it and multiselect activated. I select multiple fields from this listbox selection and press OK. All I...

I am attempting to match data (state and year) in two tables that have the same h row and v column headers by using 2 drop list State Year Population Cases Drop List Drop List Result From Table 1 Result From Table 2 Both tables would look similar to the following: Table 1 (Population)...

Hello! I'm new to vba in excel and understanding the language & i need help with my user form :confused: I have created a form that acts like a Log Form to track who goes into a room. In my form I have two command buttons that allow users to Submit Entry & Log Off. The Submit Entry button...

Hi, I am just wondering if there is an easy way to run a macro based on the values within a listbox. E.g. I have four macros for four reports. I add the names of these reports into a listbox and select them as necessary. How do I then reference them in Application.run or Call? Item names /...

I have created a document that has a list box where the user selects the items and then adds them to a restricted section of of a Ammo Tab A27 - A71. when the user opens the form up with the list box there is 2 items automatically selected, how do I stop this. I have attached a link below with...

Hello, I'm working with an excel worksheet with macros and there are several Combo Boxes (Form Control) on one worksheet. Most of these Combo Boxes have only 2 items to choose from so I thought it would be nicer to have List Boxes to replace them. I started by trying to replace just one combo...

Hi, How to display the inputs to list box. I have a text box which will ask the Product ID and everytime when i click the button add new one, the text box should become empty to get the next input and whatever input that i gave should get display in the list box. I tired to transfer the data...

Hi, I have form which will ask the product ID's. Whatever the user entering via text box should get displayed in list box. Example: Form with label "Enter the Product ID" and followed by a text box to get the input and three buttons "Add to the List" and "Delete from the List" and "Close". I...

Hi! I'm new at using MS Access. My team needed a task tracker that would encompass various task groups so I decided to use a Task Management template to create an MS Access database. Under one task group, we have a number of sub-groups that currently keeps one excel file tracker each. For...