calendar help

Hi, Your help would be very much appriciated. Can you have a table with dates and purchases then transfer those dates and purchases to a visual basic excel calendar.

So if for example I have a direct debit coming off next month could I have that direct debit name pop up on a visual basic calendar?

Regards

Peter K

I have a calendar file that can do this. It doesn't use any macros, though. Are you interested?

Pete

Yes, I would like to have a look at it and see if it is suitable.

Regards

Peter K

In the attached file you can list the date and description of an event in any order on the Activities sheet.

On the Calendar sheet you can select the month and year of interest using the drop-downs in K3 and K4, and the calendar will automatically adjust. It will display events on the appropriate day, with up to 7 events/activites per day.

Hope this helps.

Pete

Hi Pete,

Thanks very much, just having a quick look at it and it seems to be suitable. I will be working on it tomorrow. If I have any questions I will send a wee message.

Again thanks for your help, very much appreciated.

Regards

Peter K

I just found this by following other links - it's wonderful! I'd like to use it however is it possible to see a full rolling 12 mos of the calendar on the view? I'd like to be able to choose to view 3/6/12 or one at a time to make sure there aren't any conflicts in a file I'm using for scheduling.

Yes, that is possible, but you should read the Forum Rules - you should not ask a question in someone else's thread. Instead, you should start your own thread, with a link back to here.

Pete

Hi Pete,
I am new to this forum and would like to say THANKS! for your calendar spreadsheet, it is Amazing!!. I just want to ask you how can I add further years if I needed?

Thanks!

The years that you can choose are controlled by the data validation drop-down in cell K4, so select that cell then click on Data | Data Validation and in the Source box under List you will see the years defined separated by commas. Just add what you need then click OK.

Hope this helps.

Pete

I just found what I had imagined without VBA.
Great post. Great forum.
Pete thank you