Monthly to do list

Dear Experts

I am trying to create a Monthly To Do List for an year in Single Sheet. With the help of an macro I was able to show only 10 sample tasks in the file attached. In the sample file If I write the Date of Completion, immediately in Month Column a tick mark should appear for all the twelve months. Similarly the data on Completed Task, Pending Task and Completion rate (%) should appear. I request your good selves to help me to accomplish the job by providing macro.

Thanks in Advance

With regards

Buvanamali

Dear Sir

Tick mark should appear not for all (?)the twelve months. or only for the completed month. Sorry for my mistake. Other than this it is working good.

Thanks a lot for your immediate response.

With Regards

Buvanamali

Dear Sir

Can You please help me to accomplish the above task by a Userform Entry. The Userform should have combobox for selecting month, then the another combobox for selecting the task. I shall be much thankful if you could help me as requested above.

Thanks in advance

With Regards

Buvanamali

Dear Experts

I uploaded the above file with Userform. I request your good selves provide me the code to accomplish the task.

Thanks in Advance

With Regards

Buvanamali

Dear Experts

Any Help

With Regards

Buvanamali

Dear Experts

Any Help, Please

With Regards

Buvanamali

Dear Experts

Any Help, Please

With Regards

Buvanamali

Dear Mr beyondexcel

Apologies for the delayed Reply.

First of all, Thanks for your guidance. Now I had revised the Userform and attached the same for your kind perusal. Here I had created only for Jan, but my request is to create for all the 12 months in a single sheet. Please help me in accomplishing the task.

Thanks in Advance

With Regards

Buvanamali

Dear beyond Excel

Thanks for immediate response. As pointed out I had made Month and Date of Completion into one Cplumn - for 12 months. I have also inserted combobox2 for Month Column. Please help me.

Thanking you

With regards

Buvanamali

Dear beyond Excel

Thank you very much for your efforts. Each "Task" has only one associated date in each month.

I opened the above File 'Test_1.xlsm', on pressing the black button 'Click to Show the Userform', It throws error. For your kind perusal I have taken the screen shot, the first error appears twice and last one is second error 'out of Memory'.

Please guide me to make it error free excel file.

Thanks in advance

With Regards

Buvanamali

Dear Mr beyond Excel

I tried as advised. Still I am having problem. I am enclosing the screenshot of the errors.

Awaiting your solution.

With regards

Buvanamali

Dear Mr beyond Excel

I tried as advised. I am getting the errors as posted in 'Post 14'.

Awaiting your Solution.

With regards

Buvanamali

Dear Mr beyond Excel

Thanks for your valuable efforts.

Any help from others in resolving the issue.

Advance Thanks

With regards

Buvanamali

Dear Mr beyond Excel

First of all, thank you very much for your wonderful job.

The Error message was only in my Labtop. Then I tried the same in my Desktop which didn't give any error msg and I was able to see all the 3 userforms and tried working on it. It was working very smoothly.

Now What I am typing in Userform3 is stored in Tabla1, but I expect the dates to be stored in respective column as shown in Sheet1. For example if I put in Jan date it should be stored in 'B' column, If I put in Feb date it should be stored in 'D' Column as shown in Sheet1 so also for Remarks. Kindly help me in resolving the issue.

For your information, the problem was due to the 'icons' in the Userform for Save and Remove in UF2 and UF3 then I removed it and inserted Buttons for the same.

But I have to give due respect for your efforts that you had taken for me.

Thanking you in Advance

With regards

Buvanamali