helloOriginally Posted by 大灰狼1976
thank you, did you look at the sheet Mars? i put another description there BF15
im sorry but i do not have enough knowlege to make something like this, i can frankenstein a macro together somehow, but this is totally new ground to me.
the button Cancel do not do anything (should close the window)
the button Ok do something but i dont know what, didnt find the text anywhere
the Ok button should compare the date in the "Date registred" collumn for the clicked row with all dates in the mounth sheets.
when date is found vba need to find the same machine name as the one in clicked row under the newly found date. look at the Mars sheet and date 15/3-19 and you wil see what i mean
then the user specifyed text neet to be written in the "what is done" collumn
same goes for the day of repair (should be date of repair, my bad)
and the same goes for "Sign" witch is user's name initials
Reply With Quote