T
Tereba
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
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