Home > Excel Tutorial > Excel Date Adding Form

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

To Download  Click Here

Date Form

  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: