Linking Word Dropdown Boxes to Excel Ranges RRS feed

  • Question

  • Hi

    I have 3 dropdown boxes, lets call them DD1, DD2 and DD3.

    DD1 has its list items hard coded into the control. For example I have in there "Fruit", "Meat" and "Grain"

    Whatever is selected in DD1 determines the list that is populated in DD2 by the VBA code. So, if the user selects Fruit in DD1, then DD2 is populated with Apple, Banana, Orange

    If the user selects Apple for example, DD3 might be populated with Red and Green.

    This is all hard coded into the VBA module but I would rather pull the data from data ranges in Excel. How do I do this ?

    Monday, February 15, 2016 8:17 PM