LumberJocks

Making A time tracking application with excel

  • Advertise with us
Blog series by ScottM1 updated 11-03-2016 05:38 PM 6 parts 6498 reads 2 comments total

Part 1: Setting up the workbook and adding the userform

07-18-2016 05:25 PM by ScottM1 | 0 comments »

Making A time tracking application with excel.Part1In my previous post, I gave you guys a workbook that I started on. In the intro video, I asked for any suggestions and/ or feedback. One suggestion was to make it look and act like an actual application. So I am starting a completely new program. You can download the workbook here. Then click on the video link and follow along. Please let me know what you think.

Read this entry »


Part 2: Scott's Time tracker part2

07-28-2016 12:53 PM by ScottM1 | 2 comments »

Making a time tracking application in excel part2 Follow along with me and learn how you can make a time tracking application in excel.In this video, we will be declaring and setting public variables that will allow us to use them throughout the project. If you have not downloaded the workbook be sure to click on this dropbox link so you can follow along.`If you are not familiar with variables and variable scopes then. Be sure to check out Trever Easton’sVideo on variables here VBA ...

Read this entry »


Part 3: Scott's time tracker part3

09-04-2016 01:15 PM by ScottM1 | 0 comments »

In this video, I will show you how to add a toolbar and scroll bars to the application’s interface and more. be sure to watch the entire videoYou can download this workbook and follow along here.https://dl.orangedox.com/b8YsbkQYNzs0224YmV Be sure to like share and comment Subscribe → https://www.youtube.com/user/ecabine...confirmation=1You can also follow me on:Facebook→ https://www.facebook.com/ecabinetstipsandtricksTwitter→ https://twitter.com/eCabinetstips

Read this entry »


Part 4: Scott's timetracker Part4

09-25-2016 10:54 AM by ScottM1 | 0 comments »

Hi guys. Check out my latest video on making a time tracking application in excel. https://www.youtube.com/watch?v=kKErw2dmSVA&list=PLsajY4bbxhrBiASUneFk6SGICSCEeDQ_w&index=1In this video, I will show you how you can make a restore down icon and place it on the application’s toolbar. To do this I will be using MS Word and a free photo editing software called Gimp. You can download gimp here. http://www.gimp.org if you want to download the workbook and follow along you can do...

Read this entry »


Part 5: Scott's time tracker part5

10-31-2016 06:24 PM by ScottM1 | 0 comments »

Check out my latest video. https://www.youtube.com/watch?v=xznPCogVt48&index=1&list=PLsajY4bbxhrCKfcrq6PtA5gA2cYsbVtvAIn this video I will be adding the rest of the Restore buttons to the toolbar. I will be using a frame control that will allow all three images to be grouped together. Be sure to like share and comment Subscribe → https://www.youtube.com/user/ecabinetstips?sub_confirmation=1You can also follow me on:Facebook→ https://www.facebook.com/ecabinetstipsandtricks...

Read this entry »


Part 6: Scott'stime tracker part6

11-03-2016 05:38 PM by ScottM1 | 0 comments »

Hi, guys. Check out my latest video on making a time tracking application in excel. View on YouTubeIn this video I will show you how to use the mouse move event to program the restore buttons to make them change colors when you hover over them.Please like and share this video if it helps you.Make sure to subscribe to my channel so you can get all of my latest tips and trickshttps://www.youtube.com/user/ecabinetstips?sub_confirmation=1You can also follow me onFacebookhttps://www.facebook.com/e...

Read this entry »



DISCLAIMER: Any posts on LJ are posted by individuals acting in their own right and do not necessarily reflect the views of LJ. LJ will not be held liable for the actions of any user.

Latest Projects | Latest Blog Entries | Latest Forum Topics

HomeRefurbers.com