+ Reply to Thread
Results 1 to 11 of 11

E checklist

  1. #1
    Forum Contributor
    Join Date
    11-16-2014
    Location
    United States
    MS-Off Ver
    2010
    Posts
    204

    E checklist

    Hi Champs,

    I have a checklist with

    Task
    Frequency
    dates of particular month (from Column C)


    I need help for the following criteria
    • is there any function that if a user can tick or cross mark and ? mark for task listed.
    • also if user open this file,,,, he should be able to see only todays date list and yesterday date list.
    • Weekly view of task list performed (old dates)
    • Monthly view of task list performed
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: E checklist

    To show only today and yesterday

    Please Login or Register  to view this content.
    Call userform by select a task in column A

    Please Login or Register  to view this content.
    load the listbox in userform

    Please Login or Register  to view this content.
    Kind regards
    Leo
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    11-16-2014
    Location
    United States
    MS-Off Ver
    2010
    Posts
    204

    Re: E checklist

    Hi Leo ,

    Thanks for the code ..but can u help me further for the following
    • todays task and yesterdays task is displayed and others are hided... is there any function to protect the hide columns or to make unhide false.
    • is there any function that if a user can tick or cross mark and ? mark for task
    • Weekly view of task list performed (old dates)
    • Monthly view of task list performed

  4. #4
    Forum Contributor
    Join Date
    11-16-2014
    Location
    United States
    MS-Off Ver
    2010
    Posts
    204

    Re: E checklist

    HI Leo,

    I found code to unhide disable
    Please Login or Register  to view this content.

    can u pls help me on others as mentioned
    Last edited by alansidman; 11-16-2016 at 11:46 PM. Reason: code tags added

  5. #5
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: E checklist

    Select a task in column A
    and see result coming in userform
    i ame not sure if this is the info you want, if not i need more info



    Kind regards
    Leo
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    11-16-2014
    Location
    United States
    MS-Off Ver
    2010
    Posts
    204

    Re: E checklist

    Hi Leo, I need to enter tick mark or cross mark in task list cell of today ...under today or yesterday date

  7. #7
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: E checklist

    can you post a file with result for both enters ? (tick and cross)

    kind regards
    Leo

  8. #8
    Forum Contributor
    Join Date
    11-16-2014
    Location
    United States
    MS-Off Ver
    2010
    Posts
    204

    Re: E checklist

    Attachment 489655


    need to input tick, cross for not cpompleted and any other for NA option

  9. #9
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: E checklist

    Invalid Attachment


    cheers
    Leo

  10. #10
    Forum Contributor
    Join Date
    11-16-2014
    Location
    United States
    MS-Off Ver
    2010
    Posts
    204

    Re: E checklist

    Hi leo, In the same file u provided under the date column of today, 17/nov... is it possible to enter tick or cross mark for task and today task to be shown in form?

  11. #11
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: E checklist

    can you post a file with result for both enters ? (tick and cross)

    also mention where the tick or cross has to be entered ?

    kind regards
    Leo

+ 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. Checklist Formula Help
    By jamaral141989 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-15-2013, 03:14 PM
  2. [SOLVED] need help in preparing a checklist
    By sbehera in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-30-2013, 02:34 PM
  3. Checklist
    By faizmalik in forum Excel General
    Replies: 3
    Last Post: 01-19-2013, 12:45 PM
  4. Checklist with comments
    By epoch555 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-01-2012, 01:28 PM
  5. Checklist on Each Row
    By HHMacGuffin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-18-2011, 05:30 AM
  6. Excel Checklist
    By Ada01 in forum Excel General
    Replies: 4
    Last Post: 11-23-2009, 11:45 AM
  7. Checklist
    By guy in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-28-2005, 01:10 PM
  8. Checklist
    By guy in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 12-26-2005, 04:20 PM

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