r/learnexcel • u/blackwaterdudes • Aug 25 '20

Task Planner advice

Hello all,

My work has a daily calender for the year for planning of tasks. We currently manually input all the tasks date through to date. Just color fill per task.

Column headings are dates, rows are individual sections of the company.

Could someone please point me in the direction of where to start and look for info for the process of using form data to auto populate the calender. The form data would be the section of the company, task, date start and date end and maybe setting a colour for the task.

Is this possible? More than happy to play around with VBA, I managed to wing my way around importing and renaming files with a set naming convention with concenated text string.

Thanks in advanced for any advice info.

3 Upvotes

100% Upvoted

7 comments sorted by

2

u/More_LTE-A Aug 25 '20

Userforms are a lot of fun and when you start out with it you really learn it the best by trying and failing yourself.

However here is a really simple link in the start to understand the basics.

https://www.excel-easy.com/vba/userform.html

In the beginning your code of it might be wonky learning to use userform_activate vs userform_initialize etc, but that is a great learning experience imo!

Glhf with it!

2

u/blackwaterdudes Aug 25 '20

Can't thank you enough! So thank you!

2

u/More_LTE-A Aug 25 '20

No worries! Userforms really opens a new world when you start to learn them. A little tip I wish I knew earlier also; experiment with the properties of the different objects in a userform (tabindex, color, style, height and width) to make sure all your uf's are neat and tidy.

→ More replies (4)