+ Reply to Thread
Results 1 to 3 of 3

Make button move when clicked

  1. #1
    Registered User
    Join Date
    02-26-2015
    Location
    Weymouth, Dorset
    MS-Off Ver
    2007
    Posts
    14

    Make button move when clicked

    I am sure that in the past I've seen a silly trick whereby a button "jumps" away from the cursor as soon as it's clicked, but I can't find the code for it. I'm working on a spreadpsheet at the moment, and would like to add this "silliness" to it as a bit of a joke for one particular user. Does anyone have any idea where I can find the code? Many thanks.

  2. #2
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: Make button move when clicked

    Here is one example.
    Attached Files Attached Files
    Gary's Student

  3. #3
    Registered User
    Join Date
    02-26-2015
    Location
    Weymouth, Dorset
    MS-Off Ver
    2007
    Posts
    14

    Re: Make button move when clicked

    Thanks Jakobshavn, that was exactly what I wanted.

+ 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 make a non-macro button/checkbox that when clicked will copy value out of that cell
    By ladydubs in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-20-2013, 12:44 PM
  2. [SOLVED] UserForm Command Button - how to make it change appearance when clicked
    By schmidt62 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-12-2012, 10:53 AM
  3. VBA to automatically move command button to another cell after being clicked on
    By vaznlyfe in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-23-2012, 11:29 AM
  4. Make clicked button go bold and other choices go gray
    By szfoster in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-20-2009, 03:41 PM
  5. [SOLVED] How to make created button move with scrollbar?
    By Bon in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-12-2005, 11:40 PM

Tags for this Thread

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