I need to make vba macro to check did I finished all procedures for some work. It should be done by Boolean logic, like:
Task 1 (Change date of report): Did u finish task 1? then Boolean question Yes (click) No (click) then Proceed Forward on task 2 Yes (click) No (click)
Task 2 (Did you import data from system): Did u finish task 1? then Boolean question Yes (click) No (click) then Proceed Forward on task 3 Yes (click) No (click) ... and so on up to 9 task BUT
i need not to have strict order of finishing task, like I can finish task 1 and proceed to do task example 5, BUT I need it to show which tasks are not finished
I wrote this below, but I do not know how to do it as I write up
Sub Procedures_of_tasks()
Msg = "Did you do Task 1?"
Ans = MsgBox(Msg, vbYesNo)
If Ans = vbNo Then MsgBox "Do Task 1"
If Ans = vbYes Then MsgBox "Proceed Forward"
End Sub
any tips
Task 1 (Change date of report): Did u finish task 1? then Boolean question Yes (click) No (click) then Proceed Forward on task 2 Yes (click) No (click)
Task 2 (Did you import data from system): Did u finish task 1? then Boolean question Yes (click) No (click) then Proceed Forward on task 3 Yes (click) No (click) ... and so on up to 9 task BUT
i need not to have strict order of finishing task, like I can finish task 1 and proceed to do task example 5, BUT I need it to show which tasks are not finished
I wrote this below, but I do not know how to do it as I write up
Sub Procedures_of_tasks()
Msg = "Did you do Task 1?"
Ans = MsgBox(Msg, vbYesNo)
If Ans = vbNo Then MsgBox "Do Task 1"
If Ans = vbYes Then MsgBox "Proceed Forward"
End Sub
any tips