Startside Op Feedback Indhold Søg 

Forklaring UK
Forklaring DK Forklaring UK Bestil_fil

 

 

 

Her er en forklaring til hvad hver enkelt fil kan hjælpe med at udføre:

File No Categori Sub categori Explanation Excl  VBA Code
36 User General The user can input/change/erase data in a database "Databasen" which is placed in an excel-sheet by clicking on a button in the sheet "Demo". The input is done through an Userform No
33 User Assistance Through the VBA-code a userfunction has been made "=checktal(xxx)". This function makes it possible to convert normal numbers into numbers spelled out in words, like used on cheques. The code contains the words in danish - but it is easy for you to edit t No
54 User Assistance Shows listboxes used between two files, file 1 has the basic data and file 2 is using those Yes
2 User Assistance In this file the user do not have to input the ":"-sign in timedata like 09:00 AM No
56 User Assistance In this file the useren do not have to input the "  -  -  "-signs in dates No
32 User Assistance Simular to file no 33 but converts normal numbers to romam numbers like "XXVI". No
11 User Assistance Shows a chart with projekt titles, startdates, duration and enddate. Yes
27 User Assistance A userfunction is made - and with matrixformlulars - that automatically splits the difference between two dates into number of days, months, years No
49 User Assistance Shows the actual dates and running time in a sheet No
38 User Kontrolling By a button in the "Sheet1" 3 examples of controlling the userinput is demonstrated; number of characters in a cell, a number must be a fixed min. and that a number can be transformed into a date No
37 User Kontrolling Excel's own validation is demonstrated in this file Yes
26 User Orientation for Many times the user must belive in that the macro really is doing something.
Here is some examples on how to inform the user about how things are going along		 No
28 User Orientation for Many times the user must belive in that the macro really is doing something.
Here is some examples on how to inform the user about how things are going along		 No
29 User Orientation for Many times the user must belive in that the macro really is doing something.
Here is some examples on how to inform the user about how things are going along		 No
21 File_Cell_Range General This example erases all empty rows in a sheet No
39 File_Cell_Range Cell Example in Excel's own datavalidation Yes
5 File_Cell_Range Cell Different ways in showing the user if the value of a cell is negative No
6 File_Cell_Range Cell Different ways in showing the user if the value of a cell is negative No
7 File_Cell_Range Cell Different ways in showing the user if the value of a cell is negative No
8 File_Cell_Range Cell Different ways in showing the user if the value of a cell is negative No
16 File_Cell_Range Cell Userfunctions that returns the values in the last row or col No
17 File_Cell_Range Cell Userfunctions that returns the values in the last row or col No
43 File_Cell_Range Cell Moving the "-"-sign from the end of a exported number to the start so that the numbers can be used in Excel No
66 File_Cell_Range Cell Control wether a given cell is marked No
68 File_Cell_Range Cell Runs through the file and finds a certain cell value No
69 File_Cell_Range Cell Sorts and find the highest date in a col No
70 File_Cell_Range Cell Finds the address on the active cell No
72 File_Cell_Range Cell Change format on numbers to text No
74 File_Cell_Range Cell Erases alle cells with a certain value No
75 File_Cell_Range Cell Erases cells with the same value No
76 File_Cell_Range Cell Sorts a col according to the presence of the datanumber No
25 File_Cell_Range File Sorts all sheets in alphabetical order No
9 File_Cell_Range File Both files find *.xls files in directories but in two ways One only in the present directory, the other in a directory according to what the user has put into the code. The files will be listed in col. "A" in "sheet1". The directory when you download the  No
10 File_Cell_Range File Both files find *.xls files in directories but in two ways One only in the present directory, the other in a directory according to what the user has put into the code. The files will be listed in col. "A" in "sheet1". The directory when you download the  No
44 File_Cell_Range File In the first file the files itself will be saved without alerting the user. In the second file the file can be saved with a specified name including the date No
45 File_Cell_Range File In the first file the files itself will be saved without alerting the user. In the second file the file can be saved with a specified name including the date No
42 File_Cell_Range File Here you have a sheet with 10 col and 10 rows that is put into TXT-format in a file No
63 File_Cell_Range File Here it is possible to get the sheets named according to a list in a sheet No
1 File_Cell_Range Range If you have a col with a lot of data in it, it may be difficult to read. This example colors every second row grey. No
3 Chart   A "living" chart line No
4 File_Cell_Range Range Exampel where you through VBA finds the range for print No
12 Toy   A little bit of fun. Here you get figures drawn in a sheet to rotate when you click them No
13 General   Handy little tool that makes a list of all install fonts No
14 Toy   Gives the opportunity to give the user a verbal help or ... No
15 Toy   Through the code Excel will play a little wav-file. Remember to download the wav-file too No
64 File_Cell_Range File The name of the user may be put into the line in the active window, top left No
71 File_Cell_Range File The user may move a file from one dir to another as mentioned in the code No
73 File_Cell_Range File Every second row is marked in Bold No
30 Pivot   The result of a pivottable is being used as base for a chart Yes
18 File_Cell_Range Range 3 different ways of refering to a range, please choose the one that fits you the best No
19 File_Cell_Range Range 3 different ways of refering to a range, please choose the one that fits you the best No
20 File_Cell_Range Range 3 different ways of refering to a range, please choose the one that fits you the best No
34 General   From time to time it may be difficult to limit one self, so it is nice if you can find out which sheets/files the present file is liked to. In this example you may erase the link etc or not No
35 Toy   If you ever should want to see what colors a picture in col "A" is made out of, then you cannot live without this No
22 Chart   This one makes it easy to add a new col.'s data to a chart No
23 General   2 examples of importing a textfile. The first imports without user doing anything and the second allows the user to decide what to do. No
24 General   2 examples of importing a textfile. The first imports without user doing anything and the second allows the user to decide what to do. No
53 General   Copies filtered data either to a new sheet or file No
40 General   The first example makes it possible to change the date format from ÅÅ-MM-DD to DD-MM-ÅÅÅÅ. The second example does the same, but the user may change the format No
41 General   The first example makes it possible to change the date format from ÅÅ-MM-DD to DD-MM-ÅÅÅÅ. The second example does the same, but the user may change the format No
55 General   Try your luck with this if you are gambling in the Lotto - no guarantee for a winn ofcourse No
52 General   If you refund travel (driving) a lot then this example might be of use for you, it makes it easy to pay for the same number of kilometers, driving distances etc Yes
50 General   Finds a certain number of the largest numbers in a col Yes
51 General   Sums up a col of numbers according to criterias Yes
57 General   After clicking the button the file will close after 10 sec No
48 General   Get the formular in cell A10 shown in cell B10 by this code No
46 General   This litte one adds some very used icons to my toolbar No
47 General   Remove dublets (the same number mentioned two or more times) from a row so that only one item of the number is left in the sheet.
Remove dublets (the same number mentioned two or more times) from a row so that only one item of the number is left in the s		 No
58 General   Prints automatically all the unique sets of data in a autofiltered range No
59 General   If you f.ex. have customerno. in col. A you can get the same customer number colored in the same color in this example No
60 General   All red, black and blue numbers are added together in totals for the red, blue and black ones No
61 General   If you input the starting date of a month a day plan is automatically made Yes
62 General   Converts alle formulars and links to values No
65 General   Control that the directory mentioned in the code is on the harddisk No
67 General   Controls wether the sheet mentioned in the code is in the file No
31 Pivot   Example in consolidation of three product done by a pivottable Yes
77 File_Cell_Range File New sheets gets numbered in row No
78 General   Makes an autofilter and prints results one after one No
79 File_Cell_Range Cell Changes the value between two cells No
80 General   Controls if a certain dir exist No
81 File_Cell_Range Range Informs the user which col that is active No
82 General   Finds the time it takes for the macro No
83 File_Cell_Range Range Finds and renames ranges in a sheet No
84 File_Cell_Range Cell Kombines the value of cells No
85 File_Cell_Range Cell Finds and erases data No
86 File_Cell_Range File Generate random numbers without repeating one No
87 File_Cell_Range File Goes from sheet to sheet in the file No
88 File_Cell_Range File Makes all combinations from agiven list in a col No
89 File_Cell_Range Cell Remembers the cell that you came from No
90 General   Get the autocorrecturlist into a sheet No
91 General   List's all files from a given dir into a sheet No
92 File_Cell_Range File Input data in all sheets at once No
93 File_Cell_Range File Controls if the sheets-named in a list in a sheet is in the file No
94 File_Cell_Range File Controls if it is a nomal sheet or an chartsheet No
95 File_Cell_Range File Copies the present sheet x-number of times No
96 File_Cell_Range Range Copies the visible cells into an other sheet No
97 General   Copies data mentioned twice into an other sheet No
98 General   Copies data from one sheet into an other according to criteria No
99 User Orientation for Informs the user what sheet(s) that is active No
100 File_Cell_Range Range Collects data in col A and B an erases the original data No
101 General   Changes the place of caracters No
102 General   Controls if the file exist in the present dir No
103 General   Autofilters and copies to sheet and name theese No
104 User General Search according to the user input and mark it No
105 File_Cell_Range File Search for a specific file in a specific dir No
106 File_Cell_Range Cell Search numbers in sheet1 and put references in sheet2 No
107 File_Cell_Range Cell Remove formulars with error-values No
108 File_Cell_Range Cell Erases repeated values in cells below No
109 File_Cell_Range Cell Insert text in more than one line in a single cell No
139 General   Hides the present file and activates an other open file No
140 General   Autofilter according to criteria in the code and place in new sheet(s) accordingly No
141 General   Sheetprotection on/off with password No
142 File_Cell_Range Cell Use a cells value as criteria for autofilter No
143 General   Mark values mentioned twice with color and copy them to sheet2 No
144 File_Cell_Range Range Changes cells with #ERRORS in them to 0 No
145 File_Cell_Range Range Filtered data is copied to new sheet that gets the name of the criteria No
146 File_Cell_Range Cell Search after the column header mentioned in the code and place the cursor in that column No
147 File_Cell_Range Range Finds values mentioned twice in col. A and erases for 4 col No
148 File_Cell_Range Range Copies data from sheet1 to sheet2 and inserts a blank row No
149 General   Goes to the sheet before this No
150 General   Inserts a new row UNDER the active cell No
151 General   Copies a range from the active file to a new file reserving a blank line No
110 General   Go from sheet to sheet through a macro No
111 General   Saves  a sheet from the present file under today's date No
112 General   Saves a single sheet in a file according to the user No
113 General   Insert an autofilter in more than one sheet No
114 General   Inputs data i specific rows No
115 File_Cell_Range Range Compares col A and B, tranfers data mentioned twice to col C No
116 User Assistance Makes the user aware that a sort must happend No
117 File_Cell_Range File Copies between dir's, checks if the file allready is present No
118 File_Cell_Range Range Copies a choosen part to a new file No
119 File_Cell_Range Range Copies a specific number of data between sheets No
120 File_Cell_Range Range Copies specific data to a new file as last sheet No
121 File_Cell_Range Range Copies the value of celle A1 into more cells No
122 General   Copies data incl the formats of row and column No
123 General   Makes small lines of text No
124 General   See the excel colors and ref.no No
125 General   Close all files and if you want, Excel itself No
126 General   Close the file with or without SAVE No
127 General   Close the file and erase it from the harddisk No
128 General   Change the filedate according to the user No
129 File_Cell_Range Cell Mark the cell with the highest value, see file no. 131 No
130 File_Cell_Range Range Mark cells to the right of the active cell No
131 File_Cell_Range Cell Mark the cell with the maximum value, see 129 No
132 File_Cell_Range Range Marks a certain number of rows according to the user No
133 General   Moves the names for ranges into the comment field No
134 General   Splits a text into each caracter in each new cell No
135 File_Cell_Range Cell Hides the cells marked in red in a col No
136 General   Sum's rows according to the user No
137 General   Random numbers/values No
138 File_Cell_Range Range Specify, in col. A,  the highest value in a range No
152 File_Cell_Range Range Combines sheet1 and sheet2 to sheet3 without repeating data No
153 File_Cell_Range Range Transfer the value of special choosen cells No
154 File_Cell_Range Cell Copies a formular according to the number of rows in the column to the left No
155 File_Cell_Range Range Erases/copies data with the letter "a" No
156 File_Cell_Range Range Copies a range to an other range directly mentioned in the code No
157 File_Cell_Range Range Copies every second row, starting with the row decided by the user No
158 File_Cell_Range Range Copies according to 2 criteria, number and text No
159 General   State a dir and get the dir's under that No
160 User Assistance Insert 12 sheets (the month's) and limit the kind of userinput to them No
161 General   Copies ONLY the number out of celle without f.ex. the color of them No
162 General   Copies if the column A has a numeric value No
163 File_Cell_Range   Automatic transfer of data to another sheet No
164 General   Makes it possible to state the height of row in cm No
165 File_Cell_Range Range Search for a special cell value and put in sheet2 with a reference No
166 General   Given a firstletter = a specific number No
167 General   Makes it possible to add items to the autocorrecturlist in Excel No

Please send an e-mail to alan(@)alanexcel.dk if you have questions/remarks about this site.

 

 

Send e-mail til alan(snabel_a)alanexcel.dk med spørgsmål eller kommentarer om dette Websted.
Copyright © 2005 AJ Service
Senest opdateret: 23. november 2011