-2

I have created a drop-down menu and am trying to use VBA so that when certain menu items are selected, empty rows with populate beneath the menu item. The number of empty rows will be dependent on the menu item chosen.

Thanks for the help!

sabs
  • 35
  • 7
  • 4
    Welcome to SO! What have you tried so far? We're much more here to help with specific questions of the form "I tried X, but it did not do what I expect and instead resulted in an error!" accompanied by a [Minimal, Complete, and Verifiable example](https://stackoverflow.com/help/mcve) – ti7 Aug 09 '18 at 13:28

1 Answers1

0

Try use "change" activeX event, which can be added to your sheet code where your comboBox are in.

i.e:

Sheet Event

Something like this:

Private Sub comboBoxName_change()

    Select case comboBoxName.list(comboBoxName.listIndex)

    case "a"
    'your code to populate rows

    case "b"
    'your code to populate rows

    case "c"
    'your code to populate rows

    case [...]

    end Select

end sub
Kauê Delmonte
  • 38
  • 7