New video added to my youtube channel!

It's been a busy week or two, but here's the latest free video I've just added to my YouTube channel..and I think you could find it useful if you use Excel as a CRM o Project Tracker...


If you like this video, please hit the subscribe button!


This is a lecture I recorded in response to a student question in the VBA part of the course (Excel Essentials Level 3 - VBA Programming), which will teach you everything you will ever need to know about coding in VBA.


All the code is there on the screen for anyone to use, free, gratis, and for no charge :) Though I hope it will guide some of you to get the course...you should, it's really useful.


So, another student question, this time about using VBA in a project tracker to automatically add a date stamp and a " - " after it, so the user can just hit the button, and start typing.


So far so simple, BUT if there is already something in the cell, we want to KEEP whatever is there, simulate hitting F2 to edit the cell contents, go to the end of the current cell contents, add a soft carriage return to get us to a new line, and THEN add the date stamp - ...after all that, the interesting part is that we want the cursor to go directly to the insertion point, so the user can begin typing immediately.


Really useful if you have something like a CRM system where you keep a record of all actions against a customer, or a project, or whatever it is that you want to keep an "action" log of!


We'll use something we haven't covered in the course yet, SENDKEYS...and that's something that could come in very useful :)


Okay, you will find the full VBA code here, with a complete walkthrough of what each line does.


Enjoy!


Be sure to check out the other videos on the channel...there are quite a few!


Videos in the Level 1 series:


https://youtu.be/uNFJNJk_kyo

https://youtu.be/g4ExVFkrj7I

https://youtu.be/Sd7w4YrVKmQ

https://youtu.be/XPfZA-KrOrM

https://youtu.be/CGNP1jKAhGA

https://youtu.be/6At4-dfrWSM

https://youtu.be/6QSm0iNA-gc

https://youtu.be/NWRFK2SOTtA

https://youtu.be/CYCFs4dQnm8


Videos in the Level 2 series:


https://youtu.be/4B4VFgHfcCI

https://youtu.be/B6G5Vu97GIw

https://youtu.be/-YL6h4ZaPec

https://youtu.be/fSwl1kEwMdg

https://youtu.be/ij0_SkPhB_M

https://youtu.be/MHbOHpBxTa0

https://youtu.be/bDPJP2t28_A

https://youtu.be/Y5E2FZ8KHgM

https://youtu.be/LSGUDpBPWb8

https://youtu.be/DhwXh6IplPk

https://youtu.be/B5k1lbIC5lQ

https://youtu.be/DZq9TxIaecI

https://youtu.be/41Ke-oEEGUk

https://youtu.be/xn0VSwQ0Vpc

https://youtu.be/haZpJhLJbdA


Videos in the Level 3 series:


https://youtu.be/IzbCv0yWAUI

https://youtu.be/zw9ydY-GVXo

https://youtu.be/DZc0ekkOFTg

https://youtu.be/L0V1WkC7bzQ

https://youtu.be/2vUSnj9ULYk

https://youtu.be/itTaurKxZp0

https://youtu.be/w4d_SUMqNxM

https://youtu.be/9OOJu4pxOGc

https://youtu.be/rkf7Wc-CQIY

https://youtu.be/2QXcBWYlL_I

https://youtu.be/rHqnzyw-asw

https://youtu.be/QeUgI_d-ljU

https://youtu.be/DjlzkGmDOok

https://youtu.be/JM7NFLDGaJE

https://youtu.be/kNkL21Iw9bk

https://youtu.be/Y6s3MEV1CIk

https://youtu.be/tGBsYjwbldQ

https://youtu.be/398-GMY0z78

https://youtu.be/k-r2N-Bz1Os

https://youtu.be/EELAr2myuog

https://youtu.be/qAbiXRHFkoI

https://youtu.be/BJiI0CrqG1E


9 views0 comments

Recent Posts

See All

You can access all of my individual courses via a low cost monthly subscription, with the first 2 months completely free! 

If you want to access ALL of my courses (including future releases), and 27,000 other premium courses, just choose the subscribe button below any of the courses.

 

Subscription: By following a subscribe link, you will get two months free full access to all of my courses, as well as 27,000 other premium courses, on the SkillShare platform. After your two month free trial, the charges are (at time of print) $15.00 a month for a monthly subscription, or $8.25 a month if you pay for a year up-front ($99). That's great value, and if you decide it's not for you, just cancel your subscription within the first 60 days, and you won't pay a penny. You can also cancel your subscription at any point after the 60 day free period, but you will be charged for that month. You can't say fairer than that!

Purchase: Super Memory Essentials, Leadership and Management Essentials, and The Complete Excel Series (including Levels 1, 2 and 3) are available for purchase via the Udemy platform...just click " Buy Now..." or "Purchase Lifetime Access..."button and your special discount will be applied automatically. This option give you lifetime access, and is backed by the Udemy full 100% money back guarantee. So, if you're not entirely happy, you can get all of your money back, no questions asked.

That sounds good, right? I thought so. So, choose your path to learning, and I'll see you in the course(s).

  • Facebook Social Icon
  • LinkedIn Social Icon
  • Twitter Social Icon
  • YouTube

© 2023 by Personal Life Coach. Proudly created with Wix.com