You can give this code a try. It must be placed in the sheet with the
callouts (right click the sheet tab and select view code). It reacts to
changes in Cell A1 and hides or unhides the callout AutoShape 1 (you may need
to change this) based on whether there is something entered in the cell...

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then
If Target.Value = "" Then
Shapes("AutoShape 1").Visible = msoTrue
Else
Shapes("AutoShape 1").Visible = msoFalse
End If
End If
End Sub
--
HTH...

Jim Thomlinson


"edwardpestian" wrote:


I have several Callouts on a sheet explaining to the user what data to
place in a specific cell. What I'd like to happen is that once the user
enters the data into the specific cell for the callout to disappear.

Thanks in Advance.

EP


--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile: http://www.excelforum.com/member.php...o&userid=33809
View this thread: http://www.excelforum.com/showthread...hreadid=549561