Add field based on excel data with keyboard shortcut

macropod · #1 01-11-2017, 01:57 AM

To add more content control pairs, all you need do is run the AddControls macro - you don't need yet another macro to run that!!!

As for assigning a shortcut to the macro, see the first link in post #3 in this thread . However, I would recommend against trying to assign any pre-assigned Word shortcut keys, such as F8. Doing so can have unpredictable and undesirable effects.

To see what the pre-assigned Word shortcut keys are, visit: https://support.office.com/en-us/art...2-f762f663ceb2

Guimenez · #2 01-11-2017, 04:13 AM

Quote:

Originally Posted by macropod

To add more content control pairs, all you need do is run the AddControls macro - you don't need yet another macro to run that!!!

As for assigning a shortcut to the macro, see the first link in post #3 in this thread . However, I would recommend against trying to assign any pre-assigned Word shortcut keys, such as F8. Doing so can have unpredictable and undesirable effects.

To see what the pre-assigned Word shortcut keys are, visit: https://support.office.com/en-us/art...2-f762f663ceb2

In Excel if i put a name without number, when inserting the dropdown it fails with an error.

Is it possible if the name doesn't have number(columm B), it only fills the name?
Thank you

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