• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Check list creation

V

Veeru106

Member
Hi,


I am looking some solution or suggestion to prepare check list for the sheets.


We have 3 sheets where, user update data and then click on below to give intimation via email that he has done with the submission.(no code in sample sheet though)


I have a outlook code which trigger mail to all concern parties. What I want is can we have something, which work as a check list to make sure everysheet data has been updated.


Right now in example I have 3 sheets only but in real scenario I have more than 15 sheets, so it is little tricky to get track of each sheet.


How can we do it?


Please give your valuable thoughts on this.


Thanks
 

Attachments

  • BLR file.xlsm
    23.2 KB · Views: 5
Thansk a lot Veltm….i got it…it is working in my sheet.


Now what I am planning is can we have code which find out if my all col. D is full (which means if all buttons has been clicked and we have date n time mentioned in col. D in front of sheets in Col. C)


Code will see if all my col. D is full and then trigger other code which wil generate a mail and send it.


I have a code which is doing 2nd part….but I will have to go to check sheet every time to see if all are done or not and then manually click on send mail.


What I can see possibility to make it automatic as well.


Please suggest your thoughts.


Thanks
 
Hi Vletm,


Please find sample sheet, where I have mentioned send mail code..

So when my col. D is fully populated, or send mail code should trigger.


Thanks
 

Attachments

  • BLR file_chandoo.xlsm
    35.7 KB · Views: 1
( ... Did You solved that Your previous challenge (which You've deleted from here? )
Not exactly but i have figure out another way and that is working fine..so didnt want to bother you agian on this..

With currently one i have made certain changes and created a code in module but that is not working...showing as invalid reference...can you please make amendment into it please...
Thanks for taking pain and solving this ....Vletm
 

Attachments

  • Copy of BLR file_chandoo.xlsm
    36.6 KB · Views: 2
Veeru106
... yes ...
1) There is no action while press those [ Button 1] = cannot work.
2) Nothing marks those Update dates to 'Check Sheet'
3) Why 'Call' something in the beginning of send_Mail (again)?
... checking would happen while press [ Button 1 ] or how?

And as I wrote to that other Your case ... these should combine!
 
Hi


Here is my complete file…where code you have mentioned in worksheet I have converted into module.


Now my check sheet is getting populated with time when we click on Submit button in IND,CGD n MNL.


I know this is lengthy way to do it but this 2nd way to get the task done.


Now after getting Col. D populated still I am facing same issue” invalid reference”.


I am calling Confirm code because that is something again I have converted from your code , which you have written in worksheet.


The reason for calling it because before sending mail it will get it confirmed whether my Col. C is equal to Col. D if yes then send out mail.


We can remove msg box, which wants to confirm whether you want to send mail….it is compulsory, if all cell of Col. D are full…mail should go without any 2nd thought.
 

Attachments

  • Version 2 BLR file.xlsm
    41.1 KB · Views: 7
Veeru106
Of course, You could do this 'Your way' ... It's Your choice.

My opinion is that there are a lot of extra code.
Check my other file ... as You might just done.
 
Vletm my modified code is not working...need your help on this in module 1.....where it is giving me error of invalid reference
 
Veeru106
As I tried to write in previous reply...
My opinion is that there are a lot of extra code.
Check my other file ...
You did 'some' ... modifications ...
It would be quicker to get that ready than Yours :(
What would You send with that Email?
 
You must log in or register to reply here.
Back
Top