I have the following macro that hides an autoshape. I need to take it one step further. I have a checkbox that is linked to $D$23. I need to say if $D$23 AND if $G$31 = "" then show the autoshape, otherwise do not.

So if $D$23 is checked the autoshape will be visible until a value is entered in $G$31. Once a value is entered in $G$31 the autoshape will be hidden. But if the user leaves the value in $G$31 and unchecks the checkbox, the autoshape will remain hidden and the value in $G$31 will clear.

Hope this makes sence.

Thanks for any help

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$G$31" Then
If Target.Value = "" Then
Shapes("AutoShape 17").Visible = msoTrue
Else
Shapes("AutoShape 17").Visible = msoFalse
End If
End If
End Sub