Hey there
I have made a smaller system. Where you can fill in two columns and then you have to click on a save button and then it will make a note based on this.
In column 3 "code" there will always be the number 0 and in column 5 "input note" you can enter note.
I have made a code that if it says something in columns 3 and 5 then it must save the note.
But because it says 0 in column 3, it will still save. But it should only save if the number is greater than 0 can you help?
I have made a smaller system. Where you can fill in two columns and then you have to click on a save button and then it will make a note based on this.
In column 3 "code" there will always be the number 0 and in column 5 "input note" you can enter note.
I have made a code that if it says something in columns 3 and 5 then it must save the note.
But because it says 0 in column 3, it will still save. But it should only save if the number is greater than 0 can you help?
VBA Code:
'''''''''''''' IF EITHER STATUS COLUMN C OR NOTE COLUMN E CONTAINS DATA, RUN THE SCRIPT
If .Cells(x, 3) <> "" Or .Cells(x, 5) <> "" Then