Results 1 to 2 of 2

Thread: How to Make EXCEL VBA F1 Helper Respond to F1 Keypress in EXCEL?

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Sep 2014
    Posts
    341

    How to Make EXCEL VBA F1 Helper Respond to F1 Keypress in EXCEL?

    I mean, there are two Helper in Excel, right?

    One I can call in the "table" interface and the other, in the VBA interface? And if I press F1 in the "tables", then the Helper for EXCEL pops up; while in VBA, the Helper for EXCEL VBA Helper pops up.

    How can I set the EXCEL VBA Helper as the DEFAULT Helper that pops up wherever I am editting?

  2. #2
    Fanatic Member
    Join Date
    Feb 2013
    Posts
    985

    Re: How to Make EXCEL VBA F1 Helper Respond to F1 Keypress in EXCEL?

    how exactly do you expect this to work, the VBE and Excel are completely seperate programs each one with its own helper, would you expect your windows helper to know about Excel? or any other program.

    im guessing you can control the VBE helper using the VBA Object model once its enabled in excel and maybe be able to pass some argument to it but i wouldnt expect it to present you with the correct materials.
    Yes!!!
    Working from home is so much better than working in an office...
    Nothing can beat the combined stress of getting your work done on time whilst
    1. one toddler keeps pressing your AVR's power button
    2. one baby keeps crying for milk
    3. one child keeps running in and out of the house screaming and shouting
    4. one wife keeps nagging you to stop playing on the pc and do some real work.. house chores
    5. working at 1 O'clock in the morning because nobody is awake at that time
    6. being grossly underpaid for all your hard work


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width