on label caption change.... oh wait a min... Take a look

[redbull]

I have a form that works with a ticket system. Every so many seconds (Timed event) my program scrubs the screen for a ticket number, this ticket number then is displayed in a label caption... meaning...

Me.lblSDnum.Caption = SD
and SD = a variable of IE elements, depending on the situation...
this process is working very well, without issue.

So I created another process (sub Checks), this will open another IE window to an account screen to verify certain services... This happens behind the scenes, and as a stand alone, working very well.

I want this (sub checks) to run only when the value or caption of this label changes... meaning... if the rep is on one account.. and the label is displaying 123456... I want my code to run as soon as the timed even changes the label caption to 654321. I thought I would be able to have a "on change" or "after update" code fire off my sub... but with a label this does not appear to be an option.



I could just have this sub run with the timed event, but that would be excessive and would end up causing a slow down in system speed. So I want the sub to run ONLY when lblSDnum caption changes... any ideas?

[pbaldy]

In your timed event, test whether the existing caption is different than the variable before you set it, and run the other sub appropriately.

[redbull]

Hmm... I am going to have to figure out how to do that... ... I understand / like the method... but the code bit is not hitting me...

Currently...

Me.lblSDnum.Caption = SD

and SD is...

SD = otest.SD

Otest is a class module that references a lot of different IE elements that tend to change depending on the situation

Maybe have a invisible text box? this textbox has the value of lblsdnum, and I could tag an on change event to it to run the sub?? How would you program out your method?

[pbaldy]

If Me.lblSDnum.Caption <> SD Then  
  Me.lblSDnum.Caption = SD
  Run Other Sub
End If

[redbull]

alright, let me give this a shot

[redbull]

Works, thank you!

[pbaldy]

No problemo!