Excel Date Adding Form

Date Userform

           Enter the dates into cells easily with date userform.When double-clicking on any page ,the date form opens. You can enter the date format (short date,long date etc.) to you want the selected cells. You can also adjust transparency of the form to view the date .

I added the following code in workbook to open the date  form with a double click in all the pages(Excel Vba Window_ThisWorkBook) :

Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)

UserForm1.Show

End Sub

Click Here To Download Template

 

• Excel Tutorial