Hey
I have a excelsheet that several ppl use.
In it i have built a userform that ppl use to input data, read and edit data.
One action the users do is to mark data s "completed".
In my table the row gets an TEXT in one column, stating that that row is "done".
I would like to build some kind of "reminder".
For example, a popup that display all rows that does not have this TEXT that marks the row as completed...
Like a popup telling the user that XXX is not completed (XXX can be data from another column for example a name that is part of my table).
How would i do this?
If a cell E4:E does contain the text "KLAR" then
do nothing
else
print a popup window printing column A,B,D data from the rows that does not contain the text "KLAR" in column E.
I have a excelsheet that several ppl use.
In it i have built a userform that ppl use to input data, read and edit data.
One action the users do is to mark data s "completed".
In my table the row gets an TEXT in one column, stating that that row is "done".
I would like to build some kind of "reminder".
For example, a popup that display all rows that does not have this TEXT that marks the row as completed...
Like a popup telling the user that XXX is not completed (XXX can be data from another column for example a name that is part of my table).
How would i do this?
If a cell E4:E does contain the text "KLAR" then
do nothing
else
print a popup window printing column A,B,D data from the rows that does not contain the text "KLAR" in column E.
