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

Pikus, Have deleted Case. The data form I want to pull up is th
standard data form you get in Excel from the dropdown "Data" the
"Form". The 'test' sheet has the database on it and I want to be abl
to add/subtract to the data base with an update button on the 'detail
sheet.

Deleting Case causes a syntax error with the message "expecting CASE".
Code now looks like:

Sub Button15_Click()
Select Application.Caller
"Button_15"
Worksheets("test").ShowDataForm
End Select
End Sub

but it won't compil

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