Hi
ISTEXT is not a VBA function. Try
application.worksheetfunction.istext

--
Regards
Frank Kabel
Frankfurt, Germany


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 I
want the message box to pop up. I know the code that i have written
is
correct, but

The problem is that it is telling me that the ISTEXT sub or function
is 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/