listfill range

Let's say I have a table like this, which is the data base And I inserted a list box from ActiveX controls where I want to set a table but only with A B and D columns. How can I do this? I'm not using user form

Hello everyone, Is there a way to populate an activeX combo box with a dynamic range (this means we can add and remove values) that is located in a different sheet, Also that the combo box is capable of refreshing automatically whenever we add or remove values and ignore blanks. If you could...

So i have multiple comboboxes in a worksheet. Is there a way i can fill all of them with the same listfillrange? The code for that for one combobox would be: Private Sub ComboBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean) Set col =...

HI I have added 2 combo boxes to a spreadsheet. The 1st is used to select a BU and the second is a dependant drop down for selecting a sub BU based on the BU chosen in combo box 1. I have used this sort of set up before and it has worked fine. However, ComboBox2 doesn't seem to display the...

I need help with a project, I have a Userform that I am using as an alternative to the Sort and Autosort options on a Worksheet. The reason I am using a UserForm is because the Worksheet needs to be protected from any unintentional removal of data. The UserForm has 8 option buttons, a Label for...