PDA

View Full Version : Textbox entry search populates into listbox I'm stuck on how to make the VBA code



djwazz
04-12-2017, 11:10 PM
I have a user form that hides the spreadsheet so I going to create a second userform which users that don't have password to access the spreadsheet can still with draw data from it by searching first and last name once they hit search it populate results into a list box. Please see sample spreadsheet attached.

Sorry I haven't written any code I'm quite new to the VBA world and starting think my idea couldn't be done until I found this site.

I be over joyed if someone could help me and make it work. :yes

Thank you in advance I hope one day I get better at this as I go along trying new things. 18922

The spreadsheet is basically used as an Active Directory records sheet.

Also the exit spreadsheet password been removed so it just blank hit ok and it go past that window.

List box I like it to show details for that user all info that on the row or if that to much data to populate just to see - office, Company, manager name, extension number, sharedmailbox.