+ Reply to Thread
Results 1 to 3 of 3

stop pressing F8 to refresh web page hand

  1. #1
    Forum Contributor
    Join Date
    06-22-2011
    Location
    somerset
    MS-Off Ver
    365
    Posts
    330

    stop pressing F8 to refresh web page hand

    so I am so used to F8ing through macros now that I have started hitting F8 instead of F5 to refresh pages by mistake. Pain in the ***!
    Sub Reputation()
    Dim Problem as Variant
    Dim Reputation as Integer
    For Each Problem in Forum.Threads
        If Problem.Title = "*[Solved]*" and Solver.Name = "Leon V (AW)" Then Reputation = Reputation + 1
    Next Problem
    End Sub

  2. #2
    Registered User
    Join Date
    02-27-2014
    Location
    Range("A1")
    MS-Off Ver
    Excel 2007
    Posts
    24

    Re: stop pressing F8 to refresh web page hand

    It really is, and btw I'd like to ask you... is it possible to use OnKey command in VBA and extend it to work OUTSIDE Excel?
    ZAX
    I'm glad you got it to work :-D
    ZAX

  3. #3
    Forum Contributor
    Join Date
    06-22-2011
    Location
    somerset
    MS-Off Ver
    365
    Posts
    330

    Re: stop pressing F8 to refresh web page hand

    Quote Originally Posted by DarthVader68 View Post
    It really is, and btw I'd like to ask you... is it possible to use OnKey command in VBA and extend it to work OUTSIDE Excel?
    ZAX
    VBA can do stuff outside of excel with shell comands which can be trigered by onkey but I don't think you can get the VBA to moniter key inputs when excel is not the active window. At least not with just VBA.

+ 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. Can I stop someone from stopping a macro by opening VBA and pressing reset?
    By Alves76 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-18-2013, 12:15 PM
  2. Replies: 1
    Last Post: 12-12-2012, 08:46 PM
  3. How can I stop QueryTable.Refresh ?
    By foxguy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-02-2009, 05:56 PM
  4. How to stop running the code when Pressing Backspace
    By LoveCandle in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-24-2009, 03:02 AM
  5. Replies: 4
    Last Post: 12-11-2007, 10:46 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