Label not defined vba ошибка

I keep getting this msg

VBA

Compile Error:

Label not defined

Yes, Label starts with a letter.

Label Has No spaces

Label Has Nothing but letters.

Label’s First letter is in column 1   ( per the editor in Access VBA code editor )

Label Does end with a “ : “   at end.  
Not with the extra spaces or quotes.

i Did comment the line out with the Label,  ( only label on the line). On a new line I retyped the same label.

i Did save, do a RefreshAll, did a close of VBA editor, then restarted VBA editor, clicked on reset, then debug got same msg.

i did this between every time i tried a different way.

I used GoTo ErrHandler

then added    On Error GoTo ErrHander

I copied the label from the Goto line, then pasted it at spot I want, with first letter in column 1, added “ 
:   “ at the end,  so no way I could have misspelled the label.

I also did the same using  57    
as the label, I did put label on line 57 just in case.   as in goto a line number.

Every time I get the same msg.

Only thing I noticed that was different is in     Tools / References I see under Available References the below

EditionUpgradeHelperLib

Location  C:WindowsSystems32 EditionUpgradeHelperLib.dll

Language:  Standard

That is the only reference I do NOT ever recall seeing before. If definitely was no picked before.

I did search net, only info I got came to this, download third party app(s) that is supposed to check all “dll” files , fix them, and remove them if you want to, but that doc had a LONG list of things to do before run program, and hope fixes, not make worse.
and how to reinstall the dll if it turns out you MUST have it.

Was never able to find out what that file is supposed to do.

Never before had this msg, unless I made a typo.

I do have under Available references checked

Visula Basic For Applications

Microsoft Access 16.0 Object Library

OLE Automation

Microsoft Office 16.0 Access database engine Object Library

Microsoft Office 16.0 Object Library

i thank you for any help you can give.

mark J

Mark J

1. Apr 24th, 2006, 07:15 PM

   
   

   #1

   

   Thread Starter

   
   New Member
   

   

   ---

   Label not defined error for a GoTo Statement
   

   How do I solve a «Label not defined» for a goto Statement like below

   These are the exact lines

   Public Sub txtSell_KeyPress(KeyAscii As Integer)

   If KeyAscii = vbKeyReturn Then
   GoTo Trick1
   End If
   End Sub

   Hence Trick1: would be located in another part of the code.

   I’d really appreciate some help.

   ---

2. Apr 24th, 2006, 07:20 PM

   
   

   #2

   Re: Label not defined error for a GoTo Statement
   

   Welcome to the forums

   VB Code:

   Public Sub txtSell_KeyPress(KeyAscii As Integer)
   
   
   
   
     
   
   
                          
     
   
   
   
   If KeyAscii = vbKeyReturn Then
   GoTo Trick1
   End If
   'Maybe more code etc....
   Trick1:
   End Sub

   ---

3. Apr 24th, 2006, 07:24 PM

   
   

   #3

   Re: Label not defined error for a GoTo Statement
   

   

   A GoTo statement can only move to something within the current Sub/Function. Perhaps you want to call a different Sub?

   VB Code:

   Public Sub txtSell_KeyPress(KeyAscii As Integer)
       If KeyAscii = vbKeyReturn Then
           Trick1
       End If
   End Sub
   
   
   
   
     
   
   
                          
     
   
   
   
   Private Sub Trick1()
      ' Some Code
   End Sub

   ---

4. Apr 24th, 2006, 07:24 PM

   
   

   #4

   Re: Label not defined error for a GoTo Statement
   

   Trick1 has to be in the same procedure as the GoTo, but using GoTo like that is usually not a good idea.

   ---

5. Apr 24th, 2006, 07:30 PM

   
   

   #5

   

   Thread Starter

   
   New Member
   

   

   ---

   Re: Label not defined error for a GoTo Statement
   

   Then, how do I send it to a line that is not within the same sub process.

   What statement can I use?

   ---

6. Apr 24th, 2006, 07:32 PM

   
   

   #6

   Re: Label not defined error for a GoTo Statement
   

   Use bushmobiles example if you want to call another sub routine from your current one.

   ---

7. Apr 24th, 2006, 07:33 PM

   
   

   #7

   Re: Label not defined error for a GoTo Statement
   

   Your code shouldn’t be designed so that you need to jump into the middle of another sub.

   ---

8. Apr 24th, 2006, 07:35 PM

   
   

   #8

   

   Thread Starter

   
   New Member
   

   

   ---

   Re: Label not defined error for a GoTo Statement
   

   Some example code would be nice!

   ---

9. Apr 24th, 2006, 07:36 PM

   
   

   #9

   Re: Label not defined error for a GoTo Statement
   

   ---

1. 07-24-2018, 02:51 AM

   
   

   #1

   

   
   Registered User
   

   

   ---

   Very urgent — Getting error Label not defined even after defining it.
   

   Hi,

   When I tried to compile my VBA code I’m getting an error that says «Label not defined «. The label that it is referring to is getNextRowStudentVIIandVIII.
   I’m attaching the excel with the macro and vba code. Kindly help me. Its quite urgent. Thanks friends.

   ---

2. 07-24-2018, 03:54 AM

   
   

   #2

   Re: Very urgent — Getting error Label not defined even after defining it.
   

   If this is a label as in

   then the label needs a colon ( : ) on the end of it.

   Trevor Shuttleworth — Excel Aid

   I dream of a better world where chickens can cross the road without having their motives questioned

   ‘Being unapologetic means never having to say you’re sorry’ John Cooper Clarke

   

   ---

3. 07-24-2018, 06:08 AM

   
   

   #3

   Re: Very urgent — Getting error Label not defined even after defining it.
   

   Hi !

   As a good code does not need any label — except for error handling — since more than 20 years for VBA ! …

   ---

4. 07-24-2018, 06:55 AM

   
   

   #4

   

   
   Registered User
   

   

   ---

   Re: Very urgent — Getting error Label not defined even after defining it.
   

   Hi , I have given a colon. I rechecked. Still getting the same error

   ---

5. 07-24-2018, 07:10 AM

   
   

   #5

   Re: Very urgent — Getting error Label not defined even after defining it.
   

   In this case, it is because you have put an «End Sub» after each of the Return statements. You will need to comment them out except for the last, the actual end of the subroutine. It will then compile. GoSub is not an approach that I use so I cannot comment on its effectiveness.

   ---

6. 07-24-2018, 07:17 AM

   
   

   #6

   Re: Very urgent — Getting error Label not defined even after defining it.
   

   Gosub and Goto are statements from more than 30 years ago of the VBA grand pa’ : the BASIC !
   But they were left with the coming of some advanced version like Quick Basic and Turbo Basic more than 20 years ago.
   So since the beginning of VBA (more than 20 years) a good code does not need any Gosub neither any Goto statement …

   ---

7. 07-24-2018, 07:36 AM

   
   

   #7

   Re: Very urgent — Getting error Label not defined even after defining it.
   

   @Marc L: I agree with you, but the OP is where the OP is, so it is perhaps more helpful to get the code to compile and, hopefully, work rather than criticising the approach. I’d probably use called subroutines or functions but, that said, I wouldn’t know where to start to address this problem … so the OP is one or two steps up on me.

   ---

8. 07-25-2018, 06:56 AM

   
   

   #8

   

   
   Registered User
   

   

   ---

   Re: Very urgent — Getting error Label not defined even after defining it.
   

   Thanks a lot friends. So many end subs !! I agree. It is compiling now. Thank you very much

   ---

9. 07-25-2018, 08:37 AM

   
   

   #9

   Re: Very urgent — Getting error Label not defined even after defining it.
   

   You’re welcome.

   ---