+ Reply to Thread
Results 1 to 2 of 2

Automatical fill with double tap

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Office 365

    Automatical fill with double tap

    Hi there,

    I've tried the generic "weekly chore schedule" from Excel which have some great ideas and functions. They for example have tooltips which i figured out how to do, but they also have some sort of function to fill a cell with "Done" and a check icon and back to void if double tapped again. This is a really great thing that I'd love to understand how to do by myself but I couldn't find a solution yet.
    There is thee conditional formatting option and icon set for the one part, but I'm open to suggestions for the rest.

    If you could enlighten me on this I'd be very thankful.

    Attached Files Attached Files

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    East Sussex, UK
    MS-Off Ver

    Re: Automatical fill with double tap

    The double click do and undo is controlled by VBA. Right click on the sheet tab and select "View Code" and you'll see how it's done.
    Feel free to ask specific questions from there if it makes no sense.

    Worth pointing out that if you ask for specific solutions on the forum then the responses you will get may be dependent on the location you're showing, as regional differences in Office setups will affect formulas etc.
    "Blockchain" is not particularly helpful....


+ 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. Automatical Formula
    By chillern1 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-14-2018, 09:59 AM
  2. Fill column with double week day dates
    By JMGC in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-31-2013, 12:09 PM
  3. Replies: 3
    Last Post: 08-10-2011, 02:02 PM
  4. Double Clicking Fill Handle yields no result
    By STarloff in forum Excel General
    Replies: 4
    Last Post: 05-28-2010, 09:06 AM
  5. Double lookup to fill an array
    By gvelix in forum Excel General
    Replies: 3
    Last Post: 12-11-2009, 09:15 AM
  6. How do I get ONLY new info from 1 Worksheet to another automatical
    By Elaine in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-13-2006, 12:50 PM
  7. How to program double click of fill handle
    By Fred Smith in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-10-2006, 11:40 PM


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