AnsweredAssumed Answered

New to VBA

Question asked by jwright on Aug 15, 2017
Latest reply on Oct 26, 2017 by knightk

I am very new to learning VBA coding and I would like to see if anyone can help.

I have multiple trends that I would like to be able to use commandbuttons to display its respective trend.

I would like the trend to be able to have the same functionality as if it were expanded. Such as being able to click on a pi point to hide/unhide, and using trend cursor without loading/viewing the other trends.

Like I said, I am very new to this. So here is the very basic code that I currently have:

     Private Sub CommandButton1_Click()

     Trend21.Visible = False

     Trend27.Visible = True

     Trend19.Visible = False

     Trend28.Visible = False

     Trend10.Visible = False

     Trend2.Visible = False

     Trend3.Visible = False

     Trend11.Visible = False

     Trend30.Visible = False

     Trend8.Visible = False

     Trend12.Visible = False

     Trend22.Visible = False

     End Sub

Please be kind with the comments, like I said I am very new. haha