Didsi
asked on
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
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
ASKER
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
'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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
You are amazing!!!! That is perfect. Thank you very much
Please upload your file after you have made the names anonymous - only a small sample of names is needed.
Patrick