Saturday, July 11, 2015

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

No comments:

Post a Comment