Employee Database With Images

Excel Personnel Database With Images

excel personnel database

        📖 In our template, the employee information is entered into columns in the first sheet.On the other sheet,the recorded entries can be displayed in rows (vertically) in a column .
        We added a listbox, textbox, spinbutton controls to the report worksheet. When this sheet is active, the names of the employees  are populated to listbox :
lrow = Sheets("Data").Range("B" & Rows.Count).End(xlUp).Row
ListBox1.List = Sheets("Data").Range("B2:B" & lrow).Value 

          If item of listbox is clicked, the employee's informations are displayed on rows in the sheet (e.g employee’s image,staff no, job title, date of employment).
With spinbutton can be navigated between items of the listbox ,any value can be searched with textbox.