userform listbox

I have a worksheet ("Breakdown") that consists of a table ("breakdownTable"). I have a button that opens a userform called "SearchForm" that displays a listbox. So far I have it so when I double click a selected item from this list box a second userform called "EditForm" displays that...

Hi All, I have a dilemma with one of my UserForms. In a nutshell this tablet is recording data by the user's entering information. This questioned UserForm is a function for a supervisor to check on the user randomly. Updating the main ComboBox is triggering the refresh method Here is my...

Hi All, have trawled the net with no complete answer so am once again turning to the good people of MrExcel. I have a userform which contains 2 list boxes. ListBox1 uses the below code to cycle through a range and removes duplicates (works fine). I need listbox2 to populate itself based on the...

Hello, So I've been at work on a userform to brush up my skills on vba and i've managed to create a userform with a listbox that displays data from a spreadsheet and gets filtered by some combo-boxes when options are selected. Everything runs well but the only issue i'm having is setting a...

Hi there, I'm an average vba programmer (actualy a mathteacher and an exam manager at a k12 (kind off) school in the Netherlands). And I'm realy stuck within vba with the following: I try to populate an userform listbox with pivotrow.pivotitems of a filtered pivottable. And I'm searching the...

Hi all, I have found several "old" posts on different fora stating code for making the mouse wheel scroll in listboxes on a userform. However... they are all written in a time pre-64-bits and do not work on my "modern" system. Can anybody help me out with a set of modules and codes to make it...

I have two spreadsheet columns of non-contiguous data. Column B is the "key" column. VBA rng1 consists of cells where there is text in Column B cells. Trying to create VBA rng2 which consists of rng1 cells and the adjacent Column A cells. Next is to then populate two array columns with each...

Greetings, I have a list named "Fruit_List" which has 4 values (Orange, Grape, Apple, Pear). I have placed these values in a list box, but am having trouble calling the related information into a new worksheet, which the user would input additional values and submit in entirety on a 3rd...

Hello all, I am trying to create a userform where I am trying to retrieve data based on selection of two listboxes. I have a column which has various networks and values for three types(Type1, Type2, Type3) for various quarters as shown in the screenshot-------->Screenshot by Lightshot There...

Hi I have Created a excel user form with three Combo box and list box with 3 columns. When user selects a value from drop down list and click Add button it will be displayed in the list box - Done When user selects a item in the list box it will again displays in drop down list - done But when...