VBA code for Australian Public Holidays

[paul_pearson]

Hello,

Would there be a VBA code to achieve the following

1. Have a box to enter the YEAR (this year 2013,next year 2014 etc and it calculates )
2. Press a button to bring up all the public holidays for the YEAR entered in the box.The name of the public holiday,The day it falls as well as the date
3. Need in Australian Public Holidays

Cheers

Word 2010

Paul

[Excel Fox]

Paul, what would you use as a standard (or widely accepted) source for this information? 2013 Calendar Australia | Public Holidays Australia and Special Occasions in Australia Calendar 2012, 2013, 2014,2015 (http://www.publicholidaysaustralia.com.au/) for example has only 3 years of information.