Can someone be kind enough to help me out:
I would like to be able to have an option for the user to input a date on a screen and then I will have the system automatically scroll a trend (with datalogged data) to that time.
I've never coded with VBA so I have no idea.
I tried around and figured how to scroll the trend back to a specific date using:
Trend.XAxis.StartTime = #5/21/2014 1:20:20 PM#
Next i would like to make this variable, i.e. I would have 6 user input fields (yyyy,mm,dd,hh,mm,ss), I would then like to read them with VBA and (I assume) save them some variable, for example those with the names: yyyy,mm,dd,hh,mm,ss.
Then I should (presumably) be able to do this:
Trend.XAxis.StartTime = #yyyy-mm-dd hh:mm:ss#
so that it will scroll to user-chosen date.
Thank you for any help!
I would like to be able to have an option for the user to input a date on a screen and then I will have the system automatically scroll a trend (with datalogged data) to that time.
I've never coded with VBA so I have no idea.
I tried around and figured how to scroll the trend back to a specific date using:
Trend.XAxis.StartTime = #5/21/2014 1:20:20 PM#
Next i would like to make this variable, i.e. I would have 6 user input fields (yyyy,mm,dd,hh,mm,ss), I would then like to read them with VBA and (I assume) save them some variable, for example those with the names: yyyy,mm,dd,hh,mm,ss.
Then I should (presumably) be able to do this:
Trend.XAxis.StartTime = #yyyy-mm-dd hh:mm:ss#
so that it will scroll to user-chosen date.
Thank you for any help!