Hello,

I am really bad at writing VBA scripts and I want something very simpl
done in a sheet. The thing is I have a commandbutton that I only want t
be visible when a certain cell (which is only changed by a Drop Dow
box) contains the number "7". I know this should be pretty easy, but
just can't get the right code in there.

Can anyone please help? Thank you in advance,

Jasper Blaa

--
Message posted from http://www.ExcelForum.com

Hi Jasper,

Right-click the sheet tab and paste the following code:

Private Sub Worksheet_Change(ByVal Target As Range)
CommandButton1.Visible = Range("A1") = 7
End Sub


Change the cell refence and the name of the command button to accord with
your needs.

---
Regards,
Norman



"JasperBlaas " wrote in message
...
Hello,

I am really bad at writing VBA scripts and I want something very simple
done in a sheet. The thing is I have a commandbutton that I only want to
be visible when a certain cell (which is only changed by a Drop Down
box) contains the number "7". I know this should be pretty easy, but I
just can't get the right code in there.

Can anyone please help? Thank you in advance,

Jasper Blaas


---
Message posted from http://www.ExcelForum.com/

Hi Jasper

Right-click the sheet tab | View Code | and paste ...


---
Regards,
Norman



"Norman Jones" wrote in message
...
Hi Jasper,

Right-click the sheet tab and paste the following code:

Private Sub Worksheet_Change(ByVal Target As Range)
CommandButton1.Visible = Range("A1") = 7
End Sub


Change the cell refence and the name of the command button to accord with
your needs.

---
Regards,
Norman



"JasperBlaas " wrote in
message
...
Hello,

I am really bad at writing VBA scripts and I want something very simple
done in a sheet. The thing is I have a commandbutton that I only want to
be visible when a certain cell (which is only changed by a Drop Down
box) contains the number "7". I know this should be pretty easy, but I
just can't get the right code in there.

Can anyone please help? Thank you in advance,

Jasper Blaas


---
Message posted from http://www.ExcelForum.com/

Hi Norman,

Thanks! It's working perfectly.

Jasper

--
Message posted from http://www.ExcelForum.com