+ Reply to Thread
Results 1 to 2 of 2

Need help with binding a macro to a shortcut key combnation

  1. #1
    Registered User
    Join Date
    04-14-2019
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    1

    Need help with binding a macro to a shortcut key combnation

    Hi,

    I'm relatively new to Excel and am doing a Spreadsheet assignment as part of an engineering course I'm doing.
    I created a macro with the following coding:

    Please Login or Register  to view this content.
    This works fine.
    My problem is I can't bind it to a shortcut key (which is a criteria for the Spreadsheets unit).
    I've put the following coding into a separate module of the macro:

    Please Login or Register  to view this content.
    Whenever I press +^(c) nothing happens. I've tried multiple variations, and have looked up other methods online but I cannot work out why its not working.
    Does anyone have any suggestions of what I'm doing wrong in terms of the coding any place? Have I misunderstood what I'm doing?
    Thanks in advance.

    fable.
    Last edited by jeffreybrown; 04-14-2019 at 08:22 PM. Reason: Please use code tags!

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,327

    Re: Need help with binding a macro to a shortcut key combnation

    Hi Fable,

    How about setting the shortcut key via >> Alt + F8 >> Highlight CreateShortcut >> select Options

    Edit: should you macro be... “+^{C}”
    Last edited by jeffreybrown; 04-14-2019 at 08:32 PM.
    HTH
    Regards, Jeff

+ 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. [SOLVED] What are early binding and late binding?
    By HerryMarkowitz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-14-2015, 02:33 AM
  2. [SOLVED] Adjust a "Copy specific data to MS word" macro with late binding
    By dreddster in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-24-2015, 03:27 AM
  3. [SOLVED] Learning differences between Early Binding & Late Binding
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 06-28-2013, 01:16 AM
  4. [SOLVED] Seeking knowledge on Early Binding, Late Binding
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-17-2013, 10:45 PM
  5. Conversion from early binding to late binding
    By bettingman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-10-2011, 04:10 AM
  6. [SOLVED] Email Macro Late Binding
    By Jan Holmstrom in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-08-2005, 03:05 PM
  7. Late Binding examples of binding excel application
    By HeatherO in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 03-17-2005, 01:06 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