cell value from 6 to 14 then

[prefix]

Ok so i'm trying to write a small macro which will initiate my code on a day of the month, at a specified time of the day the macro will change, according to the different shifts we work here.

what i want it to do is to run the macro Formiddag1 when time time of the day is between 6 to 14

I already have my worksheet set up with =Today() and =Now() Formula's to get the specific time, so the cells they are pointing to contain the correct values and they update whenever the day changes, and the hour changes. I guess i could write it to Change the Macro to run at 6 only but it would be nice to have the code know to run the code in question if the time of day is between 6-14 , the code will run approx. every 15 minutes.

here is the code i have so far;

Please Login or Register  to view this content.

[Domski]

So you only want to run the macro if the workbook is opened between 6am and 2pm and then run it every 15 mins?

Dom

[dominicb]

Good morning prefix

I think you're going about it the wrong way, to put the time in a cell, and then test that. Use code like this to test the hour, and react to it :

Please Login or Register  to view this content.

With regard to running the code every 15 minutes have a look at Chip Pearson's article on using OnTime here.

HTH

DominicB

[prefix]

Nice, i'll test that out, i didn't know the correct VBA so i figured i would use formula's together with Cells.Value, As for the 15 minute updater i already have a code for that, i just need a code to change between the macro's for each day and the 3 shifts on each day.
This is what this is for Thanks

[prefix]

Edited out, moved it to a thread of its own.