listbox entries

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

Is it possible to extract a value from the listbox? I have a listbox that populates automatically from a table on an excel sheet. It has 7 columns and the number of rows varies in length. I was wondering if I select a row from the listbox is it possible to extrapolate the value that resides...

This is my first request on this forum. I cannot find this seemingly simple answer. I have a multiselect listbox (serlib) and textbox( fnbx) on a userform. The Commandbutton has vba that search the reference number(which is in the textbox) down column A, and if found, populates the Listbox with...

I have a multicolumn listbox. I would like the user to be able to change the selected value with an input box. This is the code which I have written so far - with an example value Dim intListitem As Integer intListitem = lstOrders.ListIndex Me.lstOrders.List(intListitem) = "12.12.2012" When...

I need code to activate autofilter allowing the user to select criteria from a specific Field. I'd hoped to simply activate the autofilter and pause execution while the user selected the appropriate criteria and then processing would continue. The sole reply to my prior post suggested...

Hi, I have problems in determining the content of the ListBox, where I wanted the contents of the listbox only containing the values according to the specified criteria. here is the example data <tbody> A B 1 one OK 2 two - 3 three OK 4 four OK 5 five - </tbody> from the above...

Hello everyone! Hopefully you can help me with this and I'm just missing something really simple :nya: I'm having an issue with a worksheet I have pasted into a PowerPoint slide using Paste Special>Paste Link>Microsoft Excel Worksheet (code) Object. The trouble is in the worksheet I have a...

Hello, I am trying to filter a range of data based on the values a user may select from a Multi Select Listbox, but I cannot get it to work. I have a working Listbox (Listbox1) My command button (CommandButton1) does not execute the filter, I have searched and searched, and tried many...

Hello I have a list box (Listbox2) that I would like to hide a row on a different sheet based on the selections made. I have tried a number of codes and the closest I can get is to hide all of the rows regardless of the selection. List box references: "a","b","c" Rows to be hidden: "a" -...

I am using an Active-X listbox on my worksheet and trying to add items but having a problem trying to insert the last item. I'm getting a run-time error. Here is what part of the code looks like: For r = 3 To rowCount If Sheets("Sheet2").Range("B" & r).Value = ComboBox1.Value Then...

I'm trying to add items to a listbox, but get a runtime error on the last item: ... ListBox2.List(i, 0) = Sheets("Sheet2").Range("B" & r).Value ListBox2.List(i, 1) = Sheets("Sheet2").Range("C" & r).Value ListBox2.List(i, 2) = Sheets("Sheet2").Range("E" &...

I have a multiselect listbox on my Userform. That is, the property of this listbox is set to multi and the liststyle is set to Option. The purpose is to be able to select multiple rows from this listbox so I can delete the records selected from the worksheet. For example, the listbox shows...