View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pierre via OfficeKB.com[_2_] Pierre via OfficeKB.com[_2_] is offline
external usenet poster
 
Posts: 122
Default easy vba question

Hi experts,
i have a button on a userform called 'cancel'
the sub looks like

Private Sub but_cancel_login_Click()
MsgBox "The program is closed", , "DPA"
error_h 'sub that saves the workbook in a particular way
End Sub

On compiling it gives me an error on the line error_h
The error states that a variable or procedure is expected and not a module

I would just like to show the message and then execute the error_h module
Any ideas?
ThanksPierre


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200511/1