Dear all, iwould like some help!
I want to have a list of all the months in a sheet and when i will choose a month to hide and unhide columns in another sheet in the same workbook! Meaning that f.e. i choose march in the list and automatically i want to be transferred to another sheet where all the the completed cells are hidden and show me the columnes C,D H, and K (for example). I believe that is needed the use of VBA probably!
Thank you in advance for any help!
Lists(months) - hide/ UNhide columns
-
-
-
Re: Lists(months) - hide/ UNhide columns
Here is a little example that uses a form and multi-select listbox to give you the result you are after.
HTH
TJ
-
Re: Lists(months) - hide/ UNhide columns
Dear tinyjack,
thanks for the help! It is almost want i wanted!Can you please explain me how i will transfer the whole codes, forms buttons to another workbook? Because i have copy - paste the tool box in another file and when I am opening it, also your file is needed to be opend (automatically). Can you also expain how I can change the type of tool-box (for example to have just a List Box with an arrow, pressing the arrow showing the months and then pick the month etc).
Thanks a lot again in advance for your help!
All the best
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!