Listbox in Visual Basic

Posted on 2009-12-17
Last Modified: 2012-05-08
I have created a vistors signing in system in excel/visual basic. When someone puts their details in the textboxes and clicks sign in it fills cells in the excel spreadsheet.

What i want is a userform which displays a listbox of people who are signed in on the current date.

Basically if the 'J' cell shows 'true' and if cell 'G' has todays date in it, then The value of cell 'A' and 'B' to be shown in the list box.

Then the user can click his/her name in the listbox, click 'sign out'. That will change value of cell 'J' to 'false'.

Any help would be greatly appreciated.

Many Thanks

David Ryder

Question by:Didsi
    LVL 45

    Expert Comment


    Please upload your file after you have made the names anonymous - only a small sample of names is needed.


    Author Comment

    wont let me upload file as macro enabled so the button on sheet 1 will not work.

    'Userformstart' is the main userform which will be displayed.
    'Userformsignout' contains the listbox where i would like the list to be displayed.
    LVL 8

    Accepted Solution

    Please see the attached xls file.
    It contains 'Sign Out' button on Sheet 2.
    Hope this is what you want.


    Author Closing Comment

    You are amazing!!!!  That is perfect. Thank you very much

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
    I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
    The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
    This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now