Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-11-2017, 01:57 AM
macropod's Avatar
macropod macropod is offline Add field based on excel data with keyboard shortcut Windows 7 64bit Add field based on excel data with keyboard shortcut Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 01-11-2017, 04:13 AM
Guimenez Guimenez is offline Add field based on excel data with keyboard shortcut Windows 10 Add field based on excel data with keyboard shortcut Office 2013
Advanced Beginner
Add field based on excel data with keyboard shortcut
 
Join Date: Jan 2017
Posts: 33
Guimenez is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
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
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Add field based on excel data with keyboard shortcut 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
Add field based on excel data with keyboard shortcut 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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:11 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft