Consulting

Results 1 to 3 of 3

Thread: Solved: Toolbar/CommandButton - OnAction

  1. #1
    VBAX Tutor Philcjr's Avatar
    Joined
    Jul 2005
    Location
    Bedminster, NJ
    Posts
    208
    Location

    Solved: Toolbar/CommandButton - OnAction

    For "OnAction", with CommandButtons do you have to use a macro name?

    I would like to be able to add a button for going to Top of Sheet in Col A... I was thinking something along the lines of OnKey "^{HOME}"

    I would like to be able to add a button for going to LastRow of Sheet in Col A... I was thinking something along the lines of OnKey "^+{DOWN}"

    Creating seperate macros I can do, I was just wondering if the "OnAction" could be used differently to simulate key strokes

    Any thoughts?
    Phil

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    It has to be a macro, so just create a macro to do those things.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    VBAX Tutor Philcjr's Avatar
    Joined
    Jul 2005
    Location
    Bedminster, NJ
    Posts
    208
    Location
    Thanks XLD

Posting Permissions

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