View Single Post
 
Old 11-18-2015, 02:34 PM
komobu komobu is offline Windows XP Office 2003
Advanced Beginner
 
Join Date: Feb 2011
Posts: 34
komobu is on a distinguished road
Default Create Calendar Item though VBA

Hi;

I would like to create a calendar item through vba so that much of my items will already be filled in. I also want to increase the font size in the item.

I am hoping to click on an icon in the ribbon (Which will run a macro), and a macro will create a new event with the subject of "Vehicle Inspection", Start Time would be current date & Time (Nearest 1/2hour), The default duration would be one hour and the AllDay Event would not be checked.

In the body of the calendar item I would like the font set to arial 16, and these 3 lines:

VIN:
Od:
Plate:

is this possible?

Any help would be appreciated.
Reply With Quote