replace problem and collor a row after 6 and 8 weeks

Dear forum members;

This is mine problem,

The searchscreen is also een search and replace function and has the following problem
By replacing the chances it goes wrong on this piece of code:

myrow = CLng(cmdVoerWijzigingenDoor.Tag)


Start with the start screen and click on the search button.
Than the search screen will appear.

You search with the button and field Search BSN and you make chances in the form than you click on the button Do change.

I don’t know where it goes wrong.

Can you help?


Warning I have disabled the start screen because its makes the ACTIVE worksheets invisible

Mine second problem is as follows.

The O column is the date of inserting the record.
The active row should after 6 weeks become green and after 8 weeks the active row should become red.on the basis of the inserted date (Datum invoer) column O.






I Have also tried this That does work to fill the variables but it does not fill the cells in the sheet.

Please Login or Register  to view this content.

Antonio thank you verry much for your help.


It looks like it. But i can not find where you did make the changes.


i ask this because 6 weeks becomes 8 weeks and the 8 weeks becomes 11 weeks. Mangers are never satisfied.


The find en replace works thank you but i stil don't no what i did wrong.

But for so far i am verry happy.