|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
SlickEdit: Code in over 40 languages across 7 platforms. SlickEdit’s unmatched power, speed, and flexibility allows even the most accomplished developers to write better code faster. Download a free trial today! |
|
#1
|
|||
|
|||
|
i have created a macro in a excel workbook and need to include an error handler
the macro transfers data from worksheet "dailyorders" to worksheet named "database" but i need to include a error handler which will produce a message box "database unavailabe" if the worksheet named "database" has undergone a name change any assistance would be appreciated |
|
#2
|
|||
|
|||
|
I beleive the coding for error handler in Excel is the same as it is in VB and MS Access
'At beginning On Error Goto Error_Handler_Excel 'Right before the botton Error_Handler_Excel_Exit: Exit sub Error_Handler_Excel: Select Case Err.Number case Else msgbox "Uncontrolled Error " & Err.Number & " " & Err.Description goto Error_HandlerExcel_Exit End Select S- |
![]() |
| Viewing: ASP Free Forums > Programming > Visual Basic Programming > error handler |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|
|
|