LinkBack URL
About LinkBacks
Hi,
My data is in columns and each column may contain different year, such as 2011,2012,2013 and etc. I am trying to create a ListBox so I can make a selection or multiple selections and hide columns based on my selection.
Can anyone help!
Thanks,
Hi,
My data is in columns and each column may contain different year, such as 2011,2012,2013 and etc. I am trying to create a ListBox so I can make a selection or multiple selections and hide columns based on my selection.
Can anyone help!
Thanks,
I'm assuming you know how to populate and setup an ActiveX multiselect listbox
The following code will hide/unhide the columns base on the listbox selection
Please Login or Register to view this content.
Elegant Simplicity............. Not Always
Thank you! I will try and let you know.
Andy - I tried the code but I got the following error. Run-time error '424' Object required. Do you know what may cause this?
Hey sarperb
things you may need to adjust within the code are shown in red
Also...... the sub and function need to sit in a code module not a sheet module...Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks