View Single Post
 
Old 02-15-2016, 03:19 AM
music_al music_al is offline Windows 10 Office 2013
Novice
 
Join Date: Nov 2015
Posts: 10
music_al is on a distinguished road
Default Linking WORD Cascading Dropdown Boxes to Excel

Hi

I have 3 drop down boxes on a Word form. Lets call them DD1, DD2 and DD3

The selection of DD1 determines the List Items in DD2 and the selection of DD2 determines the List Items of DD3.

At the moment this is hard coded into a Word module but I would prefer to use ranges of cells in Excel that can be maintained by the users.

I was thinking of having a Worksheet for each list and the Worksheet name be the same as the item selected.

So, if someone selects "Fresh Fruit" from DD1, this would populate DD2 with the list that is in the Worksheet called "Fresh Fruit".

If someone then selects "Variety of Apples" from DD2 (the "Fresh Fruit" list), this would would then populate DD3 with the list in the "Variety of Apples" Worksheet.

I know how to use RowCount and loop functions to use the 'ListEntries.Add' function, but I'm just not sure how to reference the Excel Workbook in the first place. I don't want the Workbook to open, just to be referenced.

Any help would be appreciated.
Reply With Quote