- 0

## 6 answers to this question

## Recommended Posts

## Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Sign in to follow this

Followers
0

The time has come! The new website is up and running https://www.excelwtf.com/learn/ Check it out if you want to learn VBA or brush up on your Excel skills with some more advanced Excel tutorials!

News Ticker

- Welcome to the Community
- Use the forum to troubleshoot your Excel & VBA Problems
- We will be launching a new website soon! www.ExcelWTF.com/Learn ! Join us to learn VBA from the ground up!

- 0

You can post now and register later. If you have an account, sign in now to post with your account.

Sign in to follow this

Followers
0

All,

I'm looking for some help on a VBA code! I have a spreadsheet which holds data for products we sell (columns A to AY)

I have 10 products in total, each of which has 5 columns of matching data. So Product 1 is related to columns B:F, Product 2 is related to columns G:K, and so on. Is it possible to get VBA to hide the columns not applicable when a Product in column A is selected? Also can it highlight the selected Product in blue?

I know this has something to do with WorkSheet Change Events? But i'm not too familiar with it... any help would be great!

Thanks

Z

## Share this post

## Link to post

## Share on other sites