ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel forms - hiding a group of controls (https://www.excelbanter.com/excel-programming/435795-excel-forms-hiding-group-controls.html)

Brad Robl

Excel forms - hiding a group of controls
 
I have an Excel spreadsheet with controls on the sheet. The controls have a gray label behind them so it looks like a form on top of the Excel sheet. I need to have something like a Multipage, where I can have 2 pages of information, but Multipage doesn't appear to be an option for controls that can be placed on the Excel sheet.

I thought about having command buttons that say page 1 and page 2, and they could hide or show the controls for the appropriate page, however, I don't want to have to list each control within the programming and hide each one. Is there any other way to do this?

Thank you.

EggHeadCafe - Software Developer Portal of Choice
Dr. Dotnetsky's Cool .NET Tips and Tricks # 4
http://www.eggheadcafe.com/tutorials...-cool-net.aspx


All times are GMT +1. The time now is 08:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com