Calendar with scheduling [vba]

I will explain how I created this calendar in an upcoming post. You can download the excel calendar file here: Excel calendar.xlsm You need to enable macros to use this calendar.

Instructions:

Select a week

Select a week using spinner buttons or type a date in date cells

How to add a record

Double click a cell
Type text in title window and text window
Click Save button on userform

How to delete a record

Double click a cell
Click Delete button on userform

Overview Calendar

The overview calendar makes spinner button navigation easier. The selected week is colored gray and the date today is yellow.

Download Excel file

Excel-calendar2.xlsm

Calendar – monthly view

Tesh asks: How easy is it to modify this for recurring tasks (weekdays, weekly, monthly, quarterly and yearly) and maybe […]

Plot date ranges in a calendar part 2

I will in this article demonstrate a calendar that automatically highlights dates based on date ranges, the calendar populates names […]

Save invoice data [VBA]

This article demonstrates a macro that copies values between sheets. I am using the invoice template workbook. This macro copies […]

Open Excel files in a folder [VBA]

This tutorial shows you how to list excel files in a specific folder and create adjacent checkboxes, using VBA. The […]

Split data across multiple sheets [VBA]

In this post I am going to show how to create a new sheet for each airplane using vba. The […]

Populate cells dynamically in a weekly schedule

In this post I am going to add one more function to the weekly schedule I built in a previous […]

Shift Schedule

Geoff asks: Hi Oscar, I have a cross reference table we use for shift scheduling. The x-axis is comprised of […]

Highlight specific time ranges in a weekly schedule

In a previous post I created a simple weekly schedule with dynamic dates, in this post I am going to […]

Comments (4)

4 Responses to “Calendar with scheduling [vba]”

Remko says:

September 10, 2013 at 2:27 pm

Have you already published the code? I am very interested as i do not only want to use this, i also want to understand the reason behind it.

Reply
Murray Cooper says:

August 5, 2017 at 6:34 am

Hi Oscar,

Do you have either a 2D or 3D working example of this model?
Your model is quite interesting, but I need to create a roster for (say) Patient treatments.
So my user wants to see the patient (could be a Title so that now makes it a 2D model requirement); their treatments (could be several per patient throughout a day, evening or night shift) and which staff members will perform these treatments - so constraints and rostering issues. Plus my user wants to be able to edit/modify on the go ....
How would you approach this, please?
Thank you
Murray
PS we worked on the Yahoo historic stock data issue together.

Reply
Wagner says:

November 16, 2018 at 11:18 am

Hi Oscar

Congratulations, for your job.

I would like to know, How can I do to add a field in USERFORM?

Warmest Regards

Reply
- Oscar says:
  
  November 21, 2018 at 8:49 am
  
  Wagner,
  
  Try this:
  https://www.excel-easy.com/vba/userform.html

How to comment

How to add a formula to your comment
<code>Insert your formula here.</code>

Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >

How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.

Contact Oscar

You can contact me through this contact form