+ Reply to Thread
Results 1 to 4 of 4

Macro Shortcut keys

  1. #1
    Registered User
    Join Date
    04-03-2020
    Location
    North East, England
    MS-Off Ver
    Windows 10
    Posts
    2

    Angry Macro Shortcut keys

    Hi

    First time posting and I'm a novice when it comes to Macros, I'm currently in the middle of an excel advanced course and the only thing I'm currently struggling with it Macros!

    When running a macro I'm adding a shortcut key just for basic formatting and it isn't working, eg. the shortcut key is :ctrl f and as said its just a basic format of a title, when I try to use the format on another part of the excel spreadsheet it either does nothing and just jumps to the original heading or it copies the heading but not with all the formatting applied.

    Hope this makes sense and hope someone can help as I've now spent two days trying to work this out!

    TIA

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Macro Shortcut keys

    Welcome to the forum

    Can you post you code? Please take note of my signature block below about the use of CODE tags around your code. It's a forum rule.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,286

    Re: Macro Shortcut keys

    Isn't Ctrl F a standard keyboard shortcut for "Find" or "Search" ?? Would that be the issue?

  4. #4
    Registered User
    Join Date
    04-03-2020
    Location
    North East, England
    MS-Off Ver
    Windows 10
    Posts
    2

    Re: Macro Shortcut keys

    Guys, thanks I've actually managed it, just not sure how! but this time its worked. No doubt I'll be back with more questions before lockdown is over!

+ 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] How to remove function keys as shortcut using macro
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-11-2018, 09:11 AM
  2. How to assign different shortcut keys to a Macro , different sheets
    By Rajbhar in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-11-2012, 10:37 PM
  3. creating macro with mutliple shortcut keys
    By kmfdm515 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-12-2011, 07:44 AM
  4. Macro Not Running Via Shortcut Keys
    By ashleyhkim in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-10-2010, 09:50 PM
  5. [SOLVED] List of macro shortcut keys
    By Zone in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-15-2006, 10:25 AM
  6. macro shortcut keys don't work
    By andr01d in forum Excel General
    Replies: 1
    Last Post: 02-03-2006, 01:45 PM
  7. [SOLVED] Macro Shortcut Keys
    By Nicolle K. in forum Excel General
    Replies: 1
    Last Post: 01-06-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