VBA code to hide/unhide columns

[radline2006]

Hello! I am new here and have a vba question. I need columns W & X to be hidden based on whether or not an entry has been made in column U. So, Column U has a drop down menu for the user(s) to select from, however I would like Columns W and X to be hidden until they make a selection from one of the items in the list in U. Seems like this should be fairly simple however i have virtually no knowledge of vba.

If anyone can help or recommend a book I would greatly appreciate it. Let me know if you need me to send the form.

Thanks!

[MaczaQ]

Hello,

I think code in attached workbook solve your problem.
fill some data in column U and then delete them for see results.

For check surce code press ALT+F11 and see into Sheet1 code.

Best Regards

[Charles]

radline2006,

Welcome to the forum.
It would help if you attached a copy of your workbook.

[realniceguy5000]

Hi,

Here is another way,Maybe?

Please Login or Register  to view this content.

[Charles]

Hi,

Here's a different version. When the user select "b" in the dropdown in range "A1" columns W and X will hide.