2 Replies Latest reply on Dec 16, 2014 3:19 AM by thomas.clchan

    How can I change the value of UPPER LIMIT with coding?

    thomas.clchan

      Hi all,

       

      As Question, how can I change it with VBA coding?

       

      upper.jpg

       

      Thomas

        • Re: How can I change the value of UPPER LIMIT with coding?
          gachen

          Hi Thomas,

           

          Editing the data set should be fairly straightforward:

           

          Private Sub ChangeDataset()
          
              Dim MyDatasets As Datasets
              Dim MyDataset As PIExpressionDataset
              
              Set MyDatasets = ThisDisplay.Datasets
              Set MyDataset = MyDatasets.GetDataset("UPPER LIMIT")
              
              MyDataset.Expression = "<new value>"
              
              MyDatasets.SetDataset MyDataset
          
          End Sub
          

           

           

          By the way, what is your end goal for changing the data set? Maybe there might be a better way to implement it so that you do not need code to change it at all.

          1 of 1 people found this helpful