Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 314
  • Last Modified:

Listbox in Visual Basic

Hi,
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



0
Didsi
Asked:
Didsi
  • 2
1 Solution
 
patrickabCommented:
Didsi,

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

Patrick
0
 
DidsiAuthor Commented:
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.
Visitor-System.xlsx
0
 
VipulKadiaCommented:
Please see the attached xls file.
It contains 'Sign Out' button on Sheet 2.
Hope this is what you want.

Visitor-System.xls
0
 
DidsiAuthor Commented:
You are amazing!!!!  That is perfect. Thank you very much
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now