+ Reply to Thread
Results 1 to 3 of 3

Compile error: Sub or function not defined?

  1. #1
    Registered User
    Join Date
    10-09-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    78

    Compile error: Sub or function not defined?

    I am currently creating a Login and Register form. I have followed a tutorial on how to allow people to register into my program. When they have filled in their username and password they can click the submit button. Below is the code that i have used to record the username and password which they choose to create but i am unable to see what i have done wrong and why Excel is flagging my code up. It is telling me that "Private Sub cmdsubmit_Click() is the current problem and i have not defined it.

    Please Login or Register  to view this content.
    Last edited by mdovey; 10-09-2013 at 02:58 PM.

  2. #2
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: Compile error: Sub or function not defined?

    There are some typos (marked red) in this line:
    Please Login or Register  to view this content.
    The first one is giving the error.
    The other ones are hard to see, but they should be l (letter) iso 1 (cipher).
    Cheers!
    Tsjallie




    --------
    If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!

    If you think design is an expensive waste of time, try doing without ...

  3. #3
    Registered User
    Join Date
    10-09-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    78

    Re: Compile error: Sub or function not defined?

    Thank you very much it works perfectly now

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Compile Error: Sub or Function not Defined
    By grazian2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-02-2013, 04:27 PM
  2. [SOLVED] Compile error: sub or function not defined
    By Anita7 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-17-2012, 08:50 PM
  3. compile error: sub or function not defined
    By eaglefana101 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-17-2012, 01:18 AM
  4. Compile Error: Sub or Function not defined
    By johnmerlino in forum Excel General
    Replies: 3
    Last Post: 10-03-2010, 03:50 PM
  5. Compile Error: Sub or Function Not Defined
    By janderson in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-19-2006, 09:15 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1