listbox

Hi all, I have a UserForm that Loads and Shows when the Workbook is opened. The User is given the current date setting that is saved to a worksheet cell on each use. Ths User is then given a choice to use a different date Yes or No. If the User chooses Yes, then a Listbox on the UserForm is...

Hello all I really need your help as the topic title says I need to find the minimum, maximum, less than 4000 among the selected listbox items. AB1EmployeeSalary2Gilmore34403Stone67804Horton102445Rice54326McDaniel205447Fowler123228Paul54409Burns765610Robertson4568 I already have a form, but I...

I want to pass values from a userform to an excel table. I use an UPDATE button but it only works when i doubleclick on items of the listbox. When i use one click it doesn't work! Any ideas why?Thanks a lot in advance... ---- code for click event in listbox------- Private Sub...

Hi, I have a search button in a userform to highlight/select the matching list item based on the value entered in an inputbox that is activated by this search button. I would like to be able to select the list item, regardless of case sensitivity. With the code below my entered value does not...

hello i found this code in this site that nearly answer my problem in excel vba coding, but when i ran it, it display only the first column.. how can i include the other column like column B, C and so on.... Thank you. Private Sub CommandButton1_Click() ListBox1.Clear Dim i As Long For i =...

Hi all, I'm brand new to VBA, so I'm trying my best but I could definitely use some help on this one. I have a listbox of 5 items with the ability to select multiple items from the listbox. However, I want when you click on an item in the listbox for a textbox to appear relating to that...

Hi I've just started using a ListBox in Excel to view a table from one sheet on another. I've been able to do this using very simple code as Private Sub UserForm_Initialize() Me.ListBox1.List = Worksheets("Cashflows").Range("A4:H26").Value End Sub However, as this does not include...

I have a userform listbox where I want to filter data using two parameters - ALL, Parameter1, Parameter2. With the code that I have written I am only able to filter data using Parameter1 not Parameter2 or All. By default, 'All' is selected which should show all records in the listbox. There are...

I use the code below to filter the Sheet "Customer" . When opening the form, the Sheet "Temp" receives all the records from the Sheet "Customer" Automatically shows all records in ListBox1. To make the filter I have to click on the option button, open the textBox to enter the Customer's name...

So, somehow I was able to get the list to show up like I wanted. then I wanted to do better, deleted the code aaaaaaaaaand it won't work. Now I can't even get the RowSource to work with the Name Manger dynamic range I set up. At one point I could get a click event to run but not return anything...

Hi, So I am missing the complete obvious here but I am trying to populate a listbox in a userform from an named excel table. I have managed to do this by creating a named range that refers to the table, code A below. But when I am using my userform to delete entries it is crashing out and...

Hi all! I have a multi issue here with a listbox. I'd like to make a listbox that shows only the selected columns with filtered data of my Database sheet. That page has 13 columns ("A:M") with data but I need only the A, C, D, and K columns to be visible. The last row needs to be dynamic and...

Hi everyone, I was wondering if you can enter data into a listbox as a number? As far as i can find out it seems that listboxes only allow data to be entered as text. I have been looking for a few days now but don't seem to find any specifications on listboxes... Any help would be greatly...

Hi everyone, I found this module which allows scrolling with the mouse wheel ComboBox and ListBox. It works well as long as the workbook is opened on the main display but if you working with multiple displays and have your spreadsheet application opened on a different display the mouse wheel...

Hello! I have a code in my workbook that exports the workbook as a CSV in a specific format. I have multiple sheets in my workbook, one called "Data" and twelve others named for each month. I would like to be able to run the code by having the user select which sheet (or month) they would like...

I have a listbox which is filled with data transferred from textboxes in the userform and not from sheet. The listbox has multiple rows and columns. I have also added a code to delete a row before final saving of the data to excel sheet. Hence if I try to give / add a row number through a...

I have 6 listbox'es that are named "lb_RU_#" where # is the number of listbox. each listbox has 6 options. I want to find which items are selected in each listbox and save the value to an array. This is how I can do one list box at a time: Public i_SelectionCount1 As Integer Public l_ForLoop1...

Hello, I have an excel database with about 50 unique sheets. The formatting of these sheets is the same in all cases but each worksheet is for a different supplier, some worksheets contain 10 rows, some 450+ I made an userform, to make it easier to add, edit, etc. the products listed on these...

Hi, Thanks for looking at this... I have the code below that takes a custom sorted list from a Listbox in a Userform puts the items in to an Array and then creates a custom sort to be applied to a table called 'RotaOutbound'. The code all works fine when I tested it on a list in a column but...

Hello, I am trying to get a Listbox to run a macro. I have the box open with 6 items. Based on the selection a macro will run for the specific choice. Example: If January is selected Sheets("January"). Visible=true Create a drop down 1-4 If August is selected Sheets("August")...