nagovind Member May 5, 2011 #1 Dear All Is it possible to hide a Combo box based on a condition or by a VBA code ? Please guide
Luke M Excel Ninja Staff member May 5, 2011 #2 sure thing. You need to use a Combo Box from the controls toolbar (the one you can modify via VB). Youcan figure out how to code the condition, but basic code: Sub HideMe() 'ComboBox1 is the name of combo box we want to change ComboBox1.Visible = False 'Toggle this as desired End Sub
sure thing. You need to use a Combo Box from the controls toolbar (the one you can modify via VB). Youcan figure out how to code the condition, but basic code: Sub HideMe() 'ComboBox1 is the name of combo box we want to change ComboBox1.Visible = False 'Toggle this as desired End Sub