User makes the following selections (on either a user form, or the top portion of a template):Ī.Ĝase Type DropDown List – source for list items is Column 1 of Table 1ī. Table 4 – Column 1 “Injury Item” Column 2 “Injury Item Text”Ģ. Table 3 – Column 1 “Special Responses” Column 2 “Special Response Text”ĭ. Table 2 – Column 1 “Standard Responses” Column 2 “Standard Response Text”Ĭ.
I suspect that, given what I need in 2c(ii) below, this may not be the proper/ideal way to structure this – for example, perhaps each Case Type should have its own table, with a row for each Special Response available for that Case Type.)ī. Table 1 – Column 1 “Case Types” Column 2 “Special Responses” (Each Case Type in Column 1 has one or more Special Responses in Column 2, separated by commas. One issue is that, although I’ve been able to follow the instructions of some of the experts here on creating cascading drop down lists, I’ve only been able to do that with the “slave” list items hard coded in the VBA, and I want to have all list items pulled from an external source document.ġ.Ě source document containing the following (it’s easiest for me to see it as tables, but I understand that it may not be ideal or possible to do it all that way):Ī. I’ve searched for and read many forum posts on cascading/dependent drop down lists, data mapping, etc., and I’m beginning to get in over my head – Dims and Strings and what-not.
Word 2016 for mac dropdown box windows#
I think it would be best to start from scratch for several reasons, especially because with Word 2016 for Windows I can now use content controls (which I’ve never used before). But the end users use Windows, so I’ve migrated it (to Word 2016 for Windows), and have had problems making it work. I did it using a combination of bookmarks, AUTOTEXTLIST, IF, and INCLUDETEXT formulas, and had it working almost perfectly (I didn’t have to use any VBA – my experience with VBA is limited). I did it as a template (actually two templates, one pulling from the other) in Word 2011 for Mac, because that’s what I use. I need to create the template or userform experience described below.
I apologize in advance for this long/detailed post.