listbox / userform

Hi there, I have a userform that contains a listbox that retrieves it's data from a table in a worksheet called Breakdown. The userform has a search function linked to the listbox and has a button to edit and a button to delete. These two buttons open their own userforms - for example the delete...

I'm trying to create a search function in my userform that's connected to the listbox. I have three textbox options to search from - search via surname is Textbox1, first name is Textbox2 and by year is Textbox3. I've managed to get it to kind of work, however when I add the else if's for the...

Hi, I'am hoping to get some help here. I have a userform that needs to show values, if some criteria is met. please see attached file. ( extra data has been removed ) How it should work: I fill in the clocknumber and the job is being shown => this works then I fill in the StartDate & EndDate...

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

Hello all, I have the following UserForm and would like to only show ListBox results for the employee that is selected. Here is the current VBA code I am using to populate the list box: Sub AnalyzeEmployees() Dim DataTable As ListObject Set DataTable =...

Hello, I have a workbook with a worksheet called Audit_TP_BPP and a worksheet called List. On this list sheet there is a table with a named range called CommAudList. One column in the table on the Audit_TP_BPP worksheet requires a dropdown list that refers to the named range CommAudList and...

i found this code for master DanteAmor https://www.mrexcel.com/board/threads/combining-data-in-listbox-on-userform-across-multiple-sheets-and-calculate-values-amongst-them.1182427/page-2#post-5758315 and i try modifay it to suitable for me but its not appear all item in column 8 when the...

I Use this code to bring the data to the list box. It appears as in picture 2. It is required to appear as in picture 3, where the data is merged according to the name of the product. Picture 1 contains a table format and an Excel file attachment N11 On Error Resume Next...

How can a change event be captured in a list box, when you re-select the same item. In this case, there are 2 list boxes. 1. After selecting an item in the first listbox, there is a change event. OK. 2. Then select an item in the second listbox, there is a change event. OK. 3. If I go back to...

How can you find the default height of listbox entries. This is to resize the height based on the formula: Height = Row height * number of entries. Can it be done in pixels as well?

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 Everyone I have a listbox as such: I want to be able to multiply the Weight (kg) column with my selected rows only by the value in the text box seen above the Qty button. I then want to add those values to the listbox as a new column. I have no idea on how to do this I have tried a few...

I have a "Data" worksheet that I want users to be able to edit the data in this worksheet by using a Form (keep the data uniform). When the user opens the initial form (UserForm1), this will display all of the rows of data that they can select from to edit. Because this data set is large (will...

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

Hello everybody, I'm making an Visitors Registration Form. it's almost finished but i'm a newbie and i can't figure out howto ONLY SHOW users in my listbox that have not CHECKED OUT yet? or better said, howto hide or make users not appear in the ListBox after clicking on the commandbutton...

I want to make a filter to show in a listbox all the coincidences with the text write in a textbox. and set focus in the coincidence. How can i do it? Here is my file LINK TO FILE Thanks for youre help

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

Hi everyone, I have a Userform where information is entered by the user. Once they click the cmdAdd button, the code should create a new row in the table and then copy the user added information into the relevant columns. When adding ListBoxes to my Userform, my code no longer works as intended...

Please assist i want display all info in a row in the listbox currently its only showing the data in the first line i presume its something to do with the offset please help me Private Sub TextBox207_Change() Dim rFound As Range Dim sFirstAddress As String Dim LName As String...