This quick and silent how-to video shows you how to hide objects on click in Excel with VBA.
So, this particular lesson is useful if you plan to provide user interaction with your program. Moreover, it is greate if you plan to create something more dynamic, like a game.
Video on how-to hide objects on click in Excel
Below is the video on how to make an object invisible in Excel. Also, we have a previous video that allows you to show or display all objects in the program. That is useful if you want to bring back what you hide.
' Hide just one individual face
ActiveSheet.Shapes.Range("shp_Face_" & faceNum).Visible = msoFalse
So, you can show an individual piece too. Simply, change msoFalse to msoTrue on line 4. Of course, you would also change the words hide to show. Other than that, you are good-to-go.
Thank you for viewing this how-to lesson. If you want more training, then click on the button below.