ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Conditional Macros (https://www.excelbanter.com/excel-programming/276612-re-conditional-macros.html)

Don Guillett[_4_]

Conditional Macros
 
Ok, then have a look in vba help for selectcase

"Kevin" wrote in message
...
This seems like a simple thing to do, but I can't figure
it out on my own. Basically, I have multiple worksheets,
with successive months across the columns, and
corresponding data beneath. I want the user to be able to
quickly and automatically hide certain months in all of
the worksheets.

I was thinking of making seperate macros that hide
individual months, then having check boxes on a new
worksheet so that a user could just check the one he wants
to include/hide, then press a button, and it will run the
appropriate macros. I can make the macros, I just don't
know how to do some sort of "if" that will determine which
ones to run.

Ideally, I was hoping to just have a list box and have the
user select whatever months to inclue in this, but I
couldn't even get started on this, so I started the other
way. If you can help me with either of these methods, or
a different one, I will greatly appreciate it. Thanks.





All times are GMT +1. The time now is 06:50 AM.

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