+ Reply to Thread
Results 1 to 6 of 6

Userform Login Errors - Works with One, but not the Other! *** CODING ERROR ***

  1. #1
    Forum Contributor
    Join Date
    09-10-2008
    Location
    Phoenix, AZ
    MS-Off Ver
    Office 365
    Posts
    985

    Userform Login Errors - Works with One, but not the Other! *** CODING ERROR ***

    Hello,

    I am attempting to duplicate the command button that launches a Userform... The first Userform (frmCustInfo) Example post #1 below works fine, The second Userform (frmStaffUpdate) Example post #2providing errors.

    Example #1
    Please Login or Register  to view this content.
    Example #2
    Please Login or Register  to view this content.
    The second Example is highlighted in yellow at (frmStaffUpdate.Show) Runtime error - 424

    Any thoughts on this issue?

    Best Regards,

    John

  2. #2
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: Userform Login Errors - Works with One, but not the Other! *** CODING ERROR ***

    You do have a ' frmStaffUpdate' userform...?

    (Just covering the basics first).

  3. #3
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,171

    Re: Userform Login Errors - Works with One, but not the Other! *** CODING ERROR ***

    Yes, its the
    frmStaffUpdate.Show


    also Bad coding method: DONT USE COLONS
    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    09-10-2008
    Location
    Phoenix, AZ
    MS-Off Ver
    Office 365
    Posts
    985

    Re: Userform Login Errors - Works with One, but not the Other! *** CODING ERROR ***

    Yes - I duplicated the frmCustInfo - thought that simply duplicating the code and the userform - that it would work... the command button on the first first form works perfect - the second command button generates the error:

    highlighted in yellow at (frmStaffUpdate.Show) Runtime error - 424

  5. #5
    Valued Forum Contributor xlbiznes's Avatar
    Join Date
    02-22-2013
    Location
    Bahrain
    MS-Off Ver
    Excel 2007
    Posts
    1,223

    Re: Userform Login Errors - Works with One, but not the Other! *** CODING ERROR ***

    Are these buttons 68 and 69 placed in a worksheet or in a form ?
    Happy Computing ,

    Xlbiznes.

    To show your appreciation please click *

  6. #6
    Forum Contributor
    Join Date
    09-10-2008
    Location
    Phoenix, AZ
    MS-Off Ver
    Office 365
    Posts
    985

    Re: Userform Login Errors - Works with One, but not the Other! *** CODING ERROR ***

    Sorry everyone - the code works ok - I forgot the r in frm... My Bad - sorry

    John

+ 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. UserForm Error Message with Comments for Multiple Errors
    By Chaba in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-27-2014, 02:54 PM
  2. [SOLVED] Password for custom userform login only works with text passwords
    By Nitefox in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-23-2014, 06:45 PM
  3. Database crashing and coding errors
    By kjpain in forum Access Tables & Databases
    Replies: 10
    Last Post: 10-31-2013, 06:49 AM
  4. First time coding in VB, no errors but my very simple script isn't working. Help?
    By metajellyfish in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-17-2012, 05:01 PM
  5. [SOLVED] Works when stepped-through, but errors when macro ran
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-21-2006, 09:50 PM

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