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
Please be kind with the comments, like I said I am very new. haha