Have you explored converting the VBA to a COM add in?
Edit:
Consider posting this over at /r/excel.
Check out the book Professional Excel Development: http://www.amazon.com/Professional-Excel-Development-Definitive-Applications/dp/0321508793
This sounds like something right out of Professional Excel Development. My copy is at work so I can't check right now but if anywhere would have an answer it would be that book.
Professional Excel Development by Bovey provides step-by-step instructions to build a time keeping program. The CD that comes with it has the final product.
Excel Macro Mastery course online too, great resource.
In case anyone else is also interested, I found this book to be a fantastic resource. It teaches Excel, but more it actually teaches how to create professional workbooks: https://www.amazon.co.uk/Professional-Excel-Development-Applications-Addison-Wesley-dp-0321508793/dp/0321508793/ref=dp_ob_title_bk
I don't get to use Excel much, these days, but this book plus some prior Excel experience was extremely valuable for solving general business problems.
The exact book you are looking for is called Professional Excel Development.
https://www.amazon.com/dp/0321508793/ref=cm_sw_r_awdo_BBJB3NFNMG7PFJDFRTHR
This is not Excel, but for R - but the basic principles are the same: https://r4ds.had.co.nz/tidy-data.html
Also, a book I used and which was very helpful to dig deeper into the possibilities of Excel is Professional Excel Development by Bovey, Wallentin, Bullen, Green - My edition is from 2009, so it is a bit dated, but still - same principles still apply. https://www.amazon.de/Professional-Excel-Development-Applications-Addison-Wesley/dp/0321508793
Looks interesting, but it only covers up to version 2007.
Edit: link for the lazy. http://www.amazon.com/Professional-Excel-Development-Definitive-Applications/dp/0321508793