+ Reply to Thread
Results 1 to 2 of 2

How to customize hotkey(not just using Ctrl + letter combination) to trigger macro ?

  1. #1
    Forum Contributor
    Join Date
    08-01-2016
    Location
    China, beijing
    MS-Off Ver
    2016
    Posts
    114

    How to customize hotkey(not just using Ctrl + letter combination) to trigger macro ?

    I know that I can use ctrl + letter combination to trigger a hotkey , I get so many hotkey now and the ctrl + lettter can meet my requirement I need more how to make that?

  2. #2
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: How to customize hotkey(not just using Ctrl + letter combination) to trigger macro ?

    I don't know of a way to extend the possible hotkeys, but perhaps you could build a simple userform that lists and runs your macros in a friendlier way than the Macro Dialog box. Call THAT from the quick-access tool bar so you can free up some of those hotkeys.
    Last edited by leelnich; 05-26-2017 at 02:34 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Event trigger to open file after Ctrl+C keyboard action.
    By delaing in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 09-09-2015, 02:28 PM
  2. [SOLVED] how to do ctrl + arrow key trigger function
    By fight2 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-29-2015, 04:03 AM
  3. Hotkey while using form without ctrl
    By andrew c. in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 06-20-2011, 11:36 AM
  4. Macro hotkey without CTRL?
    By blandow in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-14-2010, 08:12 AM
  5. [SOLVED] select [a1]cell when hotkey(ctrl+q) pressed, after userform load
    By x taol in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-27-2006, 06:10 PM
  6. Replies: 1
    Last Post: 11-11-2005, 05:10 PM
  7. [SOLVED] Ctrl-Shift-Arrow combination does not work
    By ch in forum Excel General
    Replies: 1
    Last Post: 09-28-2005, 10:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1