+ Reply to Thread
Results 1 to 2 of 2

Task Tracker_Copy & Paste the selected Process in Excel

  1. #1
    Registered User
    Join Date
    03-01-2017
    Location
    Manila, Philippines
    MS-Off Ver
    MS Office 2007
    Posts
    77

    Task Tracker_Copy & Paste the selected Process in Excel

    Hi excelforum experts,

    I tried creating a task tracker to monitor the time spent on each workout using Userform but I am having a hard time incorporating additional macro codes to do the following procedures:

    1.) After clicking the "Start" button, the userform named "Select Process" will appear. (Have already assigned codes for this.)
    2.) I have to select a process from the dropdown list and a sub-process subsequently then click "OK" button to start the process. (I hope I can incorporate the vbCritical function if no data selected from either process and sub-process category. Please help me on this part).
    3.) After clicking the "OK" button, the selected process and sub-process should be pasted on the "Process" and "Sub-Process" column in the attached workbook respectively. It's in the cell "A6" and "B6".
    4.) The time on the "Start Timer" column should also be running at this point until I clicked the "End" button which will automatically stop the time running on the "End Timer" column.
    5.) The same process will apply until I have a full records of all the activities and the time spent I made.

    My main concern here is the pasting of the selected activity from the userform and the running time for it. I am wondering if there could be someone with brilliant mind that could help me with this.

    Have attached the spreadsheet that I am working on for your reference. Please let me know if you need additional details or clarifications. Thanks a lot!

    Note: Please disregard the data validation in cell "A6 to B81". I'll be deleting those data validations once finalized.

    Best regards,
    Arnel
    Attached Files Attached Files
    Last edited by arnel_10; 09-25-2018 at 07:20 PM. Reason: Additional details have included.

  2. #2
    Registered User
    Join Date
    03-01-2017
    Location
    Manila, Philippines
    MS-Off Ver
    MS Office 2007
    Posts
    77

    Re: Task Tracker_Copy & Paste the selected Process in Excel

    Note: Have also posted the same thread to another forum but I haven't heard from them yet. Here's the link: http://www.excelfox.com/forum/showth...0793#post10793

+ 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. Replies: 0
    Last Post: 11-26-2015, 05:14 AM
  2. [SOLVED] excel cannot complete this task when paste values from temp sheet
    By squarahollier in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-09-2014, 09:10 AM
  3. Automating a Person-To-Task Distribution Process using Excel.
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-21-2011, 09:44 AM
  4. VBA in Word opens, closes Excel app but process still running in Task Manager
    By 6StringJazzer in forum Excel Programming / VBA / Macros
    Replies: 32
    Last Post: 02-16-2011, 09:10 AM
  5. Printing leaves EXCEL.EXE process in Task Manager
    By eeidfn in forum Excel General
    Replies: 1
    Last Post: 02-27-2006, 10:30 PM
  6. How to process selected rows
    By Ron in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-03-2005, 07: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