Hiding Drop Down menu

  • Thread starter Thread starter Edgar
  • Start date Start date
E

Edgar

I have a drop down menu called Drop Down 4.

What command can I use to hide this in a case select
statement?

TIA
 
Select Case i
Case 1
ActiveSheet.Dropdowns("Drop Down 4").Visible = False
Case Else

End Select
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pick from drop-down list gives empty or erroneous result 6
Open Specific Worksheet Using Button Form Control in Excel 0
show and hide a drop down list 1
Set Column choice to a variable from a Drop Down 4
Hide rows using VBA based on cell value 0
Drop down menus 2
is it possible for a drop down menu to select other drop down men 2
when certain rows are hidden, can I also hide a combobox? 6

Back
Top