Modern Looking Userform

First of all, credit must go to:
1. TheSpreadsheetGuru
https://www.thespreadsheetguru.com/blog/build-modern-vba-userforms
2. Post from Larv on stackoverflow.com
https://stackoverflow.com/questions/6859127/how-do-i-vertically-center-the-text-in-an-excel-labels-caption/26131684#26131684

I created this sample using labels as buttons. I also include 1×1 pixel transparent gif image, the button change colour as soon as the mouse moves over it

85 Downloads

My Own Date Picker for Excel

How it works:
Standard TextBox with DropButtonStyle. Date Picker open next to each TextBox. Once a date is in the TextBox and you open Date Picker, the Date Picker will go to the date in the TextBox. Mouse over date highlights the date. Also show week numbers and a button for Today. No need for mscomct2.ocx (MS date & time picker control 6.0). My Date Picker is filled using “WorkSheetFunction”
Only 1 userform is used to display the date picker in different positions

This image has an empty alt attribute; its file name is Date-Picker-01.jpg
This image has an empty alt attribute; its file name is Date-Picker-02.jpg
This image has an empty alt attribute; its file name is Date-Picker-03-1024x587.jpg
see how my date picker works

Where it all started

I started Excel VBA in 2007. I was busy editing an exported excel file and deleted all the info that I did not need. A colleague saw what I was busy doing and told me that I can do that with one command using macros. He quickly wrote the command and from there I was hooked. I taught myself everything I know today. I am really into FSO (FileSystemObject). I did a lot of research on FSO. I work with a lot of folders & files. See my pages under LAD Utilities. I am constantly upgrading current and creating new utils. This is what I love to do.