'Excel When Drop down box selected auto fill other boxes

I have an excel spreadsheet that has drop down comboboxes on sheet 1. I am trying to find out how to autofill the 5 boxes to the left of the combobox with content from sheet 2 when a specific drop down is selected.

Solution 1:^[1]

Try to use VBA. Where you first put value from sheet 2:

With Sheet2.ComboBox1
    .AddItem A1
    .AddItem A2
    .AddItem A3
End With

And then you set ListFillRange in sheet 1: A1, A2, A3

Here is some example: link

Solution 2:^[2]

You can do this with out a macro, just select the form element, click the developer tab and then click properties. Then select Control in the form that appears.:

enter image description here

This results in:

enter image description here

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	geekforfreek
Solution 2	Ole Henrik Skogstrøm

'Excel When Drop down box selected auto fill other boxes

Solution 1:[1]

Solution 2:[2]

Sources

Related Questions

Solution 1:^[1]

Solution 2:^[2]