Thread: Hide Combo Box
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Die_Another_Day Die_Another_Day is offline
external usenet poster
 
Posts: 644
Default Hide Combo Box

Eliminate the select as you can't select a non-visible item:
ActiveSheet.Shapes("ComboBox3").Visible = True

Charles Chickering

Troubled User wrote:
I need the syntax for hiding and showing a combo box in VB. I can get it to
hide using:

ActiveSheet.Shapes("ComboBox3").Select
Selection.Visible = False

But when I try to use

ActiveSheet.Shapes("ComboBox3").Select
Selection.Visible = True

It won't let me see it (Get VB error). I think this is because I need to
turn on the Design Mode. Does anyone know the syntax to do that / solve
this problem. Thank you.