Home
Creators
Search Recent Random
Posts
Search DMs Popular Hash Lookup Tags Random
Importer
Import FAQ
Register Favorites Keys Review DMs Logout
Community
Telegram ThePornDude
Home Creators Posts Import Register Favorites Logout

Capacity Planning Manager: Review & Feature, Fix or Focus Request [Gold & Silver] (Patreon)

Published:
2023-08-02 12:15:01
Imported:
2026-06

Content

Hello Members,

The training we have for this week that I have shared with you was about the Capacity Planning Manager. If you have not seen it yet, you can view it right here on YouTube.

Now that the training has been released, I am looking for your feedback to make this even better, just for you, our incredible Patreon Members.

So, what Feature can I add for you? Did you find an issue you want me to fix? Or is there a particular area you would like me to focus on?

Please comment your ideas and feedback to any of these below and I will do my best to not only create an updated workbook but release a private training video next Monday, right here on Patreon.

I am looking forward to hearing from you and thanks so much for your support.

Files

Comments

Aravind Krishnakumar

Thanks Randy again for the planning tool. In userforms is it possible to add a date picker? Or is it possible to change the format to be consistent, because when I tried this in different computers am getting different date formats. Some have US format and some and UK format and yes of course depending on the regional setting. Is it possible to make sure we have the same date formats irrespective of the regional setting?

Excel For Freelancers

HI Aravind thanks for the comment. For the date format you can apply the dateCell.NumberFormatLocal = "Short Date" to any cell which would automatically set it to local format. Your regional computer date formats would be used for the default date formats within Excel. I hope this helps and thanks so much.

Aravind Krishnakumar

What about when loading the dates into the userform? Should we give a exit option to the form? Also what to do to a date picker like you have made in excel?