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