Hiding Combo Boxes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

charlie1234 - 18 Nov 2007 18:54 GMT

Is it possible for me to create a macro so that when I click a button, a
combo box is hidden?

I'm using Excel 2007 and Vista Home Premium if that helps

Thanks

Reply to this Message

Dave Peterson - 18 Nov 2007 19:21 GMT

It'll depend on what kind of button and what kind of combobox.

It could be as simple as:

Option Explicit
Private Sub CommandButton1_Click()
With Me.ComboBox1
.Visible = Not .Visible
End With
End Sub

This actually toggles the visibility.

If you just want to hide it, use this line:

.Visible = false

> Is it possible for me to create a macro so that when I click a button, a
> combo box is hidden?
>
> I'm using Excel 2007 and Vista Home Premium if that helps
>
> Thanks

Signature

Dave Peterson

Reply to this Message