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.