VBA Compile error Label not defined

[bkey01]

I have an Excel workbook with multiple listbox's and command button. I have set an errhandler for printing. The first time it worked find and know I am getting an error that says:
Compile error
Label not found
for errhandler7

Ex. code

if listbox1.selected(7) then goto errhandler7
listbox1.selected(7)=false

errhandler7:
sheet1.printout
sheet2.printout
sheet3.range("a1:aa40").print

Can anyone help

 

[bkey01]

worked perfect!

Thank You!

 

[Von Pookie]

Blast, I responded as quick I my lil' ol' fingers could go and Kristy still beat me...Hiya Mrs. von Pookie!!!{EndEdit}

Hi Greg

 

[lnagel]

I would say your problem is that you're using End Sub at all of those. You've effectively made it so that anything after the End Sub at the end of errhandler1 isn't included in the macro.

Put End Sub at the end of your code and EXIT sub in place of the rest and give it a go.

This post (from 2004) finally resolved the same issue. Been stuck for 2 days on this problem - Thanks Kristy & Greg