Hello,
I am creating a form on Excel and what I would like to do is have a button that hides and unhides certain cells.
For example, imagine Mike is filling out a form with his personal Information i.e. Name, address, phone number, email, etc.
Mike comes to a section in the form that asks for an emergency contact person and that person's name, number, address, and relationship to Mike. Mike fills it out but, the form also allows Mike to input data for a second emergency contact person if he selects "Add another contact" at which point a range of cells come up with blank fields similar to the first emergency contact person asking him to fill out the second person's name, number, address, and relationship to Mike.
Basically I would like these cells to be hidden and only appear when Mike clicks "Add another contact"
I played around with toggle Buttons and VBA and seems like you can only hide an entire row or an entire column, but, what if I would like to hide a range of cells?
