| klste@hotmail.de |
Examples in pictures
1 File has only 3 sheets.
2 Few new sheets are added. The new worksheet can edit program.
3 Activate worksheet. The headings for 14 columns, which you can edit, are located in the line 7.
4 With arrows, right, left, up down you can turn the rows and columns on the active sheet.
5 Text fields with yellow background color have search function.
6 Create new record and enter. The data in the record is transferred as numbers or text, running above number is assigned automatically.
7 An entry is changed.
8 Search term Share company. All entries with Word Share company in column F (Extension) are transferred to select worksheet (AUSW).
9 An entry is deleted.
10 Everything will be deleted.
|
Help database in Excel creation and manipulation of databases on the basis of Excel 2010 file
|
|
This, with VBA code programmed Excel file, provides the following benefits:
1 Central management unit, which is the form, from which you enable everyone in the existing worksheet Excel file to edit it or evaluate any search term.
2 The input mask contains no redundant control elements, as a result is very compact, uncluttered and not very big, what allows to use this program also in small notebooks.
3 The competent authority for entries controls (text boxes) accommodate enough for long words or short phrases.
4 The controls are easy to activate tab, enter, enter key, or mouse.
5 Three textboxes have search function, while writing the post verifies it, whether there are already such data on the sheet.
6 The input mask offers comfortable and fast navigation as for whole file in the selected sheet.
7 The program transmits entries in the text or number format in area from row 9 to row 1048575 (1048566 entries per sheet are possible), from column A to column N.
|