listbox populate

Hello, I've been struggling with this problem for nearly a week and any help would be fantastic. I have a data source with a large number of columns: <tbody> Ref No Date other1 other2 other3 4 5 6 7 8 9 Scheduled Sent timestamp 000 11/03/17 yes yes 1344 001...

How to set up ColumnHeads Names into ListBox? col_numA = 11 db_x = .Cells(.Rows.Count, "B").End(xlUp).Row NameArray = ws.Range("A8:K" & db_x) With lbsourceList .ColumnCount = col_numA .ColumnHeads = True .ColumnWidths = 100 .List = NameArray .ColumnWidths = "80;200;40;30;30;30;30;30;30;30;30"...

Hi all Can anybody please give me a slap to wake up my brain I have a userform with a drop down menu(cboCOW) (the drop down menu is to filter data on a workdheet - Sheets("VMC"). Once the data is filtered I need it to populate a Listbox ("lstBxCOW") showing only the filtered data. The listbox...

Hey all, First post, hoping someone can help! I've been going at this for a while now: My original goal was to create a dropdown multi-select listbox with check boxes. I have about 20 selections going into the list box and didn't want to see the selections until I selected the cell and dropped...

Hi guys, hope someone can help! I have a workbook with 2 worksheets "front" and "data". The "data" worksheet contains 3 columns: Name; Status; and Description. The values may appear in Name and Status several times, but Description will always be unique. On the "front" worksheet, I need some...

I have two listboxes on a worksheet and using VBA to load values into the listbox. I also have a combobox that is used to determine what values are to be displayed in the listboxes. I select a value from the dropdown list and depending on the value selected, a list gets populated in the...

I have an Active-X listbox on a worksheet with properties set a multi and option. The problem is that when I fill the listbox with data, I can't access the last item in the listbox. The right scroll bar won't let me scroll down to look at the last item. Of course I can expand the height of...

I have created a workbook with a lot of userforms which is going to be used to collect answers about software configuration from my company's customers. I use multiple list boxes and comboboxes on each userform. Yesterday, I was working on one of the userforms and I ran it to see if something...