I am trying to call the data form for a list on another worksheet. On one sheet, I click a button, and the macro sends me to another sheet and calls the data form for the list on that sheet.

http://www.excelforum.com/showthread.php?t=586226

I get the same error message as the first post got. The last reply to this posts suggests the list has to be within the range of A1:B2. Mine is not, and it cannot be either.

Anybody know how to get this thing working? The code I am using is below. Just activating the worksheet and trying to show the form.

Private Sub AELForm_Click()

Dim wksAEL As Worksheet

Set wksAEL = Worksheets("Added Equipment List")

wksAEL.Activate

wksAEL.ShowDataForm

End Sub