Help !
I am using the Form.Refresh command and get an error message:

Compile error:
Method or data member not found

The sub is the following:

Private Sub ClrFormButton_Click()
Beep
Response = MsgBox("Are you sure you want to clear all informatio
from this form ?", vbYesNo + 48, "Clear Form")
If Response = vbYes Then ' User chose Yes.
Worksheets("data").Range("C34:C51").Delete
Form1.Refresh
DoEvents
Else
End If
End Sub

Where am I messing this up ?

Rgds
Tereba:confused

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