dynamic listbox

  1. R

    Extract a dynamic list from a range in Excel based on specific criteria

    I want to extract serial numbers(Column A) from a range of data based on the value of column P (Release status). So, if the status is pending I want to add the serial number in my list. In the end I want to show this dynamic list in a listbox in userform, where he will be able to further...
  2. N

    Form Control List Boxes Cascading - Errors 424 and 1004

    Hello, I've got a problem with some cascading list boxes and a single drop down. There are 4 list boxes and 1 drop down and a user selects options from each of them to make a configuration. They are embedded in the worksheet "Instructions" (not a Userform). I encounter an object required error...
  3. A

    combobox populated with dates

    Is there a way to populate a userform combobox with the dates within a month or a date range? Example1: user wants a list of all the dates in the month of February 2012. Combobox would be filled with the date range 2/1/12 - 2/29/12, one list item for each day. Example2: user wants a list of...
  4. D

    Dynamic Listbox?

    I have a ListBox that references a list on SheetA1:A10. As I add data from A11....Axx, I would like the ListBox to grow and have the [new] data included in the ListBox. Something to do with changing the .RowSource property in VBA?
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top