+ Reply to Thread
Results 1 to 4 of 4

Create a slide oval slider form control

  1. #1
    Forum Contributor
    Join Date
    10-03-2012
    Location
    USA
    MS-Off Ver
    2010
    Posts
    496

    Create a slide oval slider form control

    Hello,
    Slider.jpg
    I am looking for a special form control that is a slider in green oval shape with a white round circle to have have
    a "True" or "False". When the circle slide to the right, a green background will reveal in the oval slot and a link cell
    will insert the word "True". If the circle slide to the left, when slot will be in white, same linked cell will
    change to "False".

    Is that possible? I do not want to use standard option button to toggle True and False.


    Thanks
    Last edited by Rocky2013; 05-18-2017 at 01:05 PM.

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Create a slide oval slider form control

    http://chandoo.org/wp/2013/12/05/on-...-in-excel-vba/
    with video and everything

    just need to amend the shading of the oval background as well in your case
    Last edited by humdingaling; 05-17-2017 at 10:46 PM.
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Contributor
    Join Date
    10-03-2012
    Location
    USA
    MS-Off Ver
    2010
    Posts
    496

    Re: Create a slide oval slider form control

    Tanks a lot. I change the shape color, it works so I request.

    I love to see more form control shapes, than the standard.

  4. #4
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Create a slide oval slider form control

    would of thought someone would of done a custom object by now which is why i started googling it
    seems to be common in the javascript side of the world

    I'm sure if someone gets "intrigued" enough to make one and wants to share with the world it will pop up (ill imagine the later is probably is what stopping it being wildly available)

+ 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. Slider Form Control Compatibility Issue 2007 - 2013
    By pacoppen in forum Excel General
    Replies: 0
    Last Post: 03-02-2015, 10:02 AM
  2. Slider Bar Control
    By lulupatel in forum Excel General
    Replies: 0
    Last Post: 03-02-2015, 03:19 AM
  3. Replies: 1
    Last Post: 04-02-2012, 03:57 PM
  4. 3 slider control for a Gantt Chart
    By Perception in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-07-2011, 09:02 AM
  5. How do I create a slider bar in Excel to control data input?
    By P-15 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-26-2009, 04:05 PM
  6. Listbox Slider control
    By MikeM in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-18-2005, 03:05 PM
  7. Slider control limitations
    By spIky haIred in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-25-2005, 03:05 AM

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