Greetings!

I have an excel spreadsheet that has two worksheets. The first worksheet ("Sheet1") has two list boxes (ListBox10 and ListBox11). The first list box has 7 rows, each containing a region name/number (e.g. 03- WEST, 07- EAST, 02 -CENTRAL, etc). The second list box is blank. I would like to populate the second list box (ListBox11 based on what is selected in ListBox10). The information that needs to be populated comes from the second worksheet ("Data"). "Data" has 7 columns, each with a top row that corresponds to the region in Listbox10 and the corresponding districts are listed below. An example would be region 03 has 5 districts (03,05,11, 15,22). If the user selects Region 03 in the first list box, then I want the second box to list 03,05,11 and so on.

I am wanting to do this using VBA in excel but have no idea where to start.

**Important Notice**

We will be implementing some important changes during 25th and 26th May 2024 which may result in an outage period of the website. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!