+ Reply to Thread
Results 1 to 2 of 2

Possibility to use picture as control or click a button without macro

  1. #1
    Registered User
    Join Date
    04-10-2015
    Location
    Istanbul
    MS-Off Ver
    Office 2013
    Posts
    5

    Possibility to use picture as control or click a button without macro

    My issue is a bit complicated because I was investigating if it is possible to create a custom spin button.

    The spin button increases and decreases to value and does nothing else.
    You will see my screenshot that there is minus and plus sign (2 separate pictures) and the actual button which works perfectly.

    What I am trying to do is : when - (minus) clicked the number must be decreased, and plus increases the value on d4
    Attached Images Attached Images

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Possibility to use picture as control or click a button without macro

    These two macros can be attached to your custom shapes to give the behavior you want of -1 and +1:
    Please Login or Register  to view this content.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

+ 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] Insert Picture in cell, click commanbutton to rename picture, lock cell and remove button
    By thecdnmole in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-28-2014, 10:05 PM
  2. Simple form control Macro to sort row or rows on button click?
    By ElmerFud in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-29-2014, 02:06 PM
  3. Click on picture and run macro to replace existing picture with selected picture file
    By houseflipsheet in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-14-2014, 12:02 AM
  4. Hide a picture button placed in all sheets using a option button (form control)
    By lagaranch in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-26-2012, 10:33 AM
  5. To have the picture to appear when click on a button or cell
    By Grace14 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-20-2012, 05:07 AM

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