+ Reply to Thread
Results 1 to 9 of 9

ADD number for attempts

  1. #1
    Registered User
    Join Date
    05-04-2015
    Location
    ARMENIA
    MS-Off Ver
    office 2010
    Posts
    79

    ADD number for attempts

    Hello forum
    Hello every one
    Please how to do make for add in Label2 UserForm2 the number of false attempts .. and appears the UserForm2 after false attempt
    Thank you very much in advance for help me
    Cordially
    MARTI
    ADD number attempts.xlsm
    Last edited by Mart Marti; 10-23-2015 at 05:35 AM.

  2. #2
    Registered User
    Join Date
    05-04-2015
    Location
    ARMENIA
    MS-Off Ver
    office 2010
    Posts
    79

    Re: ADD number for attempts

    Hello every one There is not any idea please
    Cordially
    MARTI

  3. #3
    Registered User
    Join Date
    05-04-2015
    Location
    ARMENIA
    MS-Off Ver
    office 2010
    Posts
    79

    Re: ADD number for attempts

    Hello Forum
    Hello every one
    There is not any idea please
    Cordially
    MARTI

  4. #4
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: ADD number for attempts

    Hi MARTI,
    maybe so (see attachment)
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    05-04-2015
    Location
    ARMENIA
    MS-Off Ver
    office 2010
    Posts
    79

    Re: ADD number for attempts

    Hello forum
    Hello nilem
    Hello every one
    Thank you but even I write a correct password I can not access the file
    Cordially
    MARTI

  6. #6
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: ADD number for attempts

    Try "marti2" and password "222"
    Login "marti1" became locked until I tested the code

  7. #7
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: ADD number for attempts

    You attached a closed self-password protected workbook, without the log-in data.
    It appears that you also used the RowSource property to fill the username combo box, making it incompatible with my Mac. (Mac doesn't support RowSource)
    You also make the max length of the ComboBox 0, so I can't type in the username "Marti1".
    The workbook that you posted isn't compatible with Macs. I hope that none of your clients own one.

    Having said all that, to answer your question
    To get the label to show how many attempts are remaining, you could put this line before the "try again" msgbox in the CommandButton1_Click code.
    Please Login or Register  to view this content.
    You might want to try this,
    Open the attached file, selecting Disable Macros on the opening dialog.
    Create a new workbook.
    Put this code in the new book, and run it.
    Please Login or Register  to view this content.
    Excel is not a secure platform. IMO, time spent trying to keep data secret in an Excel file can be better spent drinking beer.
    Last edited by mikerickson; 10-24-2015 at 03:52 PM.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  8. #8
    Registered User
    Join Date
    05-04-2015
    Location
    ARMENIA
    MS-Off Ver
    office 2010
    Posts
    79

    Re: ADD number for attempts

    Hiiii nilem
    thank you very much for help
    Yes that's exactly what I want
    Thank you so much for you precious time sacred for help me
    I only have this little problem last .. also display number false attempts in Label1 UserForm1
    Thank you in advance for help
    Cordially
    MARTI
    t1.gif
    3.jpg
    Last edited by Mart Marti; 10-26-2015 at 06:46 AM.

  9. #9
    Registered User
    Join Date
    05-04-2015
    Location
    ARMENIA
    MS-Off Ver
    office 2010
    Posts
    79

    Re: ADD number for attempts

    Hiii mikerickson
    Thank you very much for help
    I'll try to do what you tell me aver
    Cordially
    MARTI
    t3.jpg

+ 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. LOGIN 3 attempts and historical sheet
    By Mart Marti in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-05-2015, 05:14 PM
  2. [SOLVED] Index and Match for 4 Criteria - My 2 attempts are not working
    By denise001 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-05-2013, 01:55 PM
  3. Alert if User Attempts to Delete Row Containing Named Range
    By AlvaroSiza in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-28-2013, 12:04 AM
  4. Adding Password Attempts
    By s45yth in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 06-14-2011, 02:45 PM
  5. Count Unprotect Sheet Attempts
    By mstuj in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-27-2010, 10:00 AM
  6. Detecting Copy/Paste attempts on a form.
    By starcrwzr in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-28-2009, 06:38 PM
  7. avg # attempts before failure
    By illinigator in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-25-2009, 04:46 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