VBA compile error label not defined

  • Thread starter Thread starter bkey01
  • Start date Start date
B

bkey01

I have an Excel workbook with multiple listbox's and command button.
have set an errhandler for printing. The first time it worked find an
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
 
Looks like a corrupted module.

Copy code to notepad. Delete the module, then copy/paste from notepa
into a new module
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top