Home > Excel Tutorial > Excel Employee Database With Pictures

Excel Employee Database With Pictures

        In the study, 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 to the report sheet. When this page 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 “

Watch the tutorial’s video: 
excel employee database with images

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.

Example workbook can be downloaded here

  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: