Help with Error Code Please (Excel 2002/2003)

[braddy60]

Hi

The code below still runs the msgbox code even if there is no error, any ideas please.




Private Sub CommandButton8_Click()
On Error GoTo errhandler
Sheets("Taski").Select
Unload Navigationfrm
errhandler: MsgBox ("No Taski Distributor Selected")

End Sub

Regards

Braddy

[HansV]

Immediately above the errhandler:... line, insert

Exit Sub

Without the Exit Sub, code will *always* continue to the errhandler section.

[braddy60]

HI Hans

Once again I am in your debt.

Regards

Braddy