listbox

Hi all, long time lurker, first time posting. I'm new to VBA, but I've been able to build a couple of user forms for my company's benefits team. My form populates data using xlookup and populating textboxes based on the combo box selection is working well. However, I am having an issue...

Hi, i always encounter error whenver i delete last entry on the excel using the selected indx on listbox i have a listbox SBL_list.List with items coming form Worksheet SBL_T2K ( 9 columns) i need to delete the selected entire row on the listbox from the excel sheet. no error encountered when...

I have two listboxes in my spreadsheet: one allows for multiple selections, the other only one. To be clear, this is not a userform, it's just part of the spreadsheet. Unfortunately, I cannot use VBA as a solution. For the listbox that only allows for single selection, I can work out what the...

Hi, Im trying to create a listbox in my personal working folder. Normally the data is already in the workbook so you can select the cells and link this to the listbox rowsource. But now I want the rowsource in the code itself and not in the workbook. I dont want the data in the workbook. How can...

I have implemented many listboxes with Excel VBA but all of them have been single columns of data. I now have a situation where I have a list of over 70 items and I thought I'd help the user out a bit with the scrolling up and down the list to find the one(s) they want (even though the items...

On a user form, I have 2 sets of 25 text boxes and 1 set of 25 checkbox named TextQty, TextPrice, CheckBox respectively. I am trying to pull the checkbox caption and the values inside the textboxes into a listbox if the checkbox is selected. I want to be loop through each set of the textboxes...

I will explain step by step so I can explain more clear I have this form The data is extracted from this range when I click in the list box value it shows the following form with the values filled but some values are not in the listbox, some of them are in the sheet range I'm using...

I have a ListBox that is filtered by a TextBox, but I want it ot be filter by a ComboBox as well, This means that If the TextBox is filtering specific values, the values shown in the ListBox must be shown in the ComboBox. This is a visual example of it And this is the code that I'm using for...

Let's say I have the following table Sheet name: Values A B C D 1 Folio Model Year Status 2 156 Forte 2022 Delivered 3 452526 Rio 2023 In repair 4 785 Stinger 2023 Delivered 5 475 Forte 2020 In progress An I want to fill an ActiveX List Box but only with the values from...

Hello, I want to give connection when a data selected in listview to listbox. I mean double clicked a data in listview must be also selected in listbox by automatic double clicked way. Every rows have a UniqueID after saved. Thank you for help. Download Link

Hello! I've searched high and low across multiple forums for this specific answer, but I can't seem to find it based on cell value. I can find the VBA code for ALL worksheet names to be listed in the ListBox, but not specific ones based on cell value to be used as selections for printing...

Hey all! First off, here is my code: Private Sub PopoutLeadListBox_DblClick(ByVal Cancel As MSForms.ReturnBoolean) Dim selectedItem As String selectedItem = Me.PopoutLeadListBox.Column(11) SalesForm.BHSDTAPNAMELF.Value = Application.XLookup(Val(selectedItem), Worksheets("MASTER...

Hi all. I have a table that is constantly being added to and i am trying to make a userform to search through the data. At present i think the search function working but i cannot get the table headers to become headers in my listbox. As the table is being added to frequently i have a dynamic...

Let's say I have a table like this, which is the data base And I inserted a list box from ActiveX controls where I want to set a table but only with A B and D columns. How can I do this? I'm not using user form

I have this listbox to pull the information and filter it. However, I put information from 3 columns starting with column B, and defined that it would pull through the offset the information of a column before and a column after. It's working... but I'd like to filter the information from...

How can I get this ListBox to display the states in 2 columns. I've tried a few different things, including modifying the ListBox properties, tried in code. The solutions I've found online all deal with a dynamic array and I could not figure out how to convert that to a static one. This is...

Hi there. I'm doing VBA project, which incorporates ActiveX ListBox component. It's crucial for me to have a multiselect option with checkboxes. I use listbox change event to display information on selected items. However, I faced some strange behaviour of listbox when it scrolls the sheet if...

Is it possible to recall the value selected (highlighted blue) in a userform listbox when form is shown again. Below code uses arrays to show subfolders in a listbox. Option Explicit Private Sub UserForm_Initialize() Dim file_system As Object, sub_folder As Object Dim main_folder As String...

I use this code to search in the list box and it works well, but when I search in the first column in the list box for a number, for example 1, 2 or 3, it gives me all the numbers that contain these numbers, so how can I make it show me in the list box only the specified number in the search...

Hi im, currently making a userform that filters all data based off of a combobox value which works but only pulls 1 row of data instead of all rows with the same cell value I.E Column A. I'm trying to have it search for the combobox criteria in Column A and display all rows with the same cell...