1. To know how to insert the Calendar Control in worksheet, read the below topic. http://officetricks.com/insert-calendar-control-in-worksheet/ 2. After inserting, how to get the value of selected date into a cell. Press Alt+F11 and insert these codes. Private Sub Calendar1_Click() ‘Thisworkbook.sheets(SheetIndex or “SheetName”).cells(Row#, Column#) = ValuesToEnterIntoCell ThisWorkbook.Sheets(“Sheet1”).Cells(1, 1) = Calendar1.Value End […]
Insert Calendar Control – In Excel Worksheet – Date Picker
Learn how to insert a calendar control into your worksheet. Easy to pick date from the date picker control & display it in the worksheet. Install MSCOMCT2.ocx
How to Remove Duplicate values in Excel?
Learn how to remove duplicate values in Excel using Excel VBA, Formula & Google Spreadsheets formula & highlight duplicate entries. Find & remove the duplicate entries from Excel & Google Spreadsheet easily.
VBA Hello World – Excel Macro – For Beginners
Learn Excel VBA Hello World Macro code for beginners with step by step guide. Get to know how to Code, Execute a VBA code & get results. First step of Excel VBA Macro is to first learn this Hello World program.
