Macro to add Date, Month and Year

[syed867]

Hi All

I attached an excel sheet which required the desired output.

There are two combo buttons
1. Add Channel
2. Add Month

1. Add Channel

This button is used to add a channel in the current excel sheet. For E.g If I select Channel 5 It adds with 00:00:00 on time band column (example show in the sheet)

2. Add Month

This button is used to add Date,Month,Year horizontally on the same sheet.I found it a difficult one as I am unable to write an advanced macro.

Following is the link to download the excel sheet

https://drive.google.com/file/d/0B_e...ew?usp=sharing


I hope anyone can help me out on this dilemma.

Regards
Cityguy

[davesexcel]

When you click the month button, where is the month and year supposed to go?

[syed867]

If I select January 2015 and click Add month

It will populate the cells on the same sheet in the following pattern as mentioned in the file.

Jan.15
Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

[davesexcel]

Here ya go,
The results of the comboboxes are hiding behind the comboboxes.
Right click on the sheet tab and select view code,

[syed867]

Its not working

[davesexcel]

Really.....
As soon as I opened it, and changed the Month or year, it automatically adjusted, so... that would mean it is working.