Excel Address Book With Image

%3CLINGO-SUB%20id%3D%22lingo-sub-2049826%22%20slang%3D%22en-US%22%3EExcel%20Address%20Book%20With%20Image%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2049826%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20the%20advanced%20address%20book%20we%20created%20%3B%3C%2FP%3E%3CP%3E-%20A%20new%20record%20can%20be%20added%20via%20textboxes.%20If%20this%20record%20has%20been%20saved%20before%2C%20VBA%20codes%20will%20give%20a%20warning.%3C%2FP%3E%3CP%3E-%20In%20column%20A%2CThe%20sequential%20numbers%20are%20assigned%20for%20each%20record%20.%3C%2FP%3E%3CP%3E-%20The%20record%20can%20be%20changed.%3C%2FP%3E%3CP%3E-%20The%20records%20are%20listed%20on%20the%20listbox%2C%20the%20details%20of%20the%20item%20selected%20from%20the%20listbox%20are%20displayed%20in%20the%20textboxes.%3C%2FP%3E%3CP%3E-%20User%20can%20search%20for%20the%20names%20of%20the%20records%20in%20the%20worksheet%2Cthe%20results%20found%20are%20listed%20in%20the%20listbox.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22addressbook-with-images.gif%22%20style%3D%22width%3A%20971px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F245297iEA89B07DA031601E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22addressbook-with-images.gif%22%20alt%3D%22addressbook-with-images.gif%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22graf%22%3EThe%20pictures%20can%20be%20added%20for%20the%20contacts%20in%20this%20address%20book.%20In%20Excel%20address%20book%20userform%2C%20the%20original%20size%20of%20the%20pictures%20is%20get%20and%20the%20picture%20can%20be%20viewed%20in%20its%20original%20size%20on%20another%20userform.%3C%2FP%3E%3CP%20class%3D%22graf%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22graf%22%3EDetails%20and%20sample%20files%20at%20%3A%20%3CA%20href%3D%22https%3A%2F%2Feksi30.com%2Faddress-list-with-pictures-in-excel%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EAddress%20book%20with%20image%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2049826%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Etraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

In the advanced address book we created ;

- A new record can be added via textboxes. If this record has been saved before, VBA codes will give a warning.

- In column A,The sequential numbers are assigned for each record .

- The record can be changed.

- The records are listed on the listbox, the details of the item selected from the listbox are displayed in the textboxes.

- User can search for the names of the records in the worksheet,the results found are listed in the listbox.

 

addressbook-with-images.gif

 

The pictures can be added for the contacts in this address book. In Excel address book userform, the original size of the pictures is get and the picture can be viewed in its original size on another userform.

 

Details and sample files at : Address book with image

0 Replies