Hi all,
Need some VBA help with hiding columns based on a combo box selection. The Combo box currently has roughly 30 selections and could increase over time. I would like to have the user select a value in the comb box and the code find the cell value (text) that matches and hide all other columns.
Any help is greatly appreciated.
Thanks,
Nick
is the combobox on a userform or on a sheet?
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
It is on a sheet
You can try this. Assuming your combobox is named ComboBox1.
Please Login or Register to view this content.
Last edited by Solus Rankin; 09-05-2013 at 06:43 PM.
Solus,
I have copied your code in, when I select a value in the combobox it does not hide the non-associated columns. However if you select the blank part of the drop down it will hide column A.
where did you copy the code to? what are you using to trigger the code?
I have attached an example of what I am working on. ComboBox3 is the topic of this thread.
Price List Example.xlsm
where did you copy the code to? what are you using to trigger the code?
It is copied on Sheet8's code page. I'm not sure what you mean about triggering the code....
Price%20List%20Example.xlsm Sorry about the duplicate post.
Basically you're trying to hide all columns where the header doesnt match combobox3 correct?
try the attachment.
Works Perfect! Thanks for your help!
Glad to help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks