Add field based on excel data with keyboard shortcut

macropod · #1 01-10-2017, 02:21 PM

Try the attached template. When you create a new document from it, two content controls are created and the first, a dropdown, is populated from the Excel workbook. To add more content control pairs (after making a selection from the first content control, thereby deleting the first pair), all you need do is run the AddControls macro.

Guimenez · #2 01-11-2017, 01:19 AM

Quote:

Originally Posted by macropod

Try the attached template. When you create a new document from it, two content controls are created and the first, a dropdown, is populated from the Excel workbook. To add more content control pairs (after making a selection from the first content control, thereby deleting the first pair), all you need do is run the AddControls macro.

Hi,
the first time i open the document i can choose the a name and it will put the number(perfect), but after pressing F8(the shortcut i made for insert the new dropdown), it insert the dropdown but without names and then gives me the error attached

One again thank you for trying to help me

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Changing keyboard layout - Changing/removing keyboard shortcut	Hans L	Windows	2	08-16-2015 05:33 PM
keyboard shortcut	ilor	OneNote	1	11-13-2014 02:48 PM
disable ctrl+space excel keyboard shortcut	melvinjn	Excel	2	11-27-2013 04:11 AM
Keyboard shortcut for bookmarks	Jennifer Murphy	Word VBA	1	01-06-2013 07:38 PM
Outlook Keyboard shortcut	sostrow28	Outlook	1	12-10-2010 05:57 AM