Only repeat once

[jackandjill]

Hi this might be one of the old tricks in the book but also this is a simple one i believe, ok here is what i am trying to do
in the below code i want to take note of time that happens each time (pls see attached file)

Please Login or Register  to view this content.

but the problem is that i can't progress on to the next row because the loop goes back to X=1
again and again, how to overcome this?

[royUK]

What are you trying to do? I can't see why you need the loop

[jackandjill]

Oops! sorry not being clear the first time. Well basically I want to log the time when ever there is a change in a particular cell that means lets say the first change occurs at 1100hrs then system time should be placed in k1 and the next change occurs at 1115 (can happen anytime not fixed) then the system time will be placed in K2 and so on any easy way to do this...

For more clarity please see the attached excel file the VBA code i hope i have done somewhat close to my goal

[royUK]

There is no attachment

[jackandjill]

Strange, sorry about that, but here it is
also a rapidshare link
http://rapidshare.com/files/39851633...ging.xlsm.html

[Marcol]

Try this

Please Login or Register  to view this content.

Because you are triggering the change event with each step in your for loop X will always return to 1

Disabling .EnableEvents at the begining of your code and resetting at the end, should fix your problem

Hope this helps.

If you need any further information, please feel free to ask further

However

If this takes care of your needs, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody!
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.

[jackandjill]

Ok this is somewhat helpful, but please note that i want the word ok to be placed in k1 for the first change, then j5 wont be equal to d4 hence there should be only one OK in k1....after some more process there is a change and J5=D4 again another OK in K2
The above soultion does is gives me 10 OK at one go which is not what i was expecting,tks for the help

[pike]

you can add some thing like

Please Login or Register  to view this content.

[jackandjill]

OK great yes this is what i was looking for with a little glitch, it is why is that the first time that it happens twice? which mean the first time the statement is true the value is being reflected in L1 and L2 for the first time the statement is true.

Another thing is it is going thru rows i mean it is L1 L2 L3...so on
But what if i want it to be L1,M1,N1...so on the below code is something i tried but not working please help

Please Login or Register  to view this content.

[Marcol]

The code is your code and does what you asked it to do!

I don't understand what you are trying to do

....after some more process there is a change

What process?

Also note that your sheet has a formula in J5 this will not trigger the change event

It looks like it's H5 that changes
Change this line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Happy to help, but please try to give a clearer explanation of your problem.

[jackandjill]

Ok basically i have a value in d4 which is lets say 15 and i want to change the color of the d4 cell when ever the value in j5 matches to d4..
J5 is dynmic so the value 15 might go to 16,17,18,16 and then back to 15 again hence trigerring the sub again in this case i want to take note of the time time that this happens so the first time is at 1115 hrs second time might be at 1134 hrs and i would like these values to be displayed in a horizontal like m1,n1,o1 and so on...
This is what i would like to achieve as simple as posible is better tks

[snb]

Please Login or Register  to view this content.

[Marcol]

Hmm......

snb
Your code will not trigger because there is a formula in J5

jackandjill

Try this workbook and see if it is close to what you want.

1/. Enter any value in H5

2/. Then enter a value that has a match in column L

3/. Repeat with values at will, then one from column L, etc.........



Hope this helps.

If you need any further information, please feel free to ask further

However

If this takes care of your needs, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody!
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.

[jackandjill]

I am sorry for not keeping this post as solved but yes the last solution is very helpful and wroking as expected...thanks