Can I hide/unhide a Checkbox based on cell in another sheet's value?

[c.clavin]

Hi guys, Ive been Googling for VB code that will allow me to do this, but I'm not having any success. The cell I'm trying to base my box hiding/unhiding is X74 in Sheet1 and the checkbox is Checkbox27 (does that make a difference?) its the only checkbox on the page. This VB/Macro stuff is way over my head. Thank you!

 

[Micron]

Hide/unhide based on what, exactly? No data vs data? >45? =55? etc.

 

[c.clavin]

If it contains the word “both”. Sorry, I should have added that

 

[Micron]

perhaps worksheet change event. This is "air code" (from my head and untested):

Private Sub Worksheet_Change(ByVal Target As Range)

If Not Intersect(Target, Range("$X$74")) Is Nothing Then
   Shapes("Checkbox27").Visible = Ucase(Range("X74")) = "BOTH"
End If

End Sub

 

[c.clavin]

It doesn't seem to be working, the X74 cell is on Sheet1. Does that mean I need to refer to it as Sheets(Sheet1)?

 

[Micron]

If you put the code in the module for the sheet you want it to work on, you shouldn't need that. Won't hurt to reference the sheet name though. If you put similar code in a a standard module, then it's not an option. However, sheet change event code needs to be in the sheet module. It won't work in a standard module AFAIK. So "not working" doesn't help much. What happens? Nothing? Error message? Something else? Where did you put that example code?