Visit and subscribe our YouTube Channel: YouTube

Saturday 3 March 2018

How to Embed Calendar in Excel - How to Add Date Picker in Excel

Open Excel > Go to Developer Menu> in controls ribbon click insert> Click More Controls in ActiveX Controls.







Click more controls > Select Calendar Control 12.0




Draw the Calendar and double click the Calendar to open VBA

Just enter : ActiveCell.value = Me.Calendar1.value 

Save it.  Now Embedded Calendar is ready to use.

Any Further Queries please feel Free to Contact us:

goodwilllearningworld@gmail.com


goodwilllearningworld@outlook.com

View and Subscribe to our YouTube Channel

To Download the Embedded Date Picker in Excel Click below Link
Excel Date Picker



No comments:

Post a Comment