I have written the following code:

Private Sub Workbook_before close (Cancel as Boolean)

Dim D7 As String

If IsText(D7) Then
If IsEmpty(E7) Then
MsgBox "E7 is empty, please fill it"
End If

Cancel = True


End Sub

If cell D7 has text I want E7 to have text too, and if it doesn't
want the message box to pop up. I know the code that i have written i
correct, but

The problem is that it is telling me that the ISTEXT sub or function i
not defined. I am missing something but I can't figure out what it is


WHAT THE HECK IS IT TRYING TO TELL ME????!!!
I am SOOO confused and frustrated

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