Getting state change over time as Integer value

Discussion created by bpolaski on Mar 4, 2014
Latest reply on Mar 4, 2014 by Gregor

What I have is an excel sheet that a user  enters a tag, start time and end time.


This tag is a digital tag with two states ON/OFF. I would like to be able to write to an excel cell how many times the state changed to ON in the defined period but I have been having trouble implementing this functionality in VBA.


I was using this post as a reference: http://vcampus.osisoft.com/discussion_hall/add_in_microsoft_development/f/11/p/3301/17876.aspx#17876


but have not been able to adapt it for my purposes.