View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lift Off Lift Off is offline
external usenet poster
 
Posts: 1
Default Button won't call macro

Have the following code on one sheet, "detail", and want to activate th
Data Form on the "test" sheet, same workbook.

Sub Button15_Click()

Select Case Application.Caller
Case "Button15"
Worksheets("test").ShowDataForm
End Select
End Sub

When I debug running to cursor, I get a Run-time error "13", typ
mismatch when the cursor is after "showdataform".

Thanks in advance.

Have Excel 2000...........

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