To hide column base on cellvalue or range if equal.To learn you can start with 'recording macro' to see what excel is recording, but it's not the most efficient way. Then you can press ALT + F11 to go into edit macro mode. In excel, you have to enable first the macro (and select the developper option). You then add this to a form, and set properties, as usual. The check the Microsoft Progress Bar control and OK. Right-click on the background of the Toolbox and pick Additional Controls.
When you're creating a User Form (in Excel VBA), you have the Controls Toolbox visible. You can download this Hide Formula Excel Template here All in One Excel VBA Bundle (35 Courses with Projects). Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback. Application.FormulaBarHeight = 5 Support and feedback.
