Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Page 1 of 2 1 2 LastLast
Results 1 to 10 of 11

Thread: Excel VBA: Creating a Login Box

  1. #1
    Join Date
    20th April 2005
    Posts
    4

    Excel VBA: Creating a Login Box

    Hi,

    I was wondering if anybody could help me with making a login box (some tips on the script). I don't know much about VBA etc. So please bare with me. I want it so that when the workbook opens it prompts for a username and password. You can also have a button for "register" etc. Which will send you to a website. If this is possible please help.

    Thanks in advance!
    Hel.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    13th September 2004
    Location
    Boston, MA
    Posts
    455

    Re: Excel VBA: Creating a Login Box

    The redirect to a website can be accomplished through a hyperlink

    Why go through the hassle of a login box? Why not use the built in password protection of excel?
    Tony

  3. #3
    Join Date
    13th September 2004
    Location
    Boston, MA
    Posts
    455

    Re: Excel VBA: Creating a Login Box

    This should work for you.

    All passwords are currently "password"

    Post back if you need help.
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.
    Tony

  4. #4
    Join Date
    20th April 2005
    Posts
    4

    Re: Excel VBA: Creating a Login Box

    n1 m8, you helped loads.

    I will add you into my coursework bibliography and I hope you know that you just saved my life :P Literally >_< the ICT teacher was on my neck - ^_^ thanks again m8.

    Hizo.

    Ps - Hey m8, I was reviewing the code you used and I stumbled across something I didn't understand:
    VB:
    If password = WorksheetFunction.VLookup(UserList.Value, Range("Users_List"), 2, 0) 
    
    
    Ok Fair enough, you call the function vertical looktup but what are the "arguments"?

    I don't undestand (for some reason - probably missing something very obvious) what the "UserList.Value" part is refering to.

    Is it a cell reference? O.o

    Thanks in advance!
    Hizo

    pps - DOH lol i just got it, its refering to the username input box in Form1 isn't it? lol

    Ok, now Im confused again ;/ how does the list display? >_< lol sorry about this, I've tried reading one of those books, but I learn quicker through trial adn error :D

    ^^ thnks in advance again lolz
    Hizo
    Last edited by royUK; April 21st, 2005 at 15:53. Reason: add code tags, please use when posting codes

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    13th September 2004
    Location
    Boston, MA
    Posts
    455

    Re: Excel VBA: Creating a Login Box

    The list uses a named range from the "Protected" Sheet. Sorry I didn't document better but I was in the middle of something else and didn't have the extra time.
    Tony

  6. #6
    Join Date
    20th April 2005
    Posts
    4

    Re: Excel VBA: Creating a Login Box

    Hey nps :D!

    This is wicked as it is ^_^.

    I thought that when you rename a range, it changes, the name, but when in your document, it keeps its own name o.O lol Did that make sence?

    Hizo.

    Excel Video Tutorials / Excel Dashboards Reports


  7. #7
    Join Date
    13th September 2004
    Location
    Boston, MA
    Posts
    455

    Re: Excel VBA: Creating a Login Box

    Hizo,

    I am having a hard time following your posts. I don't keep up with the short hand of internet communication very much.

    The named range is actually a dynamic named range so it will grow/contract with additions/removal of items. You can only change the name by deleting and recreating. Under Insert > Name > Define.
    Tony

  8. #8
    Join Date
    20th April 2005
    Posts
    4

    Re: Excel VBA: Creating a Login Box

    I'm sorry mate. I'll speak more plainly :s its my messenger accent lol, its almost reflexive >_<.

    Thanks, I think you got what I meant though. I mean the code's perfect - thanks man

    Also in order to learn the code myself (and not simply leach off you) I was trying to implement it into my coursework :P leading to a very messed up work book. Lol, I didn't see where the Users_List was comming from. But now I do and you've solved my problem ^_^.

    Thanks!
    Hiz.

    Excel Video Tutorials / Excel Dashboards Reports


  9. #9
    Join Date
    14th March 2007
    Posts
    10

    Re: Excel VBA: Creating a Login Box

    Hi there,

    i have read your code about Excel VBA: Creating a Login Box and try to use it. but i have problem to update the password. after input new password and then click update password, pasword updated.
    but appear msg box : must use this form...... then file closed and password not updated.
    yesterday this code running well.
    can you help me to solve this problem ?

    Excel Video Tutorials / Excel Dashboards Reports


  10. #10
    Join Date
    26th January 2003
    Location
    Derbyshire,UK
    Posts
    18,314

    Re: Excel VBA: Creating a Login Box

    sekrup

    I suggest that you read the Forum Rules that you agreed to.

    Don't hijack other's posts with your questions, start your own, add a link to this one if it will help
    Hope that Helps

    Roy

    For free Excel tools & articles visit my web site

    If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

    RoyUK's Web Site

    royUK's Database Form

    Where to paste code from the Forum

    About me.

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. login to a Oracle Linked table and show the login...
    By mjschukas in forum Excel and/or Access Help
    Replies: 2
    Last Post: September 14th, 2005, 03:55
  2. Creating frames within an excel doc
    By bicanek in forum EXCEL HELP
    Replies: 5
    Last Post: May 23rd, 2005, 04:09
  3. Creating Excel pop up calendar
    By stuharri in forum EXCEL HELP
    Replies: 1
    Last Post: September 16th, 2004, 21:36
  4. Visual basic code for Excel Login Feautre
    By Stephen1987 in forum EXCEL HELP
    Replies: 1
    Last Post: January 16th, 2004, 23:39

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
  •  
porno