+ Reply to Thread
Results 1 to 5 of 5

function keys F5 and F8 not working in excel vba macro

  1. #1
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Jacksonville, Florida
    MS-Off Ver
    Excel 2016
    Posts
    313

    function keys F5 and F8 not working in excel vba macro

    I have a new laptop and when I try to debug a macro and use the F8 key to single step thru nothing happens in the macro. A panel pops up to the right of the screen entitled "Project" with these options: PC Screen only, Duplicate, Extend and Second Screen Only. I can select "Debug" and "Step Into" but I have to hit both each time I want to step to next line of code. Pressing the F5 key doesn't cause any action to occur. Does anyone know a solution?

    Thanks for any help.

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Arrow


    The easy & obvious solution is to just read your laptop manual as by default its keyboard not returns functions keys
    but special system keys so I guess you should combinate with a prefix key …

  3. #3
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Jacksonville, Florida
    MS-Off Ver
    Excel 2016
    Posts
    313

    Re: function keys F5 and F8 not working in excel vba macro

    Thanks for your reply - I am reading the manual and have not been able to find a solution. Could you explain more on how to combinate with a prefix key. I'm not familiar with that.

  4. #4
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,481

    Re: function keys F5 and F8 not working in excel vba macro

    Google your LapTop company and search for how to access your function keys.

    Some laptops have a" fn" key at the bottom. Which would have to be pressed with the function keys.

    If I'm doing a lot of work on a LapTop, I will just hook up a regular keyboard to it.

  5. #5
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Jacksonville, Florida
    MS-Off Ver
    Excel 2016
    Posts
    313

    Re: function keys F5 and F8 not working in excel vba macro

    Thanks davesexcel - I used the fn key with the f5 and f8 and that worked perfectly. Thanks so much!! I also will use a separate keyboard when I use this laptop as it seems so much easier than using the laptop keyboard.


    Thanks again for the excellent response.

+ 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. [SOLVED] Macro to write dictionary keys to array not working
    By capson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-07-2015, 05:21 PM
  3. Keyboard keys are not working after running macro
    By excelliot in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-24-2014, 12:05 PM
  4. Arrow keys not working Excel 2007 all spreadsheets
    By karend1840 in forum Excel General
    Replies: 3
    Last Post: 12-11-2013, 04:42 PM
  5. [SOLVED] How to use Alt keys + symbol keys to invoke a macro?
    By keithb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-19-2005, 05:00 PM
  6. Function Keys in Excel
    By LPS in forum Excel General
    Replies: 2
    Last Post: 01-28-2005, 09:06 PM
  7. Enter Keys Stopped Working Only In Excel
    By Kiniski in forum Excel General
    Replies: 1
    Last Post: 01-06-2005, 11:47 AM

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