The Ultimate Annual-Monthly Microsoft Excel Calendar template

By -

This Ultimate Excel Calendar Template allows user, company or any organization to create their own calendars. The template was created in VBA and may require the user to enable macro content in the document.

Annual Calendar Template:
  • Country - Choose your home country.
  • Year - Calendar year
  • First Day of the Week - The first day of the week to be displayed
  • First Week of The Year - Determines the work week number
The screenshot below shows the calendar of the whole year and the holidays.



The video shows how does Ultimate Excel Calendar template work.


Monthly Calendar Template:
  • Month - Choose which Month you want to display.
  • Year - Month year.
  • First Day of Week -  First day of the week to be displayed.
  • Country - Choose your location
This template will display the Holiday of the Month in the respective dates.


Download the Ultimate Annual-Monthly Excel Calendar or post your email in the comment so I can send to you the template file.

Comments

  1. StCroixDecember 12, 2013 at 10:30 PM

    Thank you for the sample. From a code review standpoint, I suggest enhancing variable names and adding additional comments. imho, changing variable names such as x and y to descriptive names greatly improves code readability and spending a few minutes writing a logic overview helps someone else start in on the code. Thanks for the start.

    ReplyDelete
  2. UnknownDecember 19, 2013 at 1:10 AM

    Hi StCroix,

    Thank you for your feedback and for spending time to review my work. Your suggestion is highly commendable. I'll be posting updates on this. You may also share your ideas of any additional features to be added that will improve the logic of this program.

    ReplyDelete

Post a Comment

Popular posts from this blog

How to Create a Configuration.INI Files in VB6

By -
Image
In this example shows only a simple form that saves and retrieves value from the CONFIG.INI file. After reading this, you can use your own creativity on how you're going to implement this on your project. To start with, On your Form add the following controls and arrange them according to the image above. (1) TextBox - Change the Name property to "txtSetting" (2) Command Button - Change the Caption and Name Properties to the following:                                        Save:          Change the Name property to "cmdSave"                                        Retrieve:    Change the Name property to "cmdRetrieve" (5) Label - For the two labels we'll be using to retrieve the values. Remove the default caption and change the Name Properties to lblName and lblTime . Now, Copy the Form Codes below and Paste on the Form1 code window of your VB6 Project. Form Codes: Option Explicit Dim ConfigFile As String Private Sub cm
Read More »

How to Make Windows Form Transparent using Visual Basic 6/VB6

By -
The following code snippets allows you to make windows form transparent using VB6. In a standard module, copy and paste the following declarations and function. [ Module1.bas ] Option Explicit Const LWA_COLORKEY = 1 Const LWA_ALPHA = 2 Const LWA_BOTH = 3 Const WS_EX_LAYERED = &H80000 Const GWL_EXSTYLE = -20 Private Declare Function SetLayeredWindowAttributes Lib "user32" (ByVal hWnd As Long, ByVal color As Long, ByVal x As Byte, ByVal alpha As Long) As Boolean Private Declare Function SetWindowLong Lib "user32" Alias "SetWindowLongA" (ByVal hWnd As Long, ByVal nIndex As Long, ByVal dwNewLong As Long) As Long Private Declare Function GetWindowLong Lib "user32" Alias "GetWindowLongA" (ByVal hWnd As Long, ByVal nIndex As Long) As Long Private Declare Function WindowFromPoint Lib "user32" (ByVal xPoint As Long, ByVal yPoint As Long) As Long Private Declare Function GetCursorPos Lib "user32" (lpPoint As POINTAP
Read More »

How to Set Windows Form Always on Top of Other Applications in VB6

By -
The following code snippets allows to set Windows Form Always on Top of Other applications in Visual Basic 6.0. Public Const SWP_NOMOVE = 2 Public Const SWP_NOSIZE = 1 Public Const FLAGS = SWP_NOMOVE Or SWP_NOSIZE Public Const HWND_TOPMOST = -1 Public Const HWND_NOTOPMOST = -2 Declare Function SetWindowPos Lib "user32" _ (ByVal hWnd As Long, _ ByVal hWndInsertAfter As Long, _ ByVal x As Long, _ ByVal y As Long, _ ByVal cx As Long, _ ByVal cy As Long, _ ByVal wFlags As Long) As Long The following SetTopMostWindow() function takes two parameters as follows:       hWnd : the window handle       Topmost : It is either True to set the on top or False if Not. Public Function SetTopMostWindow(hWnd As Long, Topmost As Boolean) As Long If Topmost = True Then 'Make the window topmost SetTopMostWindow = SetWindowPos(hWnd, HWND_TOPMOST, 0, 0, 0, 0, FLAGS) Else SetTopMostWindow = SetWindowPos(hWnd, HWND_NOTOPM
Read More »