Employee Database With Images

[kadrleyn]

In the workbook, 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 using vba codes :
"lrow = Sheets("Data").Range("B" & Rows.Count).End(xlUp).Row
ListBox1.List = Sheets("Data").Range("B2:B" & lrow).Value “

Example file can be downloaded here

 

[Derek McGill]

I think your posts should be in "The Vault" as you are not looking for help.

 

[Logit]

Nice project ... however, the changing of the employee photo does not work as desired. Might want to take a look at that.