Showing Specific Columns using a multiselect listbox

[SA]

Hi all

I have trawled through the board looking for help on this so apologies if i have missed it, and if it is answered, would be greatful if you could send me the link. If not:

I have a multiselect list box in cell A1 with the ListStyle= 1 (checkbox)
It has 4 selections available - Country, Language, Name, Address

They are multiselect so any combinations are possible

If Country is selected i would like Column B to become visible
Language = Column C
Name = Column D
Address = Column F, G, and I

Columns E and H will always be visible

Would appreciate any feedback

many thanks

Stuart

 

[SA]

apologies all - am just looking to bring it up to the top in case someone can help - many thanks