+ Reply to Thread
Results 1 to 2 of 2

Keyboard Shortcut to Toggle between Various Formats (e.g. font & fill color, numbering)

  1. #1
    Registered User
    Join Date
    09-01-2016
    Location
    Tennessee
    MS-Off Ver
    2013
    Posts
    4

    Keyboard Shortcut to Toggle between Various Formats (e.g. font & fill color, numbering)

    I am building some shortcuts into excel and am wondering how do I make a keyboard shortcut that can toggle between different formats. I would like to create several toggles highlighted below and hopefully more thereafter:

    - Toggle Between Colors with “Cntrl + Shift + C” (Blue, Green, Red)
    - Toggle Between Fill Color with “Cntrl + Shift + Y” (Yellow, Grey, Beige)
    - Toggle Between Number Formats with “Cntrl + Shift + N” (Number, Currency, Percent, Multiple(ie: 5.0x ) )

    Also, when I create my own keyboard shortcuts, I cannot press “Cntrl + Z” to undo them. Is there something I can do to the code to allow me to press “Cntrl + Z” to undo my keyboard macros. For example, assuming I can get the above to work, If I press “Cntrl + Shift + C” to get a black cell to turn blue, then I would like to be able to press “Cntrl + Z” to undo it back to black if necessary.

  2. #2
    Forum Contributor
    Join Date
    02-05-2015
    Location
    czech
    MS-Off Ver
    2010
    Posts
    172

    Re: Keyboard Shortcut to Toggle between Various Formats (e.g. font & fill color, numbering

    + means shift
    ^ means ctrl

    Please Login or Register  to view this content.
    Here is shown how you can do it. Maybe there are better ways. You can use UDT to group variables:

    Please Login or Register  to view this content.
    And then assign value like colors.blue = Value.
    Then in following code use
    Please Login or Register  to view this content.
    Last edited by jakopak; 03-06-2017 at 09:42 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. Replies: 3
    Last Post: 02-21-2014, 10:19 AM
  2. Replies: 4
    Last Post: 06-22-2013, 03:13 AM
  3. Font Size Keyboard Shortcut
    By brad78703 in forum Excel General
    Replies: 2
    Last Post: 11-16-2011, 12:24 PM
  4. Excel Font Size Keyboard Shortcut
    By brad78703 in forum Excel General
    Replies: 2
    Last Post: 01-26-2010, 06:10 PM
  5. Replies: 5
    Last Post: 07-27-2009, 03:46 AM
  6. Keyboard shortcut to change font size
    By JDDomine in forum Excel General
    Replies: 2
    Last Post: 07-10-2006, 03:09 PM
  7. [SOLVED] There should be a keyboard shortcut for fill color in excel
    By Jerry in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-23-2005, 11:05 AM
  8. what is keyboard shortcut to auto fill option
    By Rozeta in forum Excel General
    Replies: 3
    Last Post: 02-18-2005, 06: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