Contact E-Mail address:klste@hotmail.de

 

 

 

 

Print address labels in Excel VBA

 

With the help of this program you can quickly print an address label of a selected person. The program is an Excel file which is programmed in VBA. The file consists of three worksheets: Mask, Sheet and Address label.

In the program everything is done from an input mask, which is activated in the "Mask" worksheet with the "Mask" button.

Personal database is edited from the mask.

In the worksheet "Sheet" there is a copy of the database, which is created with the "Sheet" button.

In the mask with the "Address label" button, the form is called, in which it is determined which data of the person should be in which cells of the "Address label" worksheet. All selected data can be in the range A1: K30. The unselected data will not appear in the address label.

The "Address label" worksheet can be formatted by hand at any time.

If an ID no. is selected, the "Print" button is visible. After clicking this button, the "Address label" worksheet will be activated. Address labels contain data from the selected ID number. and the print menu appears. After the printing process has been canceled or carried out, the combo box "Customer No." will be empty and the "Print" button will be invisible.

A search engine is built into the mask. If the text field "Search:" shows what is entered, the "Find" button appears. After clicking the button, the entire database is searched for the search term entered. The search term should be the entire content of a cell (a whole word or number), it is not searched for single letter or number

At the end of the search process, the program creates a list with all ID numbers where the searched word or number occurs.

In the mask in the list field, the column widths adapt automatically to the column widths of the person database shown. Each ID number can be selected in the list box by double-clicking the left mouse button.

The program automatically creates from every address Consecutive ID no. In the database there is space for 100,000 people ID no. The program can use any selected ID no. or delete entire database. Before deleting, you will be asked for a password, this is the number 3.

The program is an Excel file and only works if correct Excel, from Excel 2007 and higher, is installed on the PC.