Aug 04, 2014 · Hello, I am having a problem looping through the values selected from an ActiveX ListBox. Ideally, the user selects values from a ListBox, and for every selected value, the macro runs another macro. Add a list box to your Excel worksheet from which users can choose a value. Make data entry easier by letting users choose a value from a combo box. A combo box combines a text box with a list box to create a drop-down list. You can add a Form Control or an ActiveX Control combo box.
Re: Popluate Listbox with Visible Range. update: extra information... z equals 1892 when i run the code. Also, i discovered that the 5th row in the data table is also the 1st row that is filtered out, which is also where the listbox ends, which is why i only see 4 rows of data on the listBox.