Capacity Planning Manager: Review & Feature, Fix or Focus Request [Gold & Silver]
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.
Comments (4)
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?
Hi and thanks any userform date picker would work just fine. There is one I have used here you can try: https://youtu.be/PLAJ08LP7kE I will get one added for you on the update and address the date format as well
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?
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.