Automatical fill with double tap
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.
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....
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By chillern1 in forum Excel Formulas & Functions
Last Post: 03-14-2018, 09:59 AM
By JMGC in forum Excel Formulas & Functions
Last Post: 01-31-2013, 12:09 PM
By Dirk55 in forum Excel General
Last Post: 08-10-2011, 02:02 PM
By STarloff in forum Excel General
Last Post: 05-28-2010, 09:06 AM
By gvelix in forum Excel General
Last Post: 12-11-2009, 09:15 AM
By Elaine in forum Excel Formulas & Functions
Last Post: 07-13-2006, 12:50 PM
By Fred Smith in forum Excel Programming / VBA / Macros
Last Post: 05-10-2006, 11:40 PM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1