AttachedIn
Contribute to our Discussions and download strukts Spreadsheets after Signing Up with us
How to show and hide objects in VBA
  • Insert this code inside a Module in the VBA:

    If Worksheets("SHEET1").Range("A1").Value <= Worksheets("SHEET1").Range("B1").Value Then<br />Worksheets("SHEET1").Shapes("Group 01").Visible = False
    Worksheets("SHEET1").Shapes("Group 02").Visible = True
    Else
    Worksheets("SHEET1").Shapes("Group 01").Visible = True
    Worksheets("SHEET1").Shapes("Group 02").Visible = False
    End If

    Change SHEET1: as per the worksheet
    Change Range: as per the cell of your condition
    Change shape: as per the object name, you can find it when you click on a group and see at the left of the function bar.

Welcome to strukts forum!

If you want to take part in the discussions, Sign In or Sign Up below!

Members (992)

Spreadsheets


Footings


Rect Columns


Circ Columns


Beams


Subgrade


Flexure


Punching


Shear


Wind


Deflection


Subscribe by Email


AttachedIn