Holy Macro! It's 2,500 Excel VBA Examples

This CD is packed with 2,500 Excel Workbooks. Every workbook contains a question, such as How do you display the complete file path in the print header? along with the answer and the VBA code necessary to make it work.

Originally published by Microsoft MVP Hans Herber in German. This CD is a best-seller in Europe. Painstakingly translated to English by the MrExcel team. Every example is completely indexed and searchable.

 

Holy Macro! It's 2,500 Excel VBA Examples AMAZING collection of 2,500 VBA examples in a question-and-answer format. Every snippet of VBA you will ever need!

This CD is packed with 2,500 Excel Workbooks. Every workbook contains a question, such as How do you display the complete file path in the print header? along with the answer and the VBA code necessary to make it work.

 

Originally published by Microsoft MVP Hans Herber in German. This CD is a best-seller in Europe. Painstakingly translated to English by the MrExcel team. Every example is completely indexed and searchable.

 

The 2500 VBA Examples CD is an amazing resource. A joint project between Germany's Hans W. Herber, Tom Urtis, and MrExcel, the CD is the most comprehensive reference on Excel VBA available today. Check out the solutions available on the CD.

API-Calls

•           Change of Excel and workbook icons - Changing the Application and workbook icons to own creations.

•           Determine current mouse position - The current mouse position shall be determined.

•           Check, if a RAS/Internet connection exists - The existence of a RAS/internet connection shall be checked.

•           Determine Windows temp file folder - The Windows-temp directory is to be determined.

•           Open and close a CD-drive - How can I open and close the CD-drive via VBA?

•           Play wav files and stop with ESC button - How can I replay a wav file ten times and interrupt the string with the ESC key

•           Set status of NumLock, CapsLock and ScrollLock buttons - How can I check and set the status of the NumLock, CapsLock and ScrollLock keys with a UserForm-CheckBox?

•           Select first CD-ROM drive - How can I detect the first CD-ROM drive.

•           Select disk memory - How can I read the hard drive memory?

•           Hide/Unhide header of UserForm - The title bar of a UserForm is to be hidden so that the form cannot be moved around the screen.

•           Read out the Screen Resolution - How can I ascertain the actual Screen Resolution?

•           Switch off the Computer - How can I switch off the Computer when I press a Button?

•           End Windows - How can I end Windows when I press a Button?

•           Ascertain the running time of Windows since the last start - How can I ascertain how long Windows has run since the last start?

•           Call an Application and interrupt the MacroExecution - How can I call another Application via a VBA-Program and interrupt the MacroExecution until the other Application finishes?

•           Hide the Excel-Menu on the left top of the window - How can I hide the Excel-Menu on the top-left of the window and deactivate the END-Button in the FILE-Menu?

•           Read out an EnvironmentVariable of the Autoexec.bat - How can I read out an EnvironmentVariable of the Autoexec.bat?

•           Change the script of the Status Bar - How can I change the font of the Statusbar?

•           Call a Tree and select a Directory - How can I view the Tree and select a Directory?

•           Show a Picture for a period of less than 1 second - How can I view a Picture in a Worksheet for a period of less than 1 second?

•           Read out the ComputerName - How can I ascertain the Name of the Computer?

•           Show the Userform in the VB-Editor - How can I change to the VB-Editor when I start an UserForm?

•           Send the contents of a Workbook as Mail (but without the Workbook itself) - How can I send the contents of a Excel-Worksheet as a Mail without sending the Workbook itself?

•           Read out a hard disc-serial number - How can I read out the serial number of the hard disc?

•           Read out the position of the Mouse - How can I read out the position of the Mouse in Points?

•           Read the Input out of the Win.ini - How can I read the Value "Street" out of the section "Data2" of the Win.ini?

•           Display the UserName from the Windows registry - How can I display the User Name from the Windows-Registry?

•           Play a WAV-File in Excel8 - How is a WAV File played instead of a default error sound?

•           Determine the Windows directory. - The Windows directory shall be determined.

•           Windows directory and Operating System - Determine the Windows directory and operating system.

•           List installed printers - List the printers that are installed for this computer.

•           Windows wallpaper - Set the Windows desktop wallpaper.

•           Menu bar - Place a digital clock in the Menu bar, with the ability to delete it also.

•           Display the Common Dialog using API - Display the Common Dialog using API calls, instead of the standard VBA-induced Open dialog.

•           Pause a macro to open Notepad, then resume macro - Pause a macro in mid-execution in order to open Notepad and perform some action. When you close Notepad, the macro will resume where it was in its execution when Notepad was called.

•           Username directory and name - A user defined function returns the folder path of the username's directory and name in cell A1.

•           Obtain window title of an application. - In cell B2, the window title of the application specified in cell B1 is displayed.

•           Application window blink - How can I force the Excel application window to blink once?

 

Arrays and Array Functions

•           Temporary use of VBA in a matrix formula - The values from column C are to be summarized by criteria with the temporary use of a matrix formula

•           Total up numbers with considering of month and year - Entries for the respective month in area A1:A100 are to be counted with consideration of the year

•           Calculate values from a measuring table - According to criteria in cells G2:G3, the total of column D is to be calculated.

•           Read files with user defined matrix functions - Values form area A2:B4, if they are equal or higher than 5, are to be exported with a matrix formula

•           Count of values with various conditions - The number of matching data in table A4:C405 with criteria in area A2:C2 shall be read.

•           Total up hours and minutes separate - Total up the first and last cells in the sports results from column B

•           Sums with consideration the upper and under limit - How can I check Column A with Values with set upper and lower limits and add up the Cells right of it?

•           Redimension of an Array through several Dimensions - How can I avoid an Array Re-dimension only being permitted with the exclusive last Data-Area Dimension is changed?

•           Ascertain the number of matches in two Areas - How can I ascertain the Values that appear on the same position in two Areas?

•           Ascertain number of 2 criterias with the D-Function and MatrixForm. - How can I ascertain the number of RecordSets using two Criterias?

•           Ascertain the number of the Weekdays in a set period - How can I ascertain the number of Weekdays in a set period?

•           Search for a Value in an Array without query each DataField - How can I search for a Value in an Array without asking each DataField?

•           Handling Arrays in userdefined Functions - How can I handle Matrixes in userdefined Functions? How are individual Values returned?

•           Fit in the FolderName of a Directory in a Cell - 736/99 Subject:Fit in the FolderName of a Directory in a Cell Question Date:12.06.99 Topic:Matrix Version:Excel5/7, Excel8 question:How can I ascertain the FolderNames of a cell written DirectoryName via an userdefined Function?

•           Take the Values of a CellField in a Matrix and read it out - How can I read in a CellField of a Worksheet in a Matrix and read out the separate CellContents afterwards?

•           Sort Boxes in an multidimensional matrix - How can I sort the elements o a multidimensional array in ascending order?

•           Select Values according to two Criterions - How can I sum the Values according to two Criterias? Countif and Sumif only allow one.

•           Calculate a Matrix new - How is a Matrix recalculated after adding or deleting of Numbers?

•           Output of an userdefined Function in a MatrixFormula - How can I make a userdefined Function give out several results?

•           List the DistanceMatrix - How can I translate a DistanceMatrix into a List?

•           Sum the Values of a certain month - How can I determine the Sum of the Values of a certain month when I have entered the days of a year in the Date Format in Column A and a Value for each day in column B?

•           Total of Products - I have a Worksheet with the Columns "Article", "Price" and "Quantity". How do I calculate the Total of the Products of Price and Quantities for specific Articles?

•           Divide a multidimensional matrix into separate linear arrays. - Divide a multidimensional matrix of 12 months in serial number format into two separate linear arrays.

•           Entry of array formulas in a month and year matrix. - Macro to enter array formulas that sum values in a matrix of dates.

•           Array formula to return quantity of days - The array formula in cell A1 returns the number of January days in 2002 that are listed in column A of Sheet2.

•           Add numbers on each side of a character. - Add numbers to the left and right of the colon character.

•           Array and non-array formulas - Two formula approaches (array and non-array) to count the quantity and sum of values that fall between the numeric maximum and minimum ranges in cells C1 and C2 of Sheet1.

•           Determine a value based on two criteria - A value is returned from a table based on two criteria.

•           Count the match of dual criteria. - In cell A1, the array formula returns the number of times a dual criteria match is met.

•           Array formula sums values within starting and ending dates - The array formula on Sheet1 uses a start date and end date (each as a named range) from the table on Sheet2 to sum the values in column B whose dates in column A fall within those start and end date ranges.

•           Populate and split an array - A linear array is to be filled with the numbers from 1 to 100, and be divided into a multidimensional range of 4 columns and 25 rows.

•           Conditional format and array formula - The cells in the table range A3:AW15 are conditionally formatted to be shaded yellow when their values match the criteria value range in E19:J19.

•           Array formula to match and sum values in respective columns - Use an array formula in column J that involves the occurrence of values in columns D, F, G, and I that match the value of each record in the cell of its respective column.

•           Values summed in row at intervals - Each cell in row 1 contains numbers from 1 to 256 that are summed at intervals set in a criteria cell.

•           Costs by month, department, and purpose are calculated and cross-checked - Costs by month, department, and purpose are calculated and cross-checked

•           Summary distribution by month - How can I summarize daily activity for 5 employees by month using array formulas, not VBA?

•           Alert for non-specified value in range - What formula can I employ to alert me when a non-specified value exists in a range?

•           Count days in each month between start and end dates - How can I compose a set of 12 array formulas that return the number of days for months that fall between a start date and an end date?

•           Multiply a sum of elements - How can I sum each numeric element in an array, and multiply that product by each element?

•           Average numeric array elements based on two criteria - I have a 3-column array. How can I return the average of numbers in the third column whose elements in column 1 and column 2 match two specified criteria?

•           Sum and count array elements with two criteria - I have a two-column array. How can I sum the numeric values in column 2 and count how many numeric elements I am summing, based on a Ceiling and Floor criteria for corresponding elements in column 1?

•           Comparison of sets of elements - I have a four-column array. How can I determine how many elements' values agree between column 1 and column 3 compared to column 2 and column 4, and between column 1 and column 2 compared to column 3 and column 4?

•           Sum array elements based on two criteria - I have a two-column array, where column 1 is a list of dates and column 2 is numbers. How can I sum the numbers in column 2 whose date in column 1 is of a specified year and month?

•           Minimum array element value - How can I determine which numeric element in column 2 of a two-column array is the minimum value among the other elements like it whose corresponding value in column 1 matches a pre-set criteria?

•           Minimum quotient from multiple column array - I have a multiple column array, where the numeric elements in row 2 are divided by the numeric elements in row 3. What formula can identify which non-error quotient is the smallest (minimum) value?

•           Count empty and occupied array elements - I have a two-column array, with some cells occupied and some cells empty. How can I count how many records in the array are occupied with both elements, and how many where both elements are empty?

•           Sum based on date criteria - I have a two-column array, with dates in column 1 and numbers in column 2. How can I sum only those numbers in column 2 whose dates are less than or equal to six months prior to the current date?

•           Row and address of found element in array - I have a single column array with unique values. How can I return the row and address of a given value?

•           Average of numeric array elements based on criteria - I have a two-column array, with recurring values in column 1 and numeric values in column 2. How can I average the numeric values whose element in column 1 matches a given criteria?

•           Last row with data - For a given range on my worksheet, how can I determine what the last row is that displays data?

•           Count and sum array elements based on two criteria - I have a three-column array. How can I sum and count the numeric elements in column 3 based on two criteria that need to be met - - one for column 1 and one for column 2?

•           Count elements between Floor and Ceiling criteria - How can I count the elements in an array that fall between and including Floor and Ceiling set of criteria?

•           Sum numeric array elements based on character string criteria - I have a two-column array, with column 1 containing text and column 2 containing numbers. How can I sum the numbers where the column 1 text begins with a two-character criteria I specify?

•           Count weekdays between dates - What formula can tell me how many times a given weekday will fall in between two dates?

•           Count frequency of character in a string - How can I count the number of times a given character exists in a string?

•           Average numeric array elements between Floor and Ceiling criteria - I have a single column array of numbers. How can I identify and average the numbers that fall within and including a specified set of Floor and Ceiling criteria?

Built-in Functions

•           Capital gain with fixed and variable rates - Capital gain with fixed and variable rates

•           Determine travel times from a travel matrix - How can I determine the valid departure time with entering two criteria in a travel matrix

•           Insert values depending on worksheet name - Data from the sheet named in cell B2 is to be inserted in area A1:D8

•           Increase position number for list entry - The position number in column B is to be increased by 1 after a new entry in column C

•           Collection of job descriptions by employee - The number of job descriptions per employee is to be listed in sheet 2

•           Determine values depending on selected validation - Cell H10 contains a validity limitation. Corresponding values from selection in H10 are to be inserted in cell left to H10.

•           Multiply values depending on assigned indexes - A value is assigned to every letter in column A. This assignment is in sheet 2. According to this assignment, the values are to be multiplied by 3.14

•           EURO currency increments - The value in cell A3 is to be divided up in coins and bills of the EURO currency

•           Total without maximum value, mark maximum value - Values in column F are to be totaled up in the respective rows without consideration of the maximum value. The respective maximum value is to be marked

•           Determine row numbers of found cells - Found row numbers from column A with values from column B are to be entered in column C.

•           List of weeks for various years - The calendar weeks from/to of months are to be listed. The year in cell B1 is to be kept variable. No use of VBA

•           Use of DBMAX for date and time - In sheet2, the maximum temperature of a given day and the time is to be calculated.

•           Calculate average from 6 highest values in column A - How can I calculate the average value from the 6 highest values in column A?

•           Integration of SREFERENCE in a names function - Value in column A is to be searched in sheet 1 or sheet 2. If respective cell in column B is not empty, recognize cell and link it with cell from column A.

•           Values with limited lifetime - Formula in cell E2 should only go up to 10/31/2001. Test with change of system time. Then format formula with F2

•           Search of respective values in two columns - Data from column C is to be searched in column A and B and the value is to be displayed in column D

•           Indicate data in matrix. - By calendar weeks listed values in Sheet2 should be listed in Sheet1

•           Number of entries for a specific week - The number of entries in column a for a specific week is to be determined.

•           Multiplication of a value depending on its position - In area A1:E1 there is only one value. How can I multiply this value with a factor depending on the column position?

•           Ascertain the sum between two periods - How can I ascertain the turnover being in Column B of a certain period? The start day is in Cell C2, the day of end in Cell D2 and the row of date is in Column A.

•           Round-Examples - How must I handle the Round-Functions?

•           Show the number of the determined RecordSets via Autofilter - How can I read out the RecordSets that were determined by the Autofilter? The same Message that appears with the use of the Autofilter in the StatusBar should be outputted.

•           Search through a two-dimension Matrix with the VLOOKUP-Function - How can I search for a Value in a two-dimension Matrix that isn´t entered in a Worksheet without checking each Value?

•           Ascertain the next free article number - How can I ascertain the next free article number? Spaces must be taken into account. The article numbers are in the Format "10000ABC".

•           Calculation of the sales tax from gross and add the sales tax - How can I calculate the net fare and sales tax of the gross amounts in a worksheet? The sales tax should be added depending on the sales tax rate.

•           Access on Cells by using an Area Name - How can I access Cells of a second Worksheet by using an Area Name and the INDIRECT-Function and transpose the Area with it?

•           Ascertain the confirmation of an invitation - How can I ascertain, how many invitations have or have not been answered and how many confirmations with how many persons, exist till now?

•           Find double Values via a Formula and mark it - How can I create a comment to the double existing Values of Column A in Column B and mark these in Column A?

•           Overview-Sheet with information about the names in the Worksheets - I´ve got 2 Worksheets with a Column for name and surname each time. How can I view a X with the name as well as the surname in one Row below the WorksheetName in an Overview-Sheet

•           Formula Input via SMultiplication of a value depending on its positionhortCut - How can I multiply the Value of Column A with the Value of Column B and format the Cell when I press the ShortCut?

•           Read out names depending on a score - There are names in Column A and scores in Column B. The lowest score means the first place. How can I list the names according to there order of rank in another Column?

•           Enter Address according to the selection in the ValidityField - How can I enter the address in addressCells after selecting a customer number in a ValidityField?

•           Calculate a mark on the basis of a PointTable - How can I ascertain a mark for a given score on the basis of a PointTable?

•           Calculation of period and mean value - How can I calculate within a given period a mean value per hour? The Endtime can be after midnight.

•           Show a pre-determined Number of the lowest Values - How can I view the lowest value of column A and B in Cell C3?

•           Ascertain the value depending on a Symbol in a String - How can I change the value of of a cell to be "Man" or "Woman" depending on the 6th Cell value of 1 or 2?

•           VLOOKUP, HLOOKUP, INDEX, MATCH and Goal Seek - How do the Functions VLOOKUP, HLOOKUP, INDEX, MATCH as well as the Goal Seek, work ?

•           Variations to view a weekday? - In what ways can I view the Weekday of a date?

•           Example for the use of the SUMIF-FORMULA - How do I handle the SUMIF-Formula?

•           VLOOKUP-, HLOOKUP- und Matrixformula-Examples - How do I handle VLOOKUP-, HLOOKUP- and Matrixformulas?

•           Show "done" after a RowInput - When there is an input in a respective Row, how can I make Column D display done?

•           Net workdays and flexible holidays - How can I ascertain the net workdays of a period considering the flexible holidays?

•           Medal-distribution according to points - How can I set the Medal-distribution at School sport Events?

•           Mean Value of a Row of Numbers till the Row with the Formula - How can I ascertain the mean value of Row of Numbers till the InputCell?

•           Evaluate Soccer Scores - How can I evaluate a Worksheet with Soccer scores. The agreement is as follows: Goals for = 3 Points, Goals wrong = 1 against

•           Election-Analysis with Hare-Niemeyer - How can I integrate the VoteCount with Hare-Niemeyer in an Excel-Worksheet?

•           Wages calculation including additional wages - How do I create a Worksheet that does an automatic Wages calculation considering additional wages?

•           Multiply Header-Values of Cells that are marked with a cross - How can I multiply Header-Values of Cells that are marked with a cross with a value in the same row?

•           Interest-Worksheet with variable repayments - How do I create a Worksheet that calculates the outstanding sum with a fixed interest rate and variable repayments?

•           DM/EURO-conversion without Formula and VBA-Function - how can I always display a DM/EURO and EURO/DM Converter in the current Worksheet without depositing a userdefined Function or using a set Formula?

•           Construction of a weight-, range zone- and price-Table - How do I construct a Worksheet with weight-, range zone-, and price-givings so that the transport cost belonging to it is shown automatically when the weight

•           Handling of the Database-Function DBSUM() - How can I work with the Database-Function DBSUM() to use several criterias as a basis for the adding up of a Database Area?

•           Sort rising and descending without the SortFunction - There is a Worksheet with rising customer numbers. How is the Column with the customers sorted once rising and once descending without using the SortFunction?

•           Use the last Value of a sequence of numbers as multiplier at a time - How can I use the last Value of a sequence of numbers of a Worksheet as multiplier?

•           Read out the h-mean value of a series of measurements that last for 10 minutes - How are the current hourly mean values of a series of measurements that last for 10 minutes read out?

•           Sum the worksheet according to several criteria. - How can I sum a range based on several criteria? Excel's SUMIF function accepts only one criterion.

•           Delete all names in the active Workbook - How can I delete all names in the active Workbook?

•           Create the Email-Address with Name, Surname and Domain - How can I create Email-Addresses via a Formula when the Name and the Surname are in Column A?

•           Debt balnce - How can I create a Worksheet that makes a monthly calculation of the outstanding debt balance with a fixed interest rate and fixed monthly pay backs?

•           Determine matches from Preliminary to Final round via formulas. - How can I determine matches from the preliminary round to the final round, using formulas?

•           Fit the List of the days of a month exactly - How can I fit the date of a List of month days exactly to the actual days considering the leap years?

•           The last Cell with contents of a Column of a closed Workbook - How can I ascertain the last Cell with contents of a certain Column of a closed Workbook?

•           Calculate the postage with the help of a Weight-/Areamatrix - A matrix contains a Weight- and AreaGraduation. How is the postage calculated by the Input of both factors?

•           Delete the Names without destroying the Formulas - How can I delete the AreaNames in a Worksheet without getting an Error-Message in the Formulas with References to this Names?

•           Determine the Value of the Cell next to the maximum Value - How can I ascertain the Value of the Cell left to the Cell with the maximum Value of a set Column?

•           Access on an ArticleList via VLOOKUP() - How can I access on an ArticleList with the VLOOKUP()-Formula? After this, the RecordSets should be taken on a SalesList by pressing a Button.

•           Calculation of marks by means of a Point-Table - How can I set the marks (school) in relation to the maximum score?

•           Recognize References by means of a Headline - How can I fit in references to Worksheets whose names are in the Headlines, in a Cover?

•           WorkingHoursWorksheet and VLOOKUP-Formula - In a Workbook I have created Worksheets for each day in a month including the working Begin and End Time of the employees. In this Workbook also exists an employee summary.

•           Enter Sum formula at the bottom of a list of number values. - How can I make VBA enter a Sum formula below the last occupied cell of Column C? The first Value is in Cell C1 and the sequence of numbers has spaces.

•           Separate the ZIP code from the country - How would I separate the ZIP code from a country name when both are in the same cell?

•           Construct an array formula using VBA - How can I construct an array formula using VBA?

•           Count the occurrences of a year in a list of dates. - How can I count how many times a given calendar year exists in a column of dates?

•           Insert a variable cell reference in a formula - Using VBA, how can I insert a variable cell reference in a formula?

•           Separate the first 5 Symbols after a "+" - How can I save each of the first 5 Symbols after a Plus in a long String in Variables and enter them in a Worksheet afterwards?

•           Reverse the Minus - When I import TextFiles many Cells have an added minus at the end, How can I turn these Strings into negative Values?

•           Enter the Ranks in a Worksheet with VBA - How are the first 10 Ranks of the Values in Column A entered in the Worksheet with VBA?

•           Prevent the Error Entry #DIV/0! - How can I prevent the Error Entry #DIV/0! ?

•           Determine the Value in the Cell beside the MaximumValue - How can I determine the Value of a Cell to the right of the Cell with the Maximum Value?

•           Worksheet Name in Formula - Is there a possibility to have the Worksheet Name as a Function or Variable in a Cell so the contents are made topical after changing the name of the cell?

•           Sum from the active Cell - How can I determine the current Cursor Position with VBA and then ascertain the Sum of all Cell Values above or below this active Cell?

•           Add till the topical Date - How can I add the values of the Dates until it reaches the date that corresponds with the one at the top?

•           Access a closed Workbook with the Indirect-Function - Suppose you have a title with the name "Test", and you want to link to a workbook of that name. You cannot use Indirect because it cannot be used on a closed workbook.

•           Determine the Cell contents in the second Sheet - How can I determine the contents of a Cell in a second Worksheet, assuming the same Column, but a different Row?

•           Change a String into Value - How can I change a NumberString with a point as Decimal Separator into a Number?

•           Save Formulas with Cell Addresses - How can I save all Formulas of a Worksheet with Cell Addresses to a TextFile?

•           Undocumented DATEDIF function - How can I include the nondocumented DATEDIF Function in in a Macro?

•           Accessing a closed workbook through VBA - How can I access a closed Workbook using VBA?

•           VLOOKUP() on a closed Workbook - How can I use VLOOKUP with criteria from the active worksheet to query a closed Workbook using VBA?

•           Sum of filtered Rows - I want the Sum of a Column created after Autofiltering in a worksheet. However, the SUM() formula always returns a value of all the Rows, not just the filtered one. What is wrong?

•           Disable the #NA Error-Message - How can I disable the #NA Errors, but keep the other error-checks visible (e.g. #VALUE)?

•           Julian Date Formatting - How do I show the Julian Date in the "yyddd" format?

•           Sum, if larger than Cell A1 - How can I sum the numbers that are larger than the number in Cell A1?

•           Conditional Sum - I´ve got a Worksheet with the Columns "item" and "number". Is it possible to calculate the sum of the numbers corresponding to the items that contain a specific word? "number".

•           View formulas and values - How can I view the formula =8*9+26 in A1, and the result of 98 in another cell?

•           Sheet reference formulas - Formulas in range B2:M20 serve to sum the values stored in the accompanying 12 monthly worksheets.

•           Dynamic sheet name in VLOOKUP & INDIRECT functions - A VLOOKUP with INDIRECT formula returns a value from different worksheets, based on values in criteria cells.

•           Intersecting values returned - Two examples of returning an intersecting value in a table, using named ranges in the formulas.

•           INDEX MATCH to identify maximum corresponding value - Return the value in column A that corresponds to the maximum value in column B.

•           Alternative analyses - Example: Efficiency analysis and cost effective analysis for the purchase of a house.

•           INDEX MATCH MATCH for intersecting cell value - In cell C1, an INDEX MATCH MATCH formula returns the value that is in the intersecting cell in the table on Sheet2, based on the column header criteria value in cell A2 and the row header value in cell B2.

•           Transpose a table - The horizontal arrangement of the table on Sheet2 is transposed to a vertical arrangement on Sheet1 using INDEX MATCH formulas.

•           Interest based on loan payments - Table of interest in column C for the payoff of a loan with varying payment amounts made each month.

•           Round to nearest given increment - Using the ROUND function, return a number rounded to the nearest .05.

•           Example of NetWorkday function - Example of the NetWorkdays function is in cell D1. It considers the number of days between the start and end dates, excluding holidays and weekends. Requires activation of the Analysis ToolPak add-in.

•           Date calculated by years - The number of years in cell B2 is to be added to the date in cell A2, to return a future date in cell C2.

•           Easter date - On Sheet1, the formula in cell B1 calculates the date Easter falls on, for the year displayed in cell A1.

•           DSUM and array formula worksheet functions and VBA - A DSUM and array formula are entered natively as worksheet functions, and repeated as VBA macros.

•           Data validation for unique value length - Data in column A must be 10 characters long, and not a duplicate value elsewhere in column A.

•           Conditional formatting, 3 conditions - With Conditional Formatting, cell values in column C smaller than 5% are to be shaded green; between 5% and 10% shaded yellow; and more than 10% shaded red.

•           Conditional format - With the help of Conditional Formatting, the latest (highest) date is displayed in column B, and the corresponding value for that row is displayed in column A.

•           Evaluate a cell format - Evaluate whether a number in a cell is entered as text or as a number.

•           Data validated named range with VLOOKUP formulas - Cell A9 of Sheet1 is data validated with a named range that is the table on Sheet2. Select a Name from the drop down list and the cells below it will populate with the relevant address information.

•           SUMIF to total by day - The SUMIF formula in column G of Sheet1 serves to total the hours worked per day from the table in range A1:D9 of Sheet1.

•           Examples of MATCH and LOOKUP formulas - Column F of Sheet1 is matched with source values in column A of Sheet2 to return values in column A and column H of Sheet1, using MATCH and VLOOKUP functions.

•           Examples of INDIRECT - Two examples of INDIRECT - - one with a MATCH function, and one with a VLOOKUP function.

•           Examples of range reference worksheet functions - Three formula composition approaches to arrive at the same result, using hard-entered criteria, or criteria based on cell values, or based on named ranges.

•           Conditional Format of odd numbers - Using Conditional Formatting, odd numbers in column A will be formatted as a red-shaded cell.

•           Alphabet letter converted to number - Formula that can translate each letter of a value string into that letter's position in the alphabet.

•           Degrees, Minutes, and Seconds displayed in custom format - Convert separate values for Degrees, Minutes, and Seconds into a decimal factor using the formula =A2+B2/60+C2/3600 and into a single value string using a custom format ( [h]° mm' ss.00\" ).

•           Disallow certain characters using Data Validation - If a cell in column C contains "B", the corresponding cell in column F will not accept "F" or "T".

•           Duplicate entries disallowed except for certain characters. - Using Data Validation, no duplicate entries may be made except a period (".") or a semicolon (";").

•           Data validation controls maximum allowed formula result - Cell G1 contains the formula =E1+F1. Cells E1 and F1 are data validated such that the number in G1 may not exceed 5.

•           Dynamic data validation - Items in one cell's data-validated drop-down list are made available depending the item selected from another cell's data validated drop-down list.

•           Sum numbers in named ranges over multiple sheets. - The SUM and INDIRECT functions are utilized for referring to named ranges across worksheets.

•           Return value corresponding to calendar week number - The value in cell B2 of Sheet1 is to appear in row 2 of Sheet2 in the column of Sheet2 that corresponds to the week number in cell B1 of Sheet1.

•           Conditional formatting for duplicate values - Column A is conditionally formatted so that duplicate values are highlighted.

•           Data Validation to set maximum character length in cells. - In column A, Data Validation is employed to limit cells to a maximum length of 35 characters.

•           LOOKUP formula with ROUND - The formula in cell B1 looks up the value in cell A1, and rounds the LOOKUP value to one decimal.

•           Two-decimalized rounding to the .09th. - Values are rounded, rounded up, and rounded down to a two-decimalized .09th.

•           MATCH function identifies presence or absence of value in another range. - The formulas in columns C and D identify which values in column A are not found in column B, and which values in column B are not found in column A.

•           Entry in one cell returns LOOKUP value from table - Example of a VLOOKUP formula, where the value in A1 is entered, and its corresponding value is returned in A2, from the table on the "Data" sheet.

•           VLOOKUP for multiple column data - By entering an "x" in column B of Sheet1, the dimensions of the corresponding Product in column A shall be displayed in their respective columns, via a VLOOKUP formula from the table on the "Data" sheet.

•           RANK utilized to allocate seats based on political party delegate count - Seats for political party delegates are allocated based on delegate count and seat availability.

•           Conditional Format example for cell value - When a cell's value is "5 dollars" (without the quotes), Conditional Formatting will format the cell.

•           Base date added to by 33 1/3 years - Megaformula returns a future date as does the result of a separate four-step series of formulas.

•           LOOKUP and INDEX functions return prices for combination of items - Using a table for LOOKUP and INDEX functions, a combination of construction materials is specified in order to obtain a per-unit and final cost.

•           Running balance - Simple example of a running balance based on Income and Expense entries.

•           Return defined set of last record(s) from list - Formulas in range D2:E6 return the last 5 records from the lists in columns A and B.

•           ActiveX ComboBox properties return LOOKUP value - Selecting a ComboBox item will return a corresponding value in a linked cell from the source table.

•           NETWORKDAYS for number of days worked by employees - The number of workdays per employee is calculated, considering which weekdays the employee did not work within specified start and end dates.

•           ROUND and AVERAGE predict future data based on historical data - Numbers are predicted for future months in current year based on productivity to date in current year and average for same calendar month from previous year.

•           FORECAST function to help predict future productivity based on historical data - ROUND with nested FORECAST formula offers one approach to predicting future productivity based on actual historical data.

•           Data Validation sets limits on length of cell value - Values in column A are required by Data Validation to be between 2 and 10 characters in length.

•           Return value at given row interval - Return the value of every 20th cell in a range.

•           Rankings of competitors based on their results over several dates - Rankings of competitors based on their results over several dates.

•           SUMIF to total numbers for a given Item - Using a SUMIF formula, each Item's numbers from a separate table are totaled.

•           VLOOKUP returns corresponding value for Item in adjacent column. - A VLOOKUP formula in one sheet shall reference the source table on another sheet to return the corresponding value for criteria being looked up.

•           Proper sequence of values is maintained when lead cell's value is changed - A value sequence is maintained in a range when the lead cell's value is changed.

•           Conditional Formatting separates value changes in a list - A sorted list of names is separated by a black line via Conditional Formatting.

•           Conditional Formatting indicates a numeric value as being greater than another numeric value - Using Conditional Formatting, prices for an Item are compared between two stores. When a price in store #2 is found to be greater than a price for the same Item, that higher price is shaded green.

•           VLOOKUP from ActiveX ComboBox selection - A ComboBox's selected value is returned to a linked cell which is the precedent for two other cells containing VLOOKUP formulas, pointing to a table on a separate worksheet.

•           Determine minimum and maximum values in a range - Return header values associated with minimum and maximum values in a range.

•           Sum numbers between and including start and end points - Items sold per month are summed based on any start and end month period the user defines.

•           Conditional Formatting to identify duplicate values - Cells in column A that contain duplicate values are conditionally formatted to be shaded yellow.

•           Negative numbers are hidden by Conditional Formatting - Negative numbers are conditionally formatted for white font color, making them appear invisible.

•           Allow entry of positive whole numbers only - In column A, only whole positive numbers greater than zero are allowed.

•           COUNTIF function scenario examples - Several example applications of the COUNTIF function, including accounting for wildcards.

•           Accumulation maximum - Interval points are marked with an accumulation of prior value plus a factor value for that Interval point, to a predetermined maximum.

•           NETWORKDAYS and EOMONTH functions example - How can I determine this month's count of net workdays (not including weekends), this month's count of remaining net workdays, and a percentage comparison of the two?

•           VLOOKUP using OptionButton - Toggle between different assembly costs using embedded OptionButtons to define VLOOKUP formulas.

•           MATCH function to search value in multiple ranges - I have a list of values in column A. How can I evaluate each value such that if it exists in either of two other ranges in the worksheet, that value shall be noted as "Current" by a formula in column B?

•           Subtotal visible filtered records. - What formula can I employ to show me subtotals of visible data in filtered fields?

•           VLOOKUP with data validation named range - How can I set up two cells, one with data validation and the other with a lookup formula, that relies on data from a table on another worksheet?

•           Sum numbers for each weekday from source table. - I have a long list of dates in column A and numbers associated with those dates in column C. How can I build a table that sums all the numbers for each of the 7 weekdays based on those dates?

•           Intersecting value in table based on two numeric range factors. - How can I devise a formula with named ranges to determine freight charges based on two known factors of weight and distance, from a table on another sheet?

•           Conditional Formatting for duplicate values across columns - How can I format cells when their value is the same as the value of a cell in another column? I do not want to format duplicate values within the same column, only for duplicates when found in other columns.

•           Multiple COUNTIF functions return vertically aligned values - How can I place one formula in a cell that counts the quantity of several criteria values, and displays the return values in a vertical fashion, aligned flush left in one cell?

•           Graphic display in conditionally formatted cell - How can I employ a worksheet formula and conditional formatting to display a happy face, or sad face, or blank face depending on the comparison of two values?

•           Comparison of ActiveX versus Forms ComboBox embedded object - Please show me a comparison of how to return an index or actual value in a worksheet cell that reflects the selected value in a Forms ComboBox and an ActiveX embedded ComboBox.

•           Embedded OptionButton selections trigger mathematical operations - I want to put 3 OptionButtons on my spreadsheet, and caption each with a different number. When one of the OptionButtons is selected, I want that caption to be multiplied by a base number to give me a final result. How can I do this without using VBA?

•           Sum of intersecting cells - I have a large table of data on Sheet1 with months listed across row 1 and Names listed down column A. What formula would return the sum of numbers found in specified intersecting cells?

•           ActiveX Calendar control example - Please show me how to display the date in a worksheet cell that is selected by an embedded Calendar control.

•           Annualized monthly data considering leap years - What formula can I employ to annualize monthly data, taking leap year into account for any given year?

•           VLOOKUP criteria as concatenated values - How can I employ two cell values as a concatenated single argument for the VLOOKUP function?

•           Formulas for holiday dates - How can I compile a list of American holidays and their dates?

•           Intersecting value from table based on row and column header criteria - I have a list of cities and their weather data from several dates. How can I display one of the city's data for all dates by selecting its name from a data validation list?

•           Return ranked values in sequential and transposed order - How can I utilize INDEX, MATCH, VLOOKUP, and INDIRECT functions to return the ranked and displayed order of listed values, and also transpose their display from vertical to horizontal?

•           VLOOKUP from named range on separate sheet - How can I use data validation to list the names in a table on another sheet, and populate cells with related information from fields in that other worksheet's table?

•           VLOOKUP for daily activity based on weekday - How can I return the day's activity for all 7 weekdays for the entire year, based on a lookup table located on another worksheet?

•           Rank by sum of least differences - How can use the Rank function to determine the winner of a series of bets on a race or election, by summing the differences between wagered guess and actual result?

•           RANK and INDEX MATCH functions to view data - How can I compose two formulas, one to rank a list, and the other to list the associated names by rank?

•           Negative time - Negative time is calculated in cell C2 without consideration of the 1904 date reference. The result from the formula is obtained by combining the formula with the custom format of "-"h:mm .

•           Sum sets of numbers based on precedent digit prefix - How can I sum sets of numbers that are each grouped by a sequenced prefix whole number?

•           Conditional Formatting - every other row - How can I alternate the shading of every other row in my worksheet?

•           Conditional Formatting - minimum and maximum - How can I mark the respective cells in a column that hold the minimum and maximum values?

•           Conditional Formatting - current date - For a list of dates, how can I mark the cell that holds today's date, and the cells that hold dates which are 3 days before and 3 days after today's date?

•           Conditional Formatting - Easter - How can I mark the cell that holds the date Easter falls on for a given year?

•           Conditional Formatting - current calendar week - For a list of all 365 annual dates in column A, how can I mark the 7 which fall within the calendar week of the current date?

•           Conditional Formatting - excess aggregate value - I have a table of numeric data in 3 columns. How can I mark the records whose aggregate value (all 3 values multiplied together) exceeds a pre-set level?

•           Conditional Formatting - locked cells - With the help of a User Defined Function, how can I employ Conditional Formatting to identify which cells in a range have their Locked property set to True?

•           "CELL" function example: Address - Please show me an example of how to apply the Cell function's "Address" info_type argument.

•           "CELL" function example: Width - Please show me an example of how to apply the Cell function's "Width" info_type argument.

•           "CELL" function example: Filename - Please show me an example of how to apply the Cell function's "Filename" info_type argument.

•           "CELL" function example: Color - Please show me an example of how to apply the Cell function's "Color" info_type argument.

•           "CELL" function example: Format - Please show me an example of how to apply the Cell function's "Format" info_type argument.

•           "CELL" function example: Contents - Please show me an example of how to apply the Cell function's "Contents" info_type argument.

•           "CELL" function example: Parentheses - Please show me an example of how to apply the Cell function's "Parentheses" info_type argument.

•           "CELL" function example: Prefix - Please show me an example of how to apply the Cell function's "Prefix" info_type argument.

•           "CELL" function example: Protect - Please show me an example of how to apply the Cell function's "Protect" info_type argument.

•           "CELL" function example: Type - Please show me an example of how to apply the Cell function's "Type" info_type argument.

•           "CELL" function example: Column - Please show me an example of how to apply the Cell function's "Column" info_type argument.

•           "CELL" function example: Row - Please show me an example of how to apply the Cell function's "Row" info_type argument.

•           Comparison of multiple relative ranges - How can I compare cells of relative position in two separate ranges to verify that they hold the same values, and if different values are found, conditionally format the cell of a third relative position?

•           Wildcard criteria for VLOOKUP formulas - How can I use wildcard characters in my criteria values to help return VLOOKUP results?

Date & Time

•           Calculations with one thousandth fractions of seconds - Calculations with values in the area of tenthousandth of a second are to be done.

•           Delete all cells with today's date - How can I delete all rows with a date earlier than today?

•           Search and copy date values - Dates are to be copied in an area with a start and end value inquired by a input box

•           Take off the actual passed time from an entire time - How can I take off the from the start till actual passed time from a set entire time?

•           Enter Starttime and Interim with a Button-press - How can I enter a Starttime in a Cell when I press a Button? After the next Button-press the differences of the current time to the Starttime as well as to the last interim should be given.

•           Create day sheets of a month without weekends and holidays - How can I create a Worksheet in which the weekends and holidays are absent, for every day of the month in the current Workbbook ? The day sheets should be named with the date.

•           Verify that a TextBox entry is a valid date - In a userform TextBox, verify that a number entered in "DDMMYY" syntax is in fact a valid date.

•           Fix point in a given period - I make Time-Inputs like "11:12 till 16:15". Whenever the fix point 12:00 exists in the given period, an "X" should be shown in an other Cell.

•           Distribute Data from a List of the day to day sheets - How can I distribute Data from a List of the day (date in Column A) to separate day sheets. The names of the Worksheets correspond to the respective date.

•           Show the time in the Format hh:mm:000 - How can I show fractions of seconds in TimeFormat, so for example: 12:05:456?

•           Enter the holiday according to the Table in the holiday-list - I have the EmployeeName, the HolidayStart and the HolidayEnd in a Worksheet. How can I color the holidays of each employee in the following month sheets?

•           Dynamic working plan for a month - How can I create a dynamic working plan for a month? After entering the year or the month the list of the day should be generated automatically. Weekends and holidays - the flexible, too - should be marked.

•           Enter the time difference or the time debit or an EmptyString - What Formula do I need to get the following result: - If A1 = "" then "" - If A1 = "Holiday", "Ill" etc. then "Holiday", "Ill" etc. - If A1 = 06:00 or something like

•           Create a 3-Shift-WorkingPlan according to set Data - How can I create a 3-Shift-WorkingPlan considering variable free days and marking the weekends?

•           Ascertain the working hours of a Personal-Number and a day - How can I ascertain the hours of a certain personal-number on a certain day with the help of a Month-Working-Worksheet?

•           Calculation of the weekly working hours - How can I calculate the working hours of a week in a Worksheet considering the breaks and the regular working hours?

•           Working hours considering the breaks and regular working hours - How can I automatically view the plus or minus of the working hours compared with the regular working hours in a Worksheet when I enter the start- and end-time of the

•           List the week numbers of the year based on the month and year. - How can I create a list of the week numbers of the year, which updates itself when a new month or year value is entered, and highlights Saturdays and Sundays?

•           Determine overtime hours worked, excluding regular time. - How can I extract the hours of overtime from total time worked?

•           Choose the date and time in a Calendar-Control? - From my first userform, how can I call a second userform from which to select date and time values, and display those values on label controls in my first userform?

•           List and add the days of months in a set period - How are the days of a month listed and added into a Worksheet proceeding from a Start- and End date with the current name of the month?

•           Next calendar week determined when workbook opens - When this workbook opens, the calendar week (beginning Sunday) of the week after the current week shall be determined with a User Defined Function.

•           Evaluate stamp-cards - How can I calculate the working hours of a day on the basis of the evaluation of stamp-cards?

•           Set the BackgroundColour according to the date - How can I change the BackgroundColour of a Date-series that must be set?

•           Birthdays of a set month in a new Worksheet - How can I transfer the birthdays of a certain month from a Personal List into a new Worksheet?

•           Calendar of the working hours of a year - How can I create a calendar of the working hours of a year that considers my individual Start- and Breaktimes?

•           Create a calendar with marked weekends and holidays - How can I create a new Workbook in which the first Worksheet contains a calendar with marked holidays and weekends?

•           Create a workbook calendar with monthly sheets. - How can I create a complete annual calendar with 12 monthly sheets, conditionally formatting weekends and holidays?

•           Test the Start- and Enddate and mark it - How can I make Excel ask for a Start- and Enddate via an InputBox and then mark both dates colored?

•           Search for the Date and enter the Value - How can I find a Date in Column 1 of Worksheet 2 that is put in Cell A1 of Worksheet 1? In the Cell to the right of the found Date a Value should be entered.

•           Turn Decimal Numbers into Time, and Reverse - How can I change DecimalNumbers into Times and vice versa and add them?

•           Enforce a valid date input in a TextBox. - How can a Text Box be made to only accept date values?

•           Number of a certain Weekday in the Month - How can I determine how often a certain Weekday is in a set Month?

•           Enter the Weekdays Mon - Fri in a Worksheet - I want to enter the Weekdays Mon - Fri in Column A with an empty Cell following and the Date belonging to them in Column B for a pre-determined period. How can I do this with?

•           Mark in dependence on the quarter - How does the Input of a Date in Column A affect Columns A:F of the corresponding Row that is marked differently, in dependence on the quarter?

•           Simplified Time Input - I have to enter a great number of Times in a Column. But the Input of the colon with, for example "12:15", hinders a fast Input. How can I simplify this Input?

•           Change font color based on Date - How can I change the font color of a Cell to Red if the date is greater than today?

•           Times Format MM.SS.### - How do I display Time data in the format of Minutes.Seconds.ThousandthSeconds?

•           Conditional subtraction of time - Increments of time shall be subtracted from a precedent cell depending on the time value of that cell.

•           Workday hours - Determine the difference between start and end work times based on a standard work day.

•           List dates and week number - Enter all dates for the current year in column A, and their corresponding week number in column B.

•           Dynamic calendar of quarters and years - Entry of today's date in one cell triggers a dynamic identification of future quarters and years.

•           Divide time - The current time is displayed in an InputBox, or you can enter your own time, and that time shall be divided by 4.

•           Year is extracted from text string - The text string in cell A2 shall have the year extracted in two ways: Formula UDF, and macro.

•           Annual workday calendar - Create a 12-month workday calendar with options to include or exclude weekdays and holidays.

•           DIFF function calculates negative time - Negative time potentially calculated, using the DIFF function.

•           Year, Month, and Date differences calculated using the DATEDIF function - Using the DATEDIF function, the differences in years, months, and days are calculated for two dates.

•           Date formula for birthday - Determine if the person whose birthdate is in column C is celebrating a birthday today.

•           Time elapsed and wages earned - Simple earnings computation based on hourly wages multiplied by time worked.

•           Calculate Regular and Overtime work hours - Simple computation of Regular time worked and Overtime worked, based on start and end working times, considering a defined "Standard workday" factor.

•           Rounding of elapsed time - Calculate the rounding of actual elapsed time such that at or after the first 15 minutes of the hour, the elapsed time will be rounded to the next half-hour.

•           Elapsed times in several categories are calculated between start and end dates - Using formulas with a Forms button or pressing F9 to recalculate, a pair of start and end dates and times are calculated for elapsed and remaining years, months, days, hours, minutes, and seconds.

•           Identify earned wages for night work and day work on the same shift - Identify earned wages for night work and day work on the same shift, when night time wages have an additional hourly wage incentive.

•           Return workday end time based on work start time, break time, and regular workday hours parameters - A formula shall serve as a guide for suggesting what the workday's "End work" time should be, based on the "Start work" time, considering rules for Break time what hours constitute a Regular work day.

•           Scheduled worktime is marked by Conditional Formatting - Conditional Formatting marks worktime for cells in columns headed by hours of the day.

•           Days overdue - Determine if today's date is past the allowable number of days for a payment to be made.

•           Word replaced by time value - A word ("Hours" in this example) is replaced with a time value for two formulas - - one being a native Excel worksheet formula and the other being a VBA-driven user defined function.

•           DATE formula returns date based on cell values, one being from a Forms ComboBox - A Forms ComboBox returns a month number, which with manually entered values for year and day, supply the DATE formula with enough arguments to return the associated date.

•           Total of hours worked on weekends and weekdays - A dynamic calendar sums the number of hours worked on weekends and weekdays.

•           Conditionally format weekend dates in given month and year - By specifying a year in one cell and a month in another, how can I list all the dates in that month, what day of the week those dates fall on, and conditionally format Saturday and Sunday dates?

•           Incrementally display time in cell and create HTML file - How can I display and update the time every second in cell A1, and at a specified time interval create and update an HTML file whose text shall be the time it was last saved?

•           Automatic time format as HH:MM:SS - How can I enter numbers for hours, minutes, and seconds without the colon separators, and have Excel display my entry in HH:MM:SS format?

•           Calculate time in hundredths of a second - How can I sum a list of elapsed times represented in seconds, and display that total in minutes, seconds, and hundredths of seconds?

•           Determine peak and off-peak hours in 7-day calendar week - How can I determine through formulas if a certain date and time on any day of the week fall within guidelines for peak or off-peak status?

•           Controlled work time calculation - How can I return the total work time for employees based on controlled start and end times?

•           Speed per hour - How can I determine the speed in miles per hour based on elapsed time and distance traveled?

•           Start and end times in one table are marked by shaded cells in another table - How can I represent a table of employees' time schedules in a separate table that uses Conditional Formatting to color-shade cells based on those times detailed in the employees' time table?

•           Time calculations for hours, minutes, and seconds - How can I look at the same time of day using two sets of Excel's time calculation formulas, and arrive at the same value for percent of day that has elapsed?

Dialog Boxes and UserForms

•           Display Office Assistant with instructed text. - Display the office assistant with help text in a UserForm with button click

•           Enter search phrases in UserForm, import found location - I have a range of cells that contain text values which are hyperlinked to the names of picture files on my hard drive. How can I employ a userform to search for such a text value, and if found, import the associated picture object into the corresponding cell address of another worksheet?

•           Proof check boxes of a selected area - The checkboxes in area A1:F10 are to be proofed for their values

•           Insert contents from UserForm-TextBox with graphic hyperlinks - With a UserForm, the TextBox contents together with hyperlinks to selected graphics is to be transferred to a worksheet

•           Read and deleted values without duplicates in UserForm - Column A is to be imported in a UserForm-ComboBox without duplicates

•           Populate ComboBox with unique values - A userform ComboBox shall be populated with unique items by a list in column A that contains duplicates. When an item is selected in the ComboBox, a calculation shall be made on numbers in column B associated with all duplicate values of that ComboBox item.

•           Read, search, edit, display value in a ComboBox - Search phrases from column F are to be imported in a ComboBox. When selecting the phrase in the ComboBox it shall be transferred in a TextBox for editing

•           Search for article number with criteria and copy records. - The article numbers of sheet "Criteria" shall be searched in sheet "Data" in column A. When found, copy files into sheet "Found". If not found, copy to sheet "NotFound"

•           Enter list box value in active cell - When clicking on a ListBox value, the value is to be inserted in the active cell.

•           Determine price with selecting article in ComboBox - Values from column A in sheet 2 are to be inserted in the ComboBox. The corresponding price of the selected value is to be displayed in cell E4

•           Jump from text box to text box with TAB key - How can I move from a sheet to a TextBox with the TAB key.

•           List duplicate values in a UserForm-ComboBox - Duplicate values in a sheet are to be listed in a UserForm-ComboBox

•           Set up background color of an object in a UserForm - The background color of an image object is to be set through a button

•           Insert file names in UserForm-ComboBox and open file - Values from column A are to be imported in a ComboBox The file is opened via a hyperlink.

•           Hide/Unhide columns with UserForm selection - With a UserForm, only the unhidden columns are to be set.

•           Proof for duplicates before entry in sheet - Before entering a value from a UserForm-TextBox into a sheet, check to see if the value already exists.

•           Select and save sheets in UserForm-ListBox - Worksheets, selected in a UserForm-ListBox are to be saved in a new workbook

•           Enter value in appropriate active UserForm-TextBox - A value is to be inserted in the currently active TextBox of a UserForm.

•           Select worksheet with UserForm-ComboBox. - Selection of sheet with UserForm-ComboBox. Macro executed with CTRL-A

•           Search for table with ComboBox selection - The values from columns A:B in sheet 1 are to be displayed in a ComboBox. The selected machine and its price is to be displayed in sheet 2

•           Display number word synchronized to TextBox entry - Simultaneous to entries in a UserForm-TextBox, the corresponding number word is to be displayed in a second TextBox

•           Limit entry in worksheet text box - After entering 3 symbols in the TextBox, they shall be written in the first free cell in column A. After that, the TextBox is to be emptied and gets back the focus.

•           Total of all values depending on combo box entry - Display total of all values which match the name in ComboBox of column A in cell D1

•           Sort and move date in ListBox - The values form column A are to be imported in a UserForm-ListBox. In the UserForm, the values are to be moved from one ListBox to another and sorted.

•           Selection of cells according to ComboBox - How can I integrate a sequence of cell addresses in a ComboBox and go to them after selecting in the ComboBox

•           Insert date from TextBox in first available space - A date from a UserForm-TextBox is to be inserted in the first available cell of a date sequence, if CheckBox is activated

•           Mark date sequence according to UserForm-TextBox - A date sequence resulting from a UserForm-TextBox is generated in Column A.

•           Display UserForm for 5 seconds - How can I have a UserForm display for five seconds?

•           Build own class for UserForm-TextBox - In a UserForm with four TextBoxes is -after entering the eighth digit- to be checked it entry is a valid date. All TextBoxes are to be linked with a common

•           Display values in two column ListBox left and right aligned - Columns A and C in a UserForm-ListBox are to be aligned left, column B is to be aligned right.

•           Save entered value in TextBox - How can I retain the value entered in a UserForm textbox so that it is displayed with the next opening of the UserForm?

•           Generate date sequence from TextBox entries - How can I generate a number sequence from entries in a TextBox (start and end date)?

•           Proof UserForm option fields - If in a UserForm the second option field in the first group field and the third option field in the second group field is activated, a new worksheet is to be

•           Check box with check off signs instead of crosses. - How can I integrate a check box in a sheet with check marks instead of crosses?

•           Value from ComboBox in TextBox , then search for value in table - A value is to be selected in a 3 column ComboBox. This value is to be transferred to a TextBox and searched in sheet 2 column C and then highlighted.

•           Fill a list box depending on a ComboBox - How can I fill a ListBox in a UserForm depending on the selection of the ComboBox?

•           Change focus and selection in two text boxes - Focus shall change with entries in between two text boxes

•           Fill second list box depending on first - A second ListBox is to be filled depending on a selection from the first ListBox

•           Synchronize option fields in various worksheets - Synchronize the option fields in all worksheets

•           Conditional drop down fields in dialog sheet - Depending of a selection in the first drop down field, the second drop down field is to be filled. After the selection, the respective values from sheet2 are to be displayed in the cell range in column E

•           Selected rows from UserForm-ListBox in new table - Columns C:D are to be listed in a UserForm-ListBox. The selected rows are to be transferred completely in a second workbook. Multi-selection is to be enabled.

•           Transmit two dimensional array to user form combo box. - Fill a two dimensional array with a string and transfer to a user form combo box

•           Sort multi-column user form list box. - Sort two columns in a list box by the order of column 1 and column 2

•           Entry of a value from UserForm-TextBox in active cell - A selected value from the UserForm-ComboBox shall be entered in the active cell

•           Stop activation of several check boxes - Determine the position of the clicked check box and double clicking in a cell is to be avoided. No option fields are to be used.

•           Close dialog after 3 seconds - The dialog with a yes-no question is to be displayed. If the user does not come to a decision after the first 3 seconds, the yes button is automatically chosen.

•           Command buttons in various tables with a macro. - How can I control a series of command buttons from the control tool box through a single macro?

•           Change size of a UserForm including elements - How can I change the width of a UserForm including its elements during run time?

•           Entry limitation, prevent entry of letters - The number of digits of an entry in a worksheet Text-Box is to be limited. Limitation also on letters only.

•           Delete duplicates in UserForm-ListBox - How can I deleted duplicate entries in a UserForm-ListBox

•           read column content in UserForm-TextBox with scroll bar - The content of column A shall be imported in a UserForm-TextBox with vertical scroll bars

•           Inquire search phrase and found row in user form text box - Require a search phrase and search in sheet. Open and display data of row with found phrase in user form text box

•           Entry limitation for text boxes - How can I determine various entry limitations in a three UserForm-TextBoxes

•           Delete elements in a UserForm box with DEL key - How can I delete elements in a UserForm-ListBox with the DEL key

•           Worksheet TextBox values depending on center field - Values of the TextBoxes are to be filled depending on the value of the center field with the cell contents from columns A:C

•           Open workbooks in a tree view control element - The opened workbooks and their worksheets are to be imported in a TreeView-Control element. With clicking on the element, the respective object is to be

•           Animated gif graphic in UserForm - How can I get a gif graphic to be animated in a UserForm?

•           Maximize user form based on current screen resolution - Maximize a user form after verification of resolution

•           Search value from user form text box and copy found location - Search a number in column 1 and enter it in user form text box. The row with found entry shall be copied in a new workbook up to column R. Search in table 1 to 5

•           Search each word of a sentence in an index list - Every word in a support question shall be searched in an index list and the corresponding answer is to be displayed.

•           Values from dialog check box into and from table - How can I enter the value of a dialog check box into a table and open it from the table with the next dialog.

•           Activate 10 UserForm-TextBoxes in a series - How can I activate and deactivate 20 UserForm-TextBoxes with a button click?

•           Test for valid entry of date and time in TextBox - In a userform TextBox, verify the correct syntax was used to enter a date and time.

•           Sort the UserForm-ListBox-Inputs - How can I sort the Inputs of a UserForm-ListBox rising?

•           Ascertain the position of the calling Button - How can I ascertain the left top corner under the calling Button as well as the Label of the Button?

•           Show the current time in a UserForm - How can I show the current time in a UserForm?

•           Address UserForm ComboBoxes as Collection Objects - How can I include a series of UserForm ComboBoxes in a Collection Object and address the Elements as such?

•           Close the Workbook when there is no Input in the TextBox - How is a Workbook automatically closed when the User enters nothing in a UserForm-TextBox for 1 minute?

•           Scroll through a UserForm-ListBox at intervals of two seconds - How can I scroll to the next UserForm-ListBox-Input at intervals of two seconds ?

•           Copy a Group of Option-Fields and assign it to a Macro - How can I copy a Group-Field with Option-Fields in a second Worksheet and assign a Macro to the Option-Fields?

•           Value from Column 2 of a poly-columnic ComboBox as general Value - A general Value of a poly-columnic UserForm-ComboBox is the Value from the first Column of the ListIndex shown. How is the Value from the second Column shown, when I call UserForm

•           Search for the Values from the UserForm-ComboBox and copy the place - How can I take the Values of Column A on a UserForm-ComboBox, search for the selected Value in the Worksheet and copy the place found in a second Worksheet?

•           Program-Control for several calling UserForms - How can I branch a Program that can be called by several UserForms depending on the calling Form?

•           DM/EURO and EURO/DM-conversion with leaving a TextBox - I have two Textboxes in a UserForm, one for DM- and one for EURO- Values. When I now leave one TextBox the Value of this TextBox should be entered converted in the other TextBox.

•           Choose the before selected Area after the Worksheet-ComboBox - How can I choose the before selected Worksheet-Area again, after selecting something in a Worksheet-ComboBox?

•           Select an Element in a ListBox depending on an TextBox-Input - How is the first Element of a ListBox selected to fit the letter that was entered in a TextBox? When I enter more signs a further search and possible selections should be done.

•           Enter Articles and Prices from a UserForm into an invoice - After a DoubleClick in an invoice form a UserForm with a multiple column ListBox, including Data of an Data Sheet, should be shown. After the selection of a RecordSet this should be entered in form.

•           Fill a multiple column UserForm-ListBox and read in actual Value - How can I read in a Worksheet in a multiple column UserForm- ListBox? After the selection of a RecordSet in the ListBox, the actual Value of Column 1 should be read in a Worksheet Cell.

•           Fill a UserForm-ListBox depending on the calling Column - How can I fill a UserForm-ListBox depending on the Column-Header created Button with Values?

•           Read in FileNames in TabStrip-Elements - How can I read in FileNames that are entered in a Worksheet as Captions in TabStrip-Elements? After a click on a TabStrip-Element the respective File should be opened. The properties should show.

•           Set the Autofilter-Criterias via UserForm - How can I set the Autofilter-Criterias via UserForm-TextBox-Inputs?

•           Show a chance number centred in UserForm-ListBox - How can I view each number that was determined randomly in a UserForm-ListBox?

•           Hide and unhide worksheets via userform ComboBoxes - Hide and unhide sheets by selecting their names from a userform ComboBox. The userform is called by a custom menu option loaded in the Open event, and deleted at the Close event.

•           Enter Value in Cell when the CheckBox is activated - How are Values entered in the Cell next to a CheckBox when the CheckBox is activated?

•           Password-Query with ShortCut-Call - How can I call a Dialog for the Password-Input with the Keycombination Ctrl+w? When the correct password is entered, the Sheet Protection of all Worksheets should be withdrawn.

•           Read in and output Values in a UserForm-ComboBox - How can I read in the Values of a Column in a UserForm- ComboBox and output it after a selection directly in a Cell?

•           UserForm as Progress Bar - How can I use a UserForm as a Progress Bar?

•           Select Signs in a UserForm-TextBox via a ScrollBar-Runner - How can I select the single Signs of a UserForm-TextBox according to the selected ScrollBar-Values?

•           Enter a Value depending on the calling Button - How can I enter a UserForm-TextBox-Value in Cells depending on the Button that calls the UserForm?

•           Show the Text of the last Cell with contents in a UserForm-TextBox - How can I view the Value that is entered in the last Cell of Column A, in a UserForm-TextBox when I call a Dialog?

•           Search for a Text of a UserForm-TextBox in a Worksheet - How can I search for Values of a UserForm-TextBox in a Worksheet and output the Rows found in UserForm-Labels?

•           Select an Area via UserForm-RefEdit-Control - How can I select an Area via a UserForm-RefEdit-Control and set a conditional Formatting to the selected Area?

•           Verify TextBoxes for numeric entries - A userform with three TextBoxes shall be evaluated for the entry of numeric values. See Sheet1 for details and a demonstration.

•           Call the first out of the second UserForm - How can I call the next UserForm after the Input of a Value in a UserForm-TextBox and jump from there back to the first again?

•           Add UserForm-TextBox-Values to an ListBox - After the Input of 2 numerals in a UserForm-TextBox the Value should be entered in an ListBox and the Cursor should jump to the next TextBox.

•           Allow only the Input of 2 numerals in the TextBox then go to next - How can I make the Cursor jump to the next TextBox after I have entered 2 numerals in one TextBox? The Value should be entered in the Column that the TextBox-Value is in when I leave current box.

•           Read in the visible Cells of an AutoFilter-Area only - How can I read in only the visible Cells of an Area using an AutoFilter and display them in the ListBox of a UserForm?

•           Overwrite Value depending on Dialog-OptionFields - How can I overwrite the last Value of a List depending on a Dialog-OptionButton?

•           Add a MenuItem and show a UserForm timecontrolled after a Call - How can I add an additional MenuItem to the Worksheet Menu when I open a Workbook and delete it again, when I close it? The MenuItem should show the Username for 2 seconds.

•           Sheet Selection via a UserForm-ListBox with multiselect - How can I select WorksheetRegister that were selected via a UserForm-ListBox?

•           Enter a Value from the UserForm-ListBox into a Worksheet - How can I enter a Value, that is selected in a UserForm-ListBox, into a Worksheet after pressing a Button?

•           Take Values from the UserForm-ListBox on the ClipBoard - How can I take all selected Values of the first Column of a multiple column ListBox on the ClipBoard?

•           Read out Values of first Column of a multiple column UserForm-ListBox - How can I read out all selected Values of the first Column of a multiple column ListBox in a Worksheet?

•           Combine Msg- and InputBoxes and branch according to the result - How can I branch different Macros depending on Inputs in a combination of Msg- and InputBoxes?

•           Macro branching according to OptionField- or ListBox-Selection - How can I branch Macros depending on OptionField- or ListBox-Click and output the Values?

•           Fill a multiple column UserForm-ListBox without spaces - How can I fill a multiple column UserForm-ListBox in a way with Values of a Worksheet so that Empty Rows aren´t taken into account?

•           Unhide / hide Columns according to a UserForm-ListBox-Set - How can I unhide and hide Columns of different Worksheets according to the Settings in ListBoxes of an UserForm-MultiPage- Control?

•           Read Column-Headers in UserForm-ListBox - How I can read Column-Headers in a UserForm-ListBox and edit these there?

•           Simulate the tabulator in the UserForm-TextBox - How can I use a tabulator in a UserForm-TextBox?

•           Read SheetNames conditionally in ListBox and select Worksheets - How can I fill a ListBox with the existing SheetNames, except the Sheets "Test" and "Pattern", when I open a Workbook? The selection of one of these Sheets should be done by a press button.

•           Multiply Values of two UserForm-TextBoxes - How can I output the Values of two UserForm-TextBoxes multiplied together in a third TextBox?

•           Fill a TextBox depending on a ComboBox-Selection - How can I fill a TextBox of a UserForm with Values of a Worksheet depending on a Selection that was done in a ComboBox?

•           UserForm-Call, when the Value of a Formula passes a limit - How can I view a UserForm whenever a Value, that is set by a Formula, passes a limit?

•           Show a UserForm when a Workbook is opened - How can I view a UserForm with an OK-Button when a Workbook is opened?

•           Generate, call and delete a ColorSelect Dialog - How can I generate a Dialog for the Color selection, call the Dialog, select the Colors and delete the Dialog again by pressing a Button?

•           Call a Datamask with the for a country specific or the US-Format - How can I keep the US Date and TimeFormats when the Datamask is called through ShowDataForm?

•           Query the Copy Area of StartCell, Row- and ColumnNumber - .

•           Call a UserForm depending on the RefEdit-Selection - How can I choose a type via a UserForm-RefEdit-Control, so that the UserForm is called depending on the type and the Data that is entered?

•           Generate and delete a Dialog for the Sheet-PrintSelect - How can I view the existing Worksheets in a Workbook through a Dialog for the PrintSelect? The Dialog should be fitted to the existing Worksheets and be deleted after the print.

•           Select the Cells for the Input and call a UserForm-ListBox - I have to input data in the Columns A:E. The Cursor should jump right to the next Cell after each Input. When it is in Column E a UserForm with a ListBox for selection

•           Raise the Value on the Button and in the Cell by 1 - How can I raise the Value in the Label of the Button and in the Cell A1 by 1 each time when I press the Button?

•           Take, work on it and enter Addresses from the AddressWorksheet - How can I take Data from an AddressWorksheet on a UserForm- ComboBox, select it, and output it in another form on a second Worksheet? The changes in the Dialog

•           Take ListBox-Selection on Labels - How can I retrieve values from a UserFrom-Listbox from the UserForm?

•           Change the SheetSelect when a Dialog is shown - How can I change between two Worksheets when I press a Button, while keeping the Dialog visible?

•           Ascertain a new Worksheet and the name via UserForm - How can I add a new Worksheet to the active Workbook and set its name in an Userform?

•           Read out the validity selection via VBA - How can I read out the selection from a Validity-DropDown-Field via VBA?

•           Read the AddressWorksheet in an UserForm and read it out in an AddressField - How can I read a Worksheet with Addresses in an UserForm-ComboBox and read it from there out in the AddressFields? New addresses should be added to.

•           Enter EditBox-Values with Linefeed in a Cell - How can I enter Values from an DialogSheet-Editbox with a Linefeed into Cells of a Worksheet?

•           Enter a tick in a Cell when an UserForm-CheckBox is activated - How is a tick entered in a certain Cell when a UserForm-CheckBox is activated?

•           Read in UserForm-TextBox-Values via a ScrollBar - How can I read values of a Worksheet in UserForm-TextBoxes via a ScrollBar?

•           Enter the Date from a Cell in an UserForm-Label - How can I enter a Date in a Label for a UserForm?

•           Put the articles in the shopping basket and enter it in a list - How can I transfer articles from an UserForm-ListBox to the Shoppingbasket-ListBox and enter it in a shopping list?

•           Multiply the Cells above the Worksheet-Button - How can I multiply the Values of two Cells in a third Cell when I press a Worksheet-Button?

•           Show the Rows of a second Worksheet in the first above the SpinButton - How can I view the Rows of the second Worksheet in the first above the SpinButton-Selection?

•           Add a selection from a Polycolumnic-ListBox to a Worksheet - How can I add a Selection from a Polycolumnic-ListBox to an existing Worksheet?

•           Enter the Value from a ComboBox in a Worksheet - How can I enter a Value that was selected in a Worksheet-ComboBox in the active Worksheet?

•           Call the Protected Sheet-Dialog via VBA - How can I call the Protected Sheet-Dialog via VBA and set the Sheet-Protection with or without password?

•           Enter a TextVariable in an UserForm-TextBox - How is a public TextVariable entered in an UserForm-TextBox through a Button?

•           Read out the UserForm-Elements - How can I read out the Caption- or Text-Properties of the Elements of an UserForm?

•           Unhide and hide Excel and VBE on a ButtonClick - How can I unhide and hide Excel and the VB-Editor on a ButtonClick?

•           Set the Focus after a Click on a Frame not there - Without a Frame being disabled, how can I prevent a TextBox from losing focus to the Frame?

•           Select certain Symbols of an UserForm-TextBox - How can I select certain Symbols that are in an UserForm-Textbox so that they can be written over?

•           Prevent the input of special symbols in a UserForm-TextBox. - How can I prevent the Input of special Symbols in a UserForm- TextBox?

•           Show the Values of a UserForm-TextBox and a Worksheet rounded - How can I view the Values of a UserForm-TextBox and of a Worksheet rounded to two positions in another UserForm-TextBox?

•           Search for a term by using a text box, and display the results - How can I search for a term in a Column A of a Worksheet using a UserForm-Textbox and display the result in a MsgBox?

•           Show or hide a cell's value depending on a CheckBox. - How is a Value in Cell A1 shown or hidden depending on a CheckBox?

•           Password test with a User Form. - How can I ask for a password via a UserForm and perform the action, depending on the answer? The password must not be shown.

•           Search for a value in TextBox and list it in a ListBox. - How can I search for a Value that was entered in a text box, and show all found values in a list box of the same user form?

•           Generate ComboBoxes in a Worksheet via VBA-Code. - How can I create ComboBoxes per column in a Worksheet via a VBA-Code?

•           Create an user form with ComboBoxes via a VBA - How can I create a UserForm with one ComboBox per Column of a Worksheet via a VBA-Code?

•           Select the Elements alternatively in a TextBox or ListBox. - How can I select alternatively the Text of a TextBox or an Element in a ListBox in an UserForm after clicking buttons?

•           Warning when a negative value is reached in an UserForm. - Positive and negative numbers are added in a Text Box. How can I display a warning when a negative sum is reached?

•           Values from an UserForm-TextBox-Series into a Worksheet - How can I transfer values of many UserForm TextBoxes into the Columns of a Worksheet?

•           Hide and unhide UserForm-TextBoxes. - How can I unhide and hide UserForm-TextBoxes via a Button-Click?

•           Control the label of an edit box using an option button. - How can I unhide and hide an edit box as well as changing the focus to the edit box by using option buttons?

•           Make a cell value be hidden and visible, using option buttons. - How can I make a cell's value be visible or hidden, using option buttons?

•           Hide and unhide a command button. - How can I use one command button to toggle hide/unhide a second command button?

•           Select a month and day using a combo box - How can I use a combo box to select a month and day, and copy it to a cell?

•           Address a group of UserForm-ListBoxes via a Loop - How can I address a group of UserForm-ListBoxes via a Loop and fill it with Values when I call the UserForm?

•           Enter a selection from a UserForm List Boxes into a worksheet - How can I enter a multiselect of several Listboxes in a Worksheet?

•           Add up selected Values from UserForm-ComboBoxes - How can I add Values that were selected in a series of UserForm-ComboBoxes?

•           Fill an address field with a ComboBox. - How can I fill an address field in a worksheet by selecting the addressee's name in a ComboBox?

•           Display column A contents of several workbooks in an UserForm. - How are the current contents of Column A read from all Workbooks of a Directory in a UserForm-ListBox and entered in the active Worksheet afterwards?

•           List and edit the Area Names in an UserForm-ListBox - How can I list and change all Area Names of a Workbook in an UserForm-ListBox?

•           Take the Inputs from DialogSheet-EditBoxes on a Worksheet - How can I take the member numbers and names from DialogSheet- EditBoxes on the next empty Row of a List in a Worksheet? When a member number already exists a warning should appear.

•           Read a Matrix into an UserForm-ListBox - How can I read a Matrix and output a poly-columnic UserForm-ListBox?

•           Hide / unhide a DialogSheet - How can I hide a Excel5/7-DialogSheet so that it cannot be unhidden via Menu FORMAT / SHEET?

•           Add the calculations in an UserForm - How can I add calculated Values in an UserForm-TextBox ?

•           Return to a calling UserForm - How can I recognize, through a second UserForm, the calling Form and return to it?

•           Start the AcrobatReader with a *.pdf-Document via an UserForm - How can I start the AcrobatReader within an Excel-Cell named *.pdf-File via an UserForm?

•           UserForm as Progress Bar - How can I view an UserForm as a Progress Bar during a run of a program ?

•           Transfer Values of an UserForm-TextBox in definite Formats - How can I transfer, into a TextBox of an UserForm, entered Values in Formats that depend on the OptionBoxes, to a Cell?

•           Show a ComboBox in dependence on a CheckBox - How can I show a ComboBox only when the CheckBox is activated and hide it otherwise?

•           Enter current time via an UserForm and calculate the racing time - How can I select a starting number via a UserForm and enter the current time in the relevant Row of the Worksheet so that the racing time is calculated?

•           Select the Row and Column via InputBoxes and name the result - How can I set the Row- and Column Number by clicking the Worksheet via InputBoxes and view the result in a MsgBox?

•           Select RecordSets in an UserForm and delete it in a Worksheet - How can I delete RecordSets that can be selected in a Userform in the Worksheet?

•           Take the selection from the Worksheet-ListBox to the Cells - How can I take the current selection in a Worksheet-ListBox on the Cells of a Worksheet at the moment of the selection?

•           Calculate numbers in UserForm TextBoxes - How can I add a series of numbers that are located in individual TextBoxes, multiply that sum by a numerical factor located in another TextBox, and have that calculated total appear in yet another "Totals" TextBox?

•           Leaf through UserForm-TextBoxes with a SpinButton and read Data - How can I input Data of a Worksheet in groups in a Textbox of an UserForm and read it out into the Worksheet on a Button? Press where the strings have to be divided again.

•           List all open Workbooks in a Dialog - How can I list all open Workbooks in a DropDown-Box of a Dialog and view the Value of Cell A1 of the "Worksheet1" of the selected Workbook via a MessageBox?

•           Test the Values of Checkboxes in an UserForm - How can I test the activated CheckBoxes of an UserForm via a Button?

•           Dialog-run 3D-Print - When I select several Worksheets, and give the Print Command in the Header, the entire Number of Print Pages of all selected Worksheets is outputted as entire number of sheets. How can I limit this to the pages of the current worksheet?

•           Directory and list the Files in a ListBox - How can I view all disk drives with its Directories and list the ExcelFiles of a selected Directory in the ListBox of an UserForm?

•           Reading out of the selected OptionBox in an UserForm - How can I ascertain which OptionBox has been activated in an UserForm?

•           UserForm entry of dates. - How can I employ userforms to simplify the input of dates?

•           Choose an in a DropdownList selected Worksheet - How can I select a Worksheet via a DropDown-Box in the Worksheet?

•           Ascertain the number of CheckBoxes in an UserForm - How can I determine the number of CheckBoxes in an UserForm?

•           Include CheckBoxes in UserForms via a Loop - How can I assign a Value to the first 5 CheckBoxes of a series of 8 via a VBA-Loop?

•           Show the disk drives for a selection in a Dialog - How can I view all available hard disks and CD-Rom-disk drives for a selection in a Dialog?

•           Allow only numerical Inputs in an EditBox - How can I limit the Inputs in an EditBox to numerals?

•           Transfer Values to the Target Addresses - How can I transfer the Values of Column A to the Target Addresses in Column B and consider that, if there is already a Value in the Target Address, this Value will

•           Calculation using second column in userform ComboBox. - How can I calculate the value of the second column of a UserForm ComboBox when I click a command button?

•           Open the UserForm-DropDown-Box after a KeyInput - How can I open automatically the UserForm-DropDownBox after a KeyInput?

•           InputControl in an UserForm - How can I limit the Inputs in an UserForm-TextBox to numerals, capital letters or letters?

•           Open DropDown-Boxes in an UserForm - How can I open DropDown-Boxes in a UserForm after pressing the Enter-Button when the Focus is on it?

•           Enter and select a Value in an UserForm-TextBox - How is a Value entered and selected in a TextBox when I call an UserForm so that this can be written over immediately?

•           Change a cell calue using a TextBox or Command Button. - How can I change a cell's value either by changing it in a userform TextBox, or by just clicking a button and substituting comma separators into decimals?

•           Prevent the closing of an UserForm via the CloseCross - How can I prevent the user from being able to cancel an UserForm by means of the "x" that is on the top-right of the form?

•           Change the Addressdata in a Worksheet via an UserForm - How are the Address data that I have changed in an UserForm and entered in the relevant Row of a Worksheet?

•           Set the maximum Value of a SpinButton in accordance with the CellValue - How can I set the maximum value of a SpinButton based upon the value in a cell?

•           Forgot a Password and test it with CheckBox-Activity - How can I set a Password and ask for it by clicking a CheckBox?

•           Read in and select Sheets in a DropDown-Box - How can I read in Worksheets of a certain series in a DropDown-Box of a DialogSheet and select the one that is chosen?

•           Create a dynamic Dialog - How can I view a Label or an EditBox in a Dialog depeding on the activation of an OptionBox?

•           Set up Dialogs without producing a stock memory problem - When I set up several Dialogs one behind the other I often get the message that the Memory is not big enough. How can I avoid this problem?

•           Read out a Multiselection in a ListBox - How are the non-selected items read shown in a MsgBox after a Multiselection of a ListBox?

•           Conditional transfer of the Focus and setting the Cursor in the Dialog - How is the Focus transferred to EditBox2 or EditBox3 depending on the Input in EditBox 1 and the where the Cursor is set?

•           AddressSelection via a Dialog and Input in an AddressBox - How can I select Addresses out of an Addressfile via a Dialog so that these then are entered in an AddressBox?

•           Orderfax over a Dialog - How can I select articles via a Dialog so that they are entered in a Fax Order form?

•           Enter AddressData in an AddressFile via a Dialogue - How can I input Address Data in a Dialogue so that these then are entered in an Address File?

•           PasswordTest - How can I ask for the password at the beginning of a Program?

•           Hidden Password Input with XL5 - In XL5 how can I display stars when a password is being entered?

•           Taking over Data in accordance with the selection in the DropDownBox - without VBA - How can I enter Data in a Worksheet that is dependent on the selection in a DropDown-Box?

•           ListBox with several Columns in XL5/7 - How can I integrate a ListBox with several Columns in a Dialogue in XL5/7?

•           Stock-management for 2 stockrooms - How can I manage the stock of 2 store rooms via a Dialogue?

•           Simulated ComboBox in a Worksheet - How can I create ComboBoxes with XL5/7 in a Worksheet?

•           Display an item from one ListBox to another ListBox - How can I select the Inputs in one ListBox and transfer it into the another?

•           Control and simplify the Dialogue-DateInput - How is the DateInput in the Format DDMMYYYY in a Dialogue-EditBox controlled and processed? In addition to that, after entering 8 Symbols the Focus should be set on the next EditBox.

•           Register and enter Measurement data - How can I input Measurement data via a Dialog so that they are entered in a Worksheet?

•           Show the EntranceScreen - How can I view a Start Dialogue at a pre-determined time on the Screen by opening a Workbook?

•           Limit the length of the Input in an EditBox and take the Values from a List - How can I limit the length of the Input in an Textbox to 4, and then further use that inputted value to search a second Worksheet?

•           Fill a Dialogue with month and days of a pre-determined year - How can I fill a DialogSheet with month and days of a year that must be set in advance?

•           Test Arithmetical Problems timecontrolled by the random principle - How can I test time controlled Arithmetical Problems? The Basic Numbers and the Operators should be determined using random numbers and the results should be evaluated.

•           Write the Text from a UserForm into a Cell - How is a TextBox-Value in an UserForm written in a Cell during the editing?

•           Fill TextBoxes in UserForm upon startup. - How can I fill 5 TestBoxes in an UserForm when running a Dialogue box to attain values?

•           Accept only AJM in the TextBox and count the Number - How can I limit a TextBox in a UserForm to only allso the Symbols A, J, and M, and also to show the number of these symbols in a label?

•           New Element in ComboBox - How can I expand the ElementList of a ComboBox around one Element?

•           New UserForm with County after City - How can I view both the Countys belonging to a new Userform as well as the selection of a City in the ComboBox?

•           Move Rows conditional on SpinButton - How can I move Rows of a Worksheet below or above by pressing a SpinButton of a UserForm?

•           FileNames in ListBox - How are the Files of the current Directory listed and sorted in a ListBox of a UserForm?

•           Call a new UserForm in dependent upon the ComboBox-Selection - How can I call a second UserForm in dependence on the selection in a MultiColumn-ListBox?

•           Worksheet in UserForm - How can I select a Worksheet with Rows and Columns on a UserForm?

•           Change TextBoxes- and Label-Values in relation to each other. - How can I change the Values of Labels and TextBoxes in an UserForm in relation to each other?

•           Enter a tick in a Cell when a CheckBox is activated - In what way is a tick entered or deleted in the Cell next to a CheckBox when this CheckBox is activated?

•           List only Cells with contents in a ComboBox - How can I take only the Cells that are not empty out of a WorksheetColumn in an UserForm ?

•           Call a ListBox as PopUp-Menu "Cell" - How can I replace the PopUp-Menu "Cell" with a UserForm including a ListBox from which the selected value is entered in the active Cell?

•           Fill ComboBox2 dependent upon ComboBox1 - How can I fill a second ComboBox in a UserForm dependent upon the selection in the first ComboBox?

•           Enter Dates in a Worksheet of a Year - How are Riding Practices with information about Time, Rider and Horse entered in a Calendar?

•           Search for a Value in a Worksheet and output it in a UserForm - How do I use a UserForm to search a Worksheet and then display the result on a Label on the same UserForm?

•           Only Letters in an UserForm-TextBox - How can I limit the input in a UserForm-TextBox to letters only?

•           Show an UserForm in dependence on a RefEdit-Selection - How is a second UserForm shown in dependence on the via a RefEdit-Box of a UserForm taken selection?

•           Show a Wait-Message during the running time - How can I make Excel 5/7 show a Wait-Message during the working on a Code?

•           MultiColumn ComboBox - How can I fill a multicolumn ComboBox with Values and read out the selected Row after the Call?

•           Filter out selected Data - How can I select Terms via ComboBoxes on which a Worksheet should be filtered? The filtered RecordSets should be taken on a new Worksheet.

•           Read a Text out of a UserForm-TextBox into a Variable - How can I read the Text of an UserForm-TextBox into a Variable and use it further? The Input in the TextBox should also be limited.

•           Change the color with a MouseTouch - How can I change the Background Color of a Label in a UserForm while the Mouse is moving across the Label?

•           Read a MultiSelection out a ListBox - How can I determine the selected Elements of a MultiSelection out of an UserForm-ListBox, neutralize the Selection and delete the Elements?

•           Dialogue sheet as FilterMask - How can I call an Excel 5/7-Dialogue for the CriterionInput of selected Data? The filtered Data should be listed in a new Worksheet.

•           Leaf through a MultiPage-Control - How can I leaf through a MultiPage-Control via VBA?

•           Prevent non-numeric values in a TextBox - How can I prevent the entry of non-numeric values in a Text Box?

•           Read an individual symbol out of an Input Box entry - How can I read an individual character from an Input Box entry.

•           Limit a Text Box to 6 characters - How can I limit a Text Box to only allow 6 characters?

•           Populate a Combo Box with months - How can I fill a Combo Box with the months of the year?

•           Insert quantity of rows as requested. - How can I request a quantity of rows to be inserted, and then insert them, using VBA?

•           Hide and unhide a combo box depending on the value displayed in another combo box - How can I hide or unhide one combo box, depending on the value being displayed in another combo box?

•           Query the selected Columns - How can I see which columns are involved within a selected range?

•           Display workbook names of active; view sheet names of closed files. - How can I list the workbooks that exist in the active file path, and see the names of their worksheets?

•           Take horizontal arranged Elements on a ListBox - How can I get a list box to display values that reside in a dynamic row?

•           Change List Box inputs - How can I change the items in a List Box?

•           Do not close the UserForm when there is no Input -Excel8- - How can I prevent the closing of an UserForm before a TextBox gets an Input?

•           Address all CheckBoxes of an UserForm -Excel8- - How can I include all CheckBoxes of an UserForm in a For/Next- Loop?

•           Cell Contents as Label in UserForm -Excel8- - How can I determine certain Cell contents as an Inscription of a Label in a UserForm? If the CellContents show an Error-Message these should not be taken over.

•           Select a ListBox-Input through MouseMovement -Excel8- - How can I change the Selection in a ListBox of an UserForm with the Movement of the MousePointer, but without clicking the MouseButton in Excel8?

•           Determine a Data bank for a DataMask - How can I pre-determine a Data bank-Field among the VBA-Call of the Excel-DataMask?

•           Take Values on a ListBox of an UserForm -Excel8- - There are Values in a Column which can exist numerous times and that are divided by EmptyCells in unregular distances. How can I take these Values without taking them twice and withouth the empty cells?

•           Test the name of the calling Button - How can I use a Button that calls for a Procedure to select certain Cells?

•           Fix the names of the Buttons after copying -XL8- - When I copy a Worksheet with Buttons and ClassModules belonging to them in another Workbook in Excel8, the Buttons lose their set Names. So the assignments do no match. How can I give buttons initial names?

•           Sum after the CheckBox-activation - When I activate a CheckBox in Column A the Sum of the Values of this Row up to Column C should be entered in Column B. How do I do this with a VBA-Code?

•           Add a Dialog Sheet - How can I - especially in Excel8 - add a DialogSheet (not an UserForm) using VBA-Code?

•           Enter Ticks - How is a Tick entered or deleted in a Cell of a Workbook when I click on a CheckBox?

•           Call a DataMask - When I open the DataMask with a VBA Macro with the Command "ShowDataForm" in the Worksheet as DD.MM.YY, formated Dates appear in the English Style. Can this be prevented

•           Permit only numeric Inputs - How can I set a TextBox to only allow numeric characters on a Userform?

•           All DropDowns on Position 1 - How can I In EXCEL 5.0/7.0 how can I determine a Procedure, that with opening a Dialogue, all DropDowns show the first Element of the List?

•           Enter an Area in a TextBox - How can I make a Field Quotation in a TextBox of an UserForm by selecting the Area in the Worksheet with the Mouse ?

•           Access to Elements of a UserForm in a Loop - How can I access to separate, before created through a VBA-Code Labels and determine their Caption new in Excel8?

•           Extract Text from a textbox to Cells -XL8- - How can I extract Text from a Textbox to Cells?

•           Count the Names of TextBoxes - In what way are the Names of TextBoxes - Form: TEXT01 - counted about 1 when I press a Button?

•           Select and open Files from a ListBox (XL8) - How can I select File Names out of a User Form MultiSelection Listbox and open the selected files in succession?

•           List found cell addresses in a list box on a user form. - How can I find cells that contain specific values and then list those cells within a list box on a userform?

•           Fit a UserForm to an Excel Window - In what way can I fit a UserForm to cover the entire Excel application window?

•           Hide Excel while calling a dialog - How can I hide Excel when I open a Dialog box?

•           Determine the condition of Worksheet CheckBoxes - In a Worksheet, the CheckBoxes I use are stored as "OleOjbects" in the VB Code, but "OleObjects" do not have the "Value" Property. How can I determine the value of the CheckBox?

•           Print to a Dialogue to a selected Column - I have a Dialogue Box with series of CheckBoxes that describe Columns in a Worksheet (Name, First Name, Zipcode, Place etc.). After closing the Dialogue, the Columns whose CheckBox is activated should be printed. How do I do this?

•           Divide in a Dialogue entered Files into Variables - How can I divide in an InputBox entered Data into Variables? The Semicolon should be the Separator.

•           Unhide and hide Rows and Columns with a Button (XL8) - How can I manage the hiding and unhiding of Rows and Columns with a Button in Excel 97?

•           Unhide and hide Rows and Columns with a Button - How can I hide and unhide Columns using a Button?

•           List Excel-Files in a UserForm - How can I display the Excel File Names of a Directory in ListBox on a Userform by clicking a button that is alson on the UserForm?

•           Hidden Password-Input - How can I format a Dialogue Input Field to display stars instead of the characters for a password?

•           Cursor Movement after DropDown-Selection - I filter Data and read them afterwards in a DropDown-Element. After the selection in the DropDownBox the Cursor should go to the respective RecordSet in the Source File not to the filtered File. How do I do this?DropDown-Element. After the selection in the DropDownBoxthe Cursor should go to the respective RecordSet in the Source File not to the filtered File. How do I do this?

•           Several Buttons for one Macro - I have a Worksheet where 4 Buttons are linked to one Macro. How can I determine which button is the one being used within the Macro?

•           Read filtered Data in a ComboBox - When I read in Data into a multicolumnic ComboBox over a loop with Autofilter, how can I ensure the invisible data is entered?

•           ComboBox as Symbol - In Excel8(97), how can I reduce a ComboBox to an Icon in a Worksheet?

•           Fill the Datamask with zeros when it is called - In most of the Fields of a Datamask you have to enter zeros. Can I pre-determine them without entering the zeros in the Worksheet before?

•           Read in the names of Worksheets and place in a ListBox - How can read in the names of Worksheets from another Workbook and place them into a ListBox within the current Workbook?

•           Chart in Userform - How can I place a Chart in a Userform?

•           Delete the empty Areas on the left Margin of InputFields - How can I suppress the default empty space on the left margin of InputFields?

•           Multiple choice from a ListBox - How can I choose multiple selections from a ListBox in a Worksheet?

•           Set Variable to contents of textbox - How do I assign the contents of a textbox to a variable?

•           Run an AVI file from a user form. - Call a user form, and click the command button to run an AVI file.

•           Userform list box populated by date selections - In a userform, a start date and end date shall be specified in order to list records that fall between those dates.

•           UserForm called by Selection event - Select a cell on row 5 for a userform to appear, from which to choose standard or customized data entry.

•           Userform recognizes row of button - From a userform, enter values in the row belonging to the button that called the userform.

•           Userform text box number format - Format a number in a userform text box upon exiting the text box.

•           RGB color adjustment - Adjust the background color based on red - green - blue (RGB) combinations.

•           Userform sets focus to the worksheet - Userform provides for the ability to set focus on the worksheet while the userform remains visible.

•           Interactive display of range selection - Click the button for an input box by which you can select a range. Once the range is selected, click OK and a message box shall display the range address.

•           Open dialog customized - Show the Open dialog and have it set for Files of Type being Text, Word, or Excel.

•           Text box allows only date. - Upon exiting a user form text box, the value is evaluated to make sure it is a date. If it is not a date, a "Date only !" message will appear in the text box.

•           Display the workbook's name and access date and time in a userform's label caption. - When opening a workbook, display in a userform the workbook's name, and date and time you are opening it.

•           ComboBox width - The width of a UserForm's ComboBox is to be determined and adjusted to fit its widest item's value.

•           ListBox selection based on TextBox change - A ListBox item shall be selected based on the letter(s) entered in a TextBox.

•           TextBox entry populates custom ListBox - Entering an Article Number from a list of many article numbers shall populate a ListBox with only the records for the Article Number entered.

•           TextBox calculation - Apply a function to a TextBox numeric value and calculate a new result in the same TextBox.

•           Data transferred between UserForms - A UserForm is called, and the selection in its ComboBox can be transferred to the TextBox of a second UserForm.

•           OptionButtons set to False - Make every option button False (deselected), regardless of what frame or grouping it is in.

•           Input the value from a closed workbook into a userform text box. - Import the value of a closed workbook's range into a userform text box.

•           Multiple columns displayed in UserForm controls - Three columns of a recordset are displayed together in a ComboBox, and separately in dedicated TextBoxes.

•           Cell text read into Help file TextBox - The text in cell A1 shall be transferred to a userform TextBox, as an idea for creating a Help file.

•           Calendar control - A calendar control shall display the current date when the userform is Initiated.

•           Three-dimensional Label control - Give a Label control's caption text a 3-dimensional appearance when the Label is clicked.

•           Spinner and Label control display cell address and values - With a UserForm SpinButton the values from column B are to be read into a text box, with the address read into a Label control.

•           Spreadsheet control in userform - Display a worksheet range in a Spreadsheet control of a userform.

•           Values of Option Buttons grouped separately - Option buttons that are labeled the same but grouped separately can be evaluated separately for TRUE (selected) or FALSE (not selected).

•           String concatenation from different controls - Enter an 11-digit number and select a country from the combobox. The country code (from the table on Sheet2) and number you entered shall be transferred to the active cell.

•           Dialog multi-select - Return the file names of those you can multi-select in the Open dialog box.

•           Userform TextBox value added to cells - A userform with 3 text boxes shall have the numerical values added to respective cells.

•           Userform text box calculation - The values in two text boxes are multiplied, and that value is placed in one cell, with the date in another.

•           Populate combobox with filtered records - The table shall be filtered via a userform, and the combobox in the userform shall be populated with the filtered records.

•           HTML text loaded into a userform textbox. - In a userform textbox, the text of a website's URL shall be loaded.

•           Label control calculation as caption - A number entered into the text box shall be converted to a percentage, and calculated by subtraction from a static factor to represent a percentage difference as the caption of a second label control.

•           ListBox values populated and entered in next row - The values in column A are listed in a ListBox on a userform. The act of selecting an item in the ListBox shall result in that item being entered in the next available row of column C.

•           User form with scrolling text field - A user form is to be called, whose text shall scroll as a marquee.

•           Populate a MultiPage control - Populate a 3-page MultiPage control with the respective values from columns A, B, and C.

•           Populate a combo box with percentage values - In a userform on initialization, populate a combobox with percent values listed in a source range.

•           Spreadsheet control - Demonstration of spreadsheet control to display a worksheet range in a userform.

•           Show a userform for 5 seconds - Call a userform, have it display for 5 seconds, then automatically unload itself.

•           Data transfer from list box to worksheet - In a userform, select a column by its number in a combo box, and click on a value in the list box that will be entered into the next available row of the selected column.

•           UserForm screen shot - Show the range C6:D8 as a screen shot in a userform's Image control.

•           Distribute text box data to worksheets - User form text box data is to be distributed on sheets you specify.

•           Populate combo box and table - Enter a single digit to populate a userform combo box, then select from items in a combo box beginning with that digit to populate a data entry table.

•           List box multiselection - In a userform list box, force 3 items to be concurrently selected for the OK Command Button to be enabled.

•           CheckBoxes: enable with caption, or disable - CheckBoxes in a userform are disabled, or enabled with captions of populated cells in a range.

•           Filter dates - Filter for "between" dates, by entering the date criteria in userform TextBoxes.

•           Time entry in userform textboxes - A userform with 3 textboxes is used to record time entries, and allows for one of three hours quantities ("##:##", "###:##", or "####:##")

•           Userform maintains retail stock inventory - Userform records and updates stock inventories of exchange and return items.

•           Userform listbox disallows selection of dissimilar dates - Only data records having the same dates in a userform listbox may be selected with each other.

•           Quiz exam with userform as interface - Set up a userform as a way to build a quiz workbook, for questions to be answered and then scored.

•           Insert special characters at textbox insertion point - Ctrl+R (for the Registered Trademark symbol) and Ctrl+T (for the Trademark symbol) are entered in a userform text box, at your choice of insertion point.

•           Find text and mark its cell location - Populate a userform's labels with cell address location(s) of a found text string.

•           ComboBox selections trigger calculation in worksheet and TextBox - In a userform, two ComboBoxes shall be populated with values, one from column A and the other from column B. When a number is selected by either ComboBox, a calculation will be returned in a worksheet cell and in the userform's TextBox.

•           Ref-Edit control limited to one cell - A userform provides a RefEdit control which allows only one cell to be referenced at a time.

•           Add two-dimensional elements to a ListBox - Using two TextBoxes (one per item element), add two-dimensional elements to a ListBox.

•           Limit the quantity of words in a TextBox - Limit a userform TextBox to a maximum number of words, 10 in this example.

•           Create a new TextBox control and read its text. - In a userform, create a new TextBox, and provide for its text to be displayed in a Message Box.

•           Selected items in ListBox are transferred to another worksheet - Multiple-selected item values in a ListBox are to be transferred to another worksheet.

•           Userform with TextBoxes for optional entry of data into cells - Userform called by keyboard shortcut holds TextBoxes that allows the option for cells to be populated by suggested data or by data the user edits.

•           Search and select a ListBox record item by searching its value on worksheet - A userform ListBox holds records in the table that are three columns wide. A record shall be selected in the ListBox by entering that record's value for column A in a TextBox.

•           Reactivate a hidden userform to display incremented value - A userform can be unloaded or hidden. If it is hidden, the controls will be cleared but upon reactivation a Label control's caption shall be numerically incremented by 1.

•           AVI played in userform - An AVI file shall be played in a userform.

•           Force and display date and time from TextBox entries - A userform with two TextBoxes, one for data and one for time, force a user to enter those values in a certain shortened format, and then display the two values in a longer format in a Message Box.

•           Excel5 dialog example - An Excel5 dialog with EditBox and DropDowns return a corresponding value from a two-column list.

•           Search for value in list from userform TextBox. - A TextBox in a userform provides for a value to be entered and searched for in a list. If the value is found, that cell is activated. If the value is not found, the user is advised of that fact.

•           TextBox accepts decimalized time for format conversion to conventional time - Enter time as a decimalized portion of the day, then click the "Display time" button to display the time in the TextBox in h:mm AM PM format. Example, for 6:00 AM, enter .25, for noon enter .50.

•           TextBox values parsed at character intervals - A userform has two TextBoxes. Data entered in the first TextBox will appear in the second TextBox parsed by a space character separating each group of four characters that got entered.

•           Userform TextBoxes accept certain data and transfer data to worksheet - Userform TextBoxes accept certain data and transfer data to worksheet.

•           Display the same data element in 3 different userform controls - Display the same data element in 3 different userform controls at the same time, by loading a ComboBox at Initialization, and displaying a changed ComboBox value in a TextBox and Label caption.

•           ListBox's MultiSelect and ListStyle properties are changeable - The MulitiSelect and ListStyle properties of a userform's ListBox are customized in the userform.

•           TextBoxes values for first and last names are searched in table - In a userform, two TextBoxes allow for a person's first name and last name. If that full name exists (or does not exist) in a table, a message will appear on a Label control to advise you of that fact.

•           Print the image of a userform - A userform's image shall be printed in landscape format.

•           TextBox formatted with alphanumeric data - A TextBox is custom formatted when a certain sequence of numeric and alpha characters is entered.

•           ListBox displays cell values as separate items, split by given character - A ListBox shall display cell values by separating each value into two parts, at the point in the value where a "carriage return" character (ascii #10, created by Alt+Enter) exists.

•           Force records entry based on unique field value - A userform records a list of customers, first making sure the Customer Number is not a duplicate.

•           Register values on sheet next to ListBox item values - How can I set up a userform such that a ListBox is populated with the list of values in column A, and a TextBox is provided for a value to be entered that will be posted to the cell in column B next to the selected ListBox item(s)?

•           One ComboBox's list depends on the other ComboBox's selection - How can I have two ComboBoxes on a userform, and have one of them display a field list from a worksheet table that would depend on the value item selected in the other ComboBox?

•           Toggle for a value - A userform holds a toggle button that, when clicked, displays a Message Box for True or False based on the status of the Toggle control.

•           ComboBox populated with unique sorted items - How can I populate a userform ComboBox with sorted, non-duplicate item values, while ignoring empty cells in the source data range?

•           Count and identify selected CheckBoxes - I have a userform with many CheckBox controls. How can I determine how many CheckBoxes were selected, and identify the selected ones by their captions?

•           Move ListBox items up or down - For a userform ListBox, how can I select an item, and use command buttons to move the item up or down in the list?

•           Programmatically create a userform - How can I programmatically create a userform?

•           Open file via dialog or text entry - How can I design a userform with controls that allow me to open a file by first identifying it either by calling the Open dialog, or by manually entering the path and file name in a textbox?

•           BeforeDrag event for textboxes - In a userform, how can I display one textbox's text in a label control when said text is being dragged into a second textbox?

•           Modeless userform simulation - How can I simulate modeless behavior in a userform when calling a dialog?

•           Search Google - Search Google for terms from userform.

•           MouseMove event makes Label captions visible - How can I set my userform to make the Label control captions visible when I move my mouse over the photograph that is set onto an Image control?

•           Userform without "X" Close button on title bar - How can I design a userform such that its title bar does not have the "X" Close button?

•           Specify fields to display in ComboBox - From a recordset of 10 fields, how can I specify a limited quantity of those fields for which I actually want to display records in a userform ComboBox, and in any order I want?

•           InputBox method to enter certain data - How can I call the InputBox method based on options selected in a userform to enter data that would either be numbers only, or alphanumeric text?

•           Select row based on two ComboBox selections - How can I select the row whose first name value in column A and last name value in column B match the selected values in two ComboBoxes on a userform?

•           List pop-up menus and command IDs - How can I populate a userform's ComboBoxes with Excel's pop-up menus and their local command ID numbers, and then be able to list them in a spreadsheet?

Event Handlers

•           Avoid double entries of room reservations - After entering a room number, it shall be checked if the room is available for that time.

•           Set up background color with color index list - If the entry of column A is found in column B of the sheet color index, the cell background is to be determined with the respective color index

•           Move row into worksheet after entry of worksheet name into row - When entering a sheet name in column D, the row of the entry is to be moved to the respective sheet

•           Set background color depending on value verification - For entries or changes of formula values, a proof with the prior values is to be initiated. If the new cell value is higher, the background color shall change to

•           Search for value in second table and display as a comment - The entry text from an entry in column A is to be searched in column A of sheet2 and the values of the neighbor cells are to be displayed as a comment in the cell below.

•           Set up validation list with criteria - If "months" is in cell B1, the validity list from column A is to be limited to months and if "days" to be limited to weekdays

•           Set up yellow background color for header in an AutoFilter table - When filtering a column, the header row is to be highlighted with a yellow background color

•           Set up background color of active cell - When moving the cursor up or down, the background color of the active cell shall change to yellow

•           List of entry data in an other table - Entries in column B of the data sheet are to be listed in a second sheet with up to 20 entries.

•           Display message if column total is exceeded. - If total of values in entry area cell 9 to cell 22 exceeds 7.5, a message is to be displayed.

•           Display a record with a right mouse click - The row of an active cell is to be displayed in a message box with a right mouse click in columns A:E

•           Replace value from validation list with a number - The selection from a validity list in column D shall be replaced by a number. Works only with XL9 and higher.

•           Prevent entry of invalid values - Entries of invalid values in area A1:B6 are to be prevented, in case of an error a respective message box to be displayed.

•           Reset filter before saving - Reset all filter criteria in all worksheets when saving a workbook.

•           Fill other cell with cell entry - When entering an "x" or "y" in area K21:K51 dashes are to be inserted in columns C and D

•           Message when exceeding a date - If the difference of the calendar weeks of the values in cell A1 and the current date in B1 is bigger than 2, a message is to be displayed when opening the workbook

•           Cell protection only for formulas - Only cells with formulas are to be protected. New entries are recognized and also protected.

•           Recalculate after change of background color - The Formula in cell D1 is to be recalculated after change of the background color in area A1:C8.

•           Blue underline, if value is different from the value in the prior cell - If value in cell A is different from value in cell underneath, draw a blue line around the entire data area

•           Open workbook with double click on link - With a double click on cell E13, the link in that cell shall open a workbook. Correction of path and file name necessary

•           Entry of complaints via complaints code - After entering of the tour number, running number and complaint code the data from columns C, D and F from the tour list are to be inserted in the sheet complaints. The transmission takes place after input of complaint code.

•           Record changes in protocol sheet - Changes in this worksheet are to be tracked with their cell address and prior value in the sheet "Log".

•           Memory in cell comment - If changing the value of a cell, the background color of that cell shall change to yellow, cells without value change to green background color. Save all prior values in a comment.

•           Row action with double click - If double clicking on a cell, the value from row 1 of the double clicked column is to be multiplied with the rownumber and displayed in a message box. At the same the cell is colored red.

•           Open macro with activating AutoFilter. - Opening of macro with activation of AutoFilter

•           Conditional retrieve of a validation list - Only if values in cells A1:C1 are each are 10, list from D1:D12 is to be taken as validition list when cells A3, C3, A5 and C5 are selected.

•           Search and enter article number with input box - An InputBox for entering an article number is to be opened with a double click in columns A:B. This article number is to be searched for in Column B. If found an input box for entering text opens. This text is entered in the cell next to the one found previously.

•           Allow only entries in current month - Cells in column B are only to be edited, if their neighbor in column A has a date of the current month.

•           Sort cell entry automatically - Sort columns A:D if an entry is done and all four columns of the relevant row have entries.

•           Deactivating and activating of Drag&Drop - When opening a workbook, the Drap&Drop feature should be deactivated, after closing the workbook, the feature should be reset.

•           Proof group of numbers and send message - Entries in column A are to be proofed if the name group of the first 3 digits in column A in sheet "Data" exists. Solution displayed as message.

•           Change of value in cell B1 after calculation of formula in cell - After calculating formula in cell B1, value from B1 shall be increased five times and entered in cell C1

•           Set worksheet protection when saving - After saving it should be impossible to change cells with content.

•           Select first worksheet when opening a workbook - When opening a workbook, the first worksheet should be automatically activated.

•           Open macro with double click depending of a cell address - Various macros are to be opened depending on a double clicked cell

•           Display message after pre-determined number of minutes. - Display a message after a specific number of minutes entered in the UserForm box

•           Check, if data are already existing and give a message - Entries in column K are to be verified, if in an other row the same name with the same date and time appears. If so, a message is to be displayed.

•           If entry is an X, then copy row to other table - If entry is an X in column R, respective row is to be copied to end of sheet2. The row is to be deleted in the source sheet.

•           When condition is met, display in color for one minute - Change background color to yellow for one second, after entering value in A1 and value is different from value in B1

•           SREFERENCE as event procedure - When entering a number in column A -if existing- the respective value from Sheet2 is to be inserted in column B:C

•           Message after insert or delete of a row - After inserting or deleting rows above row 21, a message is displayed.

•           Copy row depending on entry in sheets - If a "K" is entered into A2, the row is to be copied to Sheet "ab." If a "W" is entered, the row is copied to Sheet "xy." The background colour of A2 is to be set in both to red.

•           Transfer values from one cell to an other with F6 - How can I transfer the value of cell A1 to cell B1 with function F6

•           Name row in user form with double click - Open a user form and name opened cell with double click in area A1:A10.

•           Background color depending on weekday - Background colors in column A are to be set depending on numerical weekday entries in that column.

•           Enter date when a specific value is reached - If the value of the formula in column A exceeds 10, the current date is to be inserted in B1

•           Compile date from different cell values - When entering a number in E10, year and month shall be inserted based on values from cell L1 for the year and L2 for the month

•           Enter values from input sheet in respective month sheet - Entries in cells C8:E8 are to be entered into the worksheet named in cell B8 in the next free cell

•           Search for value with double click on table - Search for search phrase from cell C5 in columns D:F with double click and select found place

•           Limit the possibility of input to 255 Symbols per Cell - How can I stop more than 255 Symbols from being entered into one Cell?

•           Automatical sort after a Cell Input - How can I make a Worksheet sort automatically after Cell Inputs?

•           Date-Message with opening the Workbook - How do I make sure that a List with Dates is checked when opening a Workbook and a Message is shown when it matches with the current day?

•           Divide the Cell Inputs in groups of 5 signs - How can I divide Inputs in Cell A1 in groups of five signs and enter them in other Cells?

•           Take Cell Inputs automatically on the Header - How can I set the Inputs in certain Cells of a Worksheet automatically to the Header?

•           Save and close a Workbook 15 seconds after opening - How is a Workbook saved and closed automatically 15 seconds after opening it?

•           Allow/prevent Inputs depending on third Cells - How can I make sure that cell inputs of a set Area are on the condition that an input must be in a specific cell?

•           Change Value according to an OptionsField-Selection into EURO or DM - How can I convert the Values of Column A of a Worksheet depending on the selection in two OptionFields into EURO or DM?

•           Add a Graphic after the Input of the FileName - How can I fit the Graphic in the Worksheet after I have entered a Graphic FileName in Column A?

•           Switch off the Computer at a set time - How can I end all programs and switch off the Computer at a certain time?

•           List the Values of a Matrix in a second Worksheet - How can I list the Values of a Matrix in the first Worksheet as List in the second Worksheet?

•           Show the actual spent working time - How can I view the actual time spent working of the day in a Cell?

•           Jump to the beginning of the month after a DoubleClick - How can I make the Cursor jump to the respective month in the Worksheet when I double-click on a month in Row 1 ?

•           Output the Date via keyboard in the Modus 1-1 as DD.MM.YYYY - I enter the date via keyboard in the Modus 1-1 into a Worksheet. "01. Jan" is shown as a result. How can I make the output look as follows: DD.MM.YYYY ?

•           Disallow entry or edit of cells while cell A1 is empty - Using a WorksheetChange event, a value must exist in cell A1 in order to enable any other cell to hold a new or edited entry.

•           Take Data after the Input of a month - When I enter a month in a certain Cell, the Data of a second Worksheet belonging to it, should be read in the actual Worksheet.

•           Check the Standard Font Size and set the Zoom with opening - How can I check the Standard Font Size when I open a Workbook and set the Zoomfactor depending on it?

•           Value-Increase in protected Cell of a protected Sheet - How can I perform increases in value in protected Cells of a protected Worksheet via a DoubleClick?

•           Show the Data of the current Row in the Excel-Datamask - How can I view the Data of the current Row in the Excel-Datamask after a DoubleClick?

•           Message when the limit is passed with an HourInput - How can I view a Message when I reach a limit with the Input of hours and reset the Input to 0 ?

•           Prevent the double Input of Values - How can I prevent Values, which are already there in an other Cell, from being entered into Column A? The Input of Strings including a "y" should be prevented as well.

•           Create and arrange a second Window with opening - How can I open a second Window to be Worksheet2 of the Workbook and view both Windows, in a certain size, when I open a Workbook and reset this condition when I close the worksheet.

•           Multiply the Inputs in B:D automatically with 6 - How can I take the inputs in the Columns B:D and automatically multiply by 6?

•           Event triggered by a worksheet calculation - How can I trigger a macro based on a Calculation event, for example when a returned value is greater than 100?

•           Copy an Area that depends on a key number - How can I get an Area of the Worksheet "Mask1" copied in the current Worksheet when I enter a 1 and an Area of the Worksheet "Mask2" copied when I enter a 2 ?

•           After the Input of "x" the Cell below should be bold - How can I make the trailing cells bold if there is an x in the current cell?

•           Fit something from a price list into an OrderForm via a DoubleClick - How can I get a price-list-position that is taken on an OrderForm via a DoubleClick on it, so that there only the number of pieces have to be entered? The Formulas for the

•           Mutual entry of two accounts - How an I make mutual entries of two accounts - for example till and bank ?

•           ArrowColor and -movement dependent on CellValues - How can I manipulate an arrow with the following conditions: - When A1<B1 then arrow red down - When A1=B1 then arrow yellow left - When A1>B1 then arrow green up

•           Dynamic postcode data bank - How can I create a dynamic postcode data bank? When I enter an already known postcode the place belonging to it should be entered, when the postcode is unknown a Dialog for the Place- Input should be called and the postcode and the place should be entered in the data bank.

•           Update the Carreservingplan after DateInput - How can I enter the respective driver in a Carreservingplan after entering an Enddate in the relevant period?

•           Show the UserForm with the updated Values after an Input - When inputting values into Column A, how can I call a UserForm where I can view a ListBox with all the updated Values?

•           Signal, when the FormulaValue moves over a limit - How can I hear a signal when the Value of a Formula rises over 0?

•           Sort the Worksheet according to the Date-Input automatically - How can I sort a Worksheet automatically according to a Date- Input in Column A?

•           Mutual duplicating of WorksheetInputs - How can I make my inputs in Worksheet I be placed into Worksheet2 and vica versa? If the worksheets are different on the sheets, that must be taken into account.

•           Take the Inputs of the first Worksheet on other Sheets - How can I take the inputs of column B of the first worksheet and put them in column E of all worksheets?

•           Delete other Values with Input - When I input a Value in a set Area, how can I delete the previous value?

•           Emphasize the Row with the Cursor in, with Color - How can I emphasize the Row, in which the Cursor is, with Color?

•           Select the Worksheet via Cell-Doubleclick - How can I jump to the relevant Worksheet when I double-click on a Cell with the Worksheetname?

•           Ascertain if the Delete button was pressed - How can I ascertain if the Delete Button was pressed in Cell A1?

•           Change the Cursor into an eggtimer in a certain Cell Area - How can I change the Cursor into an eggtimer whenever it is on the Columns D:F?

•           Record CellInputs in a Worksheet that isn´t visible - How can I record each CellInput with some information about the name of the user, the date and the time in a non visible Worksheet?

•           Synchronize control of CheckBoxes in 2 Worksheets - How can I synchronize the CheckBoxes in two Worksheets? When a CheckBox is activated or deactivated in one Worksheet the same setting should be follow in the other

•           Select a certain CellArea with every change of the Cell - How can I select the active Cell and the 9 Cells right around it with every change of the Cell?

•           Fill the Cells below out of Worksheet 2 by Inputs in Row 1 - How can I search for the Input in Column 2 of the second Worksheet by Inputs in Row 1 and enter the Values that are right the place of finding below Row 1?

•           Call a Macro by exceeding a Value - How can I call a Macro when a certain Formula contained Cell's value is exceeded?

•           Search for a Value in a second Worksheet and enter the Row of find - How can I search for the Value of an InputCell in a second Worksheet and copy that Row ?

•           Test an Input if it is already existing and add it in if not - How can I check CellInputs if the Value is already existing in a List and add it to the end of the List if not?

•           Ascertain, if a Button was pressed with the Shift-Key - How can I ascertain if a Button of a Worksheet was pressed with or without the Shift-Key held?

•           Copy the current row after an input in Column A. - What do I have to do make the current row copy to the first empty row of a second worksheet when I enter anything in Column A?

•           Show the maximum value in Column A of numbers in Column B, - How can I show the maximum value in column A of a list of numeric values in column B?

•           Auto sort a range as its cell contents change. - How can I sort the values in a range when a change in values is made to one of the cells in that range?

•           Display "Yes" after the Input of "y" and "No" after entering "n" - How is the Input "y" in Column A changed to "Yes" and the Input "n" changed to "No"?

•           Transfer a cell's value to a text box. - How can I take the value in Cell A1 to automatically place itself into a Textbox on the Worksheet?

•           Activate cell in row 1 of next column after entry past row 11. - How can I automatically activate row 1 of the next column after after entering data in a cell past row 11?

•           Check what drivers are available at what time(s). - By entering a date, start time, and end time, how can I see what tour drivers are available, and which ones are not?

•           Copy a column into a second worksheet by a double click. - How can I copy the entire column into a second worksheet by double-clicking a cell?

•           Change cell value, see total of that value plus prior value. - How can I display a total value that is equal to a cell's current value plus the value that was in the cell before it was changed?

•           Change the font size of the active when selecting the cell. - How can I change the font size when I select a cell, and reset it back to its original size when I leave that cell?

•           Alerts when a Workbook is closed - How can I ask if the File should be saved as the written name in Cell A1 whenever a certain Workbook is closed? When the File is already existing an Alert should be done.

•           Show the Context menu with the Inputs of a List after a DoubleClick - How can I view a Context menu with Inputs of a List of a second Worksheet by a DoubleClick on a Cell? The selected element should be entered in the Cell and the number of the elements that are in a row should be counted in the second worksheet.

•           Run CheckBoxes in a Worksheet via CellInputs - How can I run a series of CheckBoxes in a Worksheet depending on CellInputs?

•           Copy in lines from Sheet to Sheet - How can I copy the active Row to another Worksheet by a DoubleClick and/or a Press on a Button?

•           Make a note of a Value of a certain Cell - How can I have Excel remember the Value of a certain Cell? After heading the original Value this should be shown whenever the Cursor is on the Cell.

•           Switch off the Workbook_Open-Procedure with the VBA-Call - How can I switch off the Workbook_Open-Routine when I open a Workbook via VBA?

•           Interior Color according to the Input Value - How can I set the Interior Color to Yellow when the Input Values are larger than 10, all others to Normal? The conditional Formatting shouldn´t be used.

•           Enter the Values of Cell A1 in a List every hour - How is the Value of Cell A1 entered in a List every hour? The first Input should be done at 05:00 am.

•           List the contents of a Cell in a Column every minute - The Cell A1 contains a DDE-Link to an external Program that is updated every minute. How can I list the updated Data in Column C every minute? In Column B the current date should be entered.

•           Enter the Values in the next Cell after the Input of a short Term - What do I have to do to copy data from a second worksheet into two cells right of the input cell depending on the short term?

•           Prevent the edit of Cells through a DoubleClick - How can I prevent the editing of Cellcontents after a DoubleClick without using the SheetProtection?

•           Create Worksheets for the working days of a month - How is a Worksheet generated for each day of the current month through the Input of a year or month? The Worksheets should have the day and the weekday as names.

•           Enter the original file open date in the Registry - When the workbook is first opened, that date will automatically be entered in the Registry. Evaluate the date each day thereafter that the workbook is opened. When the Registry date is more than 35 days older than today's date, force the workbook to close.

•           Enter the Date conditioned by opening the Workbook - What do I have to do to check if the Cells A1 and B1 contain Values when a Workbook is opened? When A1 isn´t empty and B1 is empty the current date should be entered in Cell B1.

•           Open a Folder in the Explorer on a DoubleClick - How can I open the Explorer by DoubleClicking on the Cell named Directory?

•           Play a WAV-File with opening a Workbook - How is a WAV-File played automatically with opening a Workbook?

•           A set Interior Color of the active Cell by moving the Cursor - How can I change the Interior Color of the active Cell variably so that it matches with the movement of the Cursor?

•           Show the continuous time in a Cell and Statusbar - How can I view the current time in a Cell and in the Statusbar?

•           Show the preceding CellValue in a second Cell - How can I view each preceding CellValue in a second Cell when I enter something in a Cell?

•           Record date and time when closing a Workbook - How are the date and time recorded in a Worksheet of this Workbook with each closing of a Workbook?

•           Single Reference accesses on a closed Workbook - How can I access a closed Workbook whose name is in the first Row of the InputColumn via the Input of a single Reference - =F17 - ?

•           Change the Interior Color in the linked Cell - How can I change the Interior Color of a linked Cell, when a new Value is entered in the Source-Cell? Source- and Target Range are in different Workbooks.

•           Record the fitting in and deleting of Rows - How can I count the fitting in and deleting of Rows?

•           Proportional raising through several Worksheets - How can all Values in many worksheets raise proportionally after entering a number in a Cell?

•           Chronological Table - What do I have to do change the Interior Color of the following Cell after entering a Date?

•           Protect the Worksheet from the working on - How can I protect a Worksheet from the working on and the copying of Cells?

•           Fit in a TextBox with Text after a DoubleClick - How can I fit in a TextBox with a Text depending on the Cellcontents after a DoubleClick on a Cell?

•           ScriptColor of a Field in dependence on a Cell - How is the Font color of a cell changed in depending on the Value in a Cell?

•           Report of a Birthday when the Workbook is opened - How can I display the people whose Birthday are today when opening a certain Workbook?

•           Change the Interior Color by entering a Sunday - What do I have to do to make sure that the Interior Color is changed automatically when entering a date of a Sunday?

•           Restoration of the old Cell contents for Values that are not allowed - How can I restore the original Cell contents when Strings have been entered in a Cell in which only numerals are allowed?

•           FaxOrder on the basis of an ArticleList - How can I create a Faxorder on the basis of an Article list? The order form should be completed when I enter an Article number in the form as well as when I enter a number of pieces in the Article list.

•           Input of Articlenumber and Discountcalculation - How can I make Excel import the product name and the price out of another Worksheet after entering an article number? For the prices the discount should be Adjusted from a discount sheet.

•           Linefeed and "X" after DoubleClick - How can I generate a Linefeed so that there is a "X" in the first Row and the original Text in the second Row after a DoubleClick?

•           Ascertainment of the flexible Holidays - How can I find out if the pre-determined date is a holiday?

•           RecordSet after entering a short term - How can I call a RecordSet after entering a short term? When I enter "web" for example the address of the company Weber GmbH & Co. KG should be entered.

•           ColorAdaptation dependent on Input - How can I change the cell font Color in Column B depending on the Inputs in Column A?

•           Enter and delete partial results in a sequence of numbers - How are partial results entered or deleted in a sequence of numbers by DoubleClicking?

•           The Events CellSelection, Input and DoubleClick - How can I call the Macro Commands to the Events CellSelection, Input, and DoubleClick?

•           Take Values from Worksheets dependent upon the Input - How can I take Values from different Worksheets depending on the Input of an ArticleNumber?

•           Filter all RecordSets >= InputValue - How can I filter all RecordSets whose Value in the Input- Column is >= to the current Input in a second Worksheet?

•           Simulate a Bar Chart - How can I change the Interior Color of Cells with CellInputs so that the impression of a Bar Chart is created?

•           Hide CommandBars with opening and unhide them with closing - How do I hide all CommandBars when the Workbook is opened and unhide them again when it is closed?

•           Warning if Value already exists - How do I show a warning message when an Input into a Column already exists?

•           Animation in Excel - How can I create moving Objects in Excel?

•           Set CellContents and Comment after Input - How can I change the contents of a cell by setting it to change with an input of a code in a Cell on a second worksheet?

•           Prevent the selection of a Cell-Area - How can I prevent the selection of a certain Cell-Area?

•           Speak to the Office-Assistant - How can I address and use the Office-Assistant in Excel 8?

•           MsgBox with Values from a closed Workbook - How can I view the Data of an Worksheet whose valuee I have entered out of a closed Workbook in an MsgBox?

•           Flash a Cell - How can I change the Background Color of a Cell each second?

•           Calculate a Workbook every 5 Minutes - How do I set up the Workbook to calculate every 5 Minutes?

•           Distribute with Distribution Key - How can I distribute a Value to Cells with a Distribution Key that must be set?

•           Change two Worksheets simultaneously - How are the Inputs in the one automatically shown in the other Worksheet? There is another problem because one Worksheet is an excerpt of the other that means that

•           Allow an unique Input - How can I allow only unique Inputs in the Cells of a Worksheet?

•           Transfer Data from Worksheet1 to Worksheet2 - How can I transfer Data of a Row from Worksheet1 to the first empty Row of Worksheet2 with a doubleclick?

•           Create a MonthSheet - How are the days as Number and in the Format DDD automatically entered with the Input of the Month or Year? The Routine should identify the Number of the days

•           Start the Macro with the ENTER-Key - How can I start a Macro automatically with pressing the ENTER-Key on the Number Pad?

•           Make the Input of Dates easier - How can I enter Dates in the Format DDMMYY and make Excel convert the Date into the Format DD.MM.YY?

•           Document the Input - There is the stock of goods in Column A and the date in Column B. When the stock of goods is changed the date should be updated automatically. How do I do this?

•           Update the date of a change in a cell - How do I display the date in column B when a cell is changed in Column A of the same row?

•           Display an alert when a certain cell's value is changed. - How can I display an alert when a certain cell's value is changed?

•           Display the date and user name when worksheet is changed. - When a worksheet is changed, how can I record the date of change and the user name who made the change?

•           Display the date and user name when worksheet is changed. - When a worksheet is changed, how can I record the date of change and the user name who made the change?

•           Scroll to the Cell with the topical Date - Currently the DateInputs are in Column A. How can I make the Cell with the topical Date to be displayed as the top Row upon opening the Workbook?

•           Automatically change the header when cell values change. - Automatically change the header when values in cells B6 or D7 are changed.

•           Complete the cell entries - How can I add an accompanying text to a cell after entering a certain number in that same cell?

•           Prevent a value from being entered in same row of adjacent column. - How can I prevent "1" from being entered in a cell of Column A when a "1" already exists in the same row of Column B?

•           Enforce an input of positive numbers only. - How can I force the input of positive Numbers in a UserForm TextBox?

•           Automatically incrementing a number - How can a number value be automatically updated or incremented?

•           Comment that 4 weeks have gone by since the file was last opened. - How can I determine, with the opening of a Workbook, from a certain date that 4 weeks have passed since the workbbok was last opened?

•           Expiration date runs out - How can I prevent the opening of a Workbook after a certain Date?

•           Report repeated Names - I enter CarNumber-plates in a Worksheet in which multiple Inputs are possible. How can I have a MsgBox appear with the plate number if there is already a value in cell?

•           Call Macros by time - How can I call a Macro depending on how long the Workbook has been open?

•           Add the Inputs - How can I add values in a second Cell and count them in a third Cell?

•           Add the Inputs - How can I add values in a second Cell and count them in a third Cell?

•           Convert the Input into Capital Letters - How can I change all the cell inputs into Capital Letters?

•           Convert the Input into Capital Letters (XL5/7) - How can I force entry of capital letters?

•           Call a Macro dependent upon the value of a cell. - How can I call a certain Macro depending on the Cell Value?

•           Perform a Macro on exit of a cell - How can I make Excel run a Macro after leaving a particular cell?

•           Call Macros based on the Name - How can I call Subprocedures dependent on the Names of the Input Cell?

•           Prevent non-numerical Inputs - How can I prevent a user from entering a non-numerical value?

•           Restore to an old value after a false input - How do I ensure that when a user enters a non-valid value that the original value is restored?

•           Disable error in auto_open procedure - How can I disable the auto_stop function when a loaded Workbook isn't found?

•           Add a new Row that keeps the previous formulas and values - How can I add a new Row in a Worksheet, and make sure that it copies the formulas and values from the previous Row?

•           Save the Cellinput - The data in cell A1 is constantly being updated. In order to not lose those entries, how can I log the data in Column B, the date of the entry in Column C, and the time of the entry in Column D.

•           Call a Macro after loading the Workbook - How can I automatically run a Macro after loading a Workbook? Excel 5/7

•           Worksheet change triggered by data validation. - A worksheet change event with a Select Case structure shall be triggered by data validation entry.

•           Workbook open and close with single mouse click. - Open a workbook by left clicking on the command button and holding down the left mouse button. When you release the left mouse button, the file will close.

•           Enable and disable the doubleclick event - For the double click event, turn on or off.

•           Change in column A sorts range on Sheet1 and on Sheet2. - Change the value in column A to sort the range A1:Dx (a dynamic range of varying rows), and also have Sheet2 show the same data, sorted the same way.

•           Open Word doc from data validation sheet change - Select a Word document name from the drop down list in cell D9. Based on the file path you specify in the Sheet_Change procedure, the Word document file name that you select will open.

•           Refresh list box upon sheet activation - The items in a list box shall be the names of worksheets in this workbook. Each time Sheet1 is activated, the list box is refreshed.

•           Selection event to trigger macro - Trigger a macro by selecting a cell in row 3.

•           Sheet activation - go to current date value - Activate a sheet and the cell in column A with the current date becomes selected.

•           SelectionChange triggered in A7; go to A15. - Using the SelectionChange event, selecting cell A7 shall automatically activate cell A15.

•           SheetChange to display formula. - Show a formula from one cell in another cell, through a SheetChange event.

•           SheetChange triggered by cell value - In cell A1 (range named as "Test") is tested for a certain acceptable value range (must be 1, 2, or 3). If such a value is entered, a SheetChange event is triggered.

•           Sheet change selection limited to one row. - The selection of cells involving more than one row shall be prevented.

•           Sheet Change event - Enter a value in cell B1 to change the value by that much in cell A1.

•           Double-click to play .wav file. - Double-click the cells in column A to play the .wav file as the cells' values suggest.

•           Workbook_Open increment numeric value - The number in cell F10 of Sheet1 shall be incremented by 1 each time the workbook opens.

•           Double-click to view or print records. - Double-click a cell to print (or in this example print preview) the values in the row from column A to column E, and transpose them into a vertical range in column A of Sheet2.

•           WorksheetChange triggers placement of value - In cell C1, a number entered between 11 and 99 shall be placed between the bookmark number guides in column A. A subsequent number entered in C1 shall override an existing number in column A between the bookmarks.

•           Calculation event - Calculation event formats cells based on time of day.

•           SelectionChange event creates custom comment text - Utilizing a SheetSelection event, all cells in range A1:D12 shall have all their comments deleted. A new comment will be added to the selected cell whose text is looked up in the table on Sheet2.

•           WorksheetChange event triggers OnTime deletion - Entering a value in cell B1 shall delete the contents of both A1 and B1 in 10 seconds if cell A1 is not empty.

•           Revolving records through WorksheetChange - Numberings in column A are to be automatically registered when a value is entered in column B. If data extends to row 19, the next entry in B1 shall have cell A1's value equal to the value of the number in cell A19 + 1.

•           SheetChange identifies deletion or entry - Using a WorksheetChange event it is to be recognized whether a value was entered or deleted.

•           Macro triggered by SheetChange - Run a certain macro in a SheetChange event, depending on what range's target cell was changed.

•           Dynamic data validation - Sheet activation and cell selection generates a customized data validation list.

•           Flashing blinking text - Make text on a worksheet blink on and off.

•           Sheet change performs mathematical operations. - Change event calculates tax to an entered net amount, and adds the net plus the Tax into a Totals column.

•           SheetChange converts text to Upper Case - Enter text in column A and it shall be automatically converted to upper case.

•           SheetChange event to copy formulas - Changing a cell value in column A copies the formula into the corresponding row's cell of column B.

•           Sheet Change event for conditional formatting - Sheet Change event to have VBA conditionally format cells based on number and letter criteria.

•           Lock cells upon data entry - With a SheetChange as the trigger, lock a range of cells when a certain value is entered into a certain cell.

•           Macro run on function key - Select a range and press the F6 key to copy the cells from the range above into the range that is selected.

•           SelectionChange identifies active cell - The active cell shall have the ">" character in the cell to the left, and the "<" character in the cell to the right.

•           SelectionChange formats duplicate value cells - Selecting a cell in range E5:G10 that has a duplicate value in that same range shall shade the cell yellow and bold the font.

•           Sheet calculation event - The formula in B1 on Sheet1 is to be computed only during the first change of value in A1.

•           Message box at Open, and Selection of column A - A message box will appear when the workbook is opened to inform you the name of the workbook, and another message box will appear when a cell is selected in Column A of Sheet1, informing you what cell you selected.

•           SheetChange row insertion - For Excel2000 and after, trigger the change event in column E by typing in a certain value (in this case "New row" without the quotes) to insert a new row at that point.

•           Deactivate the Delete key on SelectionChange - When a cell is selected that contains a formula, the Delete key shall be disabled.

•           Double click, conditional time of day - Double-click event creates different pop-up message, depending on time of day.

•           Transfer data via selection event - By selecting a cell in a predetermined range, have the value in cell C1 be copied to that selected cell.

•           Sheet change event calls userform for data entry - Call a userform from a sheet change event that shall transfer input data to an existing table.

•           WorksheetChange event clears contents of target row - Utilizing a WorksheetChange event, changing a value will delete all other values in that target row.

•           Double-click event with class module - Double-click event created by a class module will apply to all open workbooks.

•           Double-click opens Acrobat Reader and PDF file. - Using the double-click event, the Acrobat Reader program is executed, and a PDF file is opened.

•           Predetermined row reflects values of selected row. - Using a Worksheet SelectionChange event, row 20 reflects values of cells in row of active cell.

•           Calculation event triggers visibility of graphic objects - A Worksheet_Calculate event causes a cell's value and a graphic object to appear differently, depending on the calculated result.

•           Disallow duplicate entries across multiple sheets - Using a Workbook_SheetChange event, disallow duplicate entries in a given range across all sheets .

•           Selected values copied to dependent destination sheet - Values in selected row of column A are copied to destination sheet depending on corresponding value in column B.

•           Cursor activates certain cell based on change to certain other cell - A simple example of a Worksheet_Change event that is used for activating cell C1 if cell A1 is changed, and activating cell E1 if cell C1 is changed.

•           Worksheet_Change event conditionally transfers row data - Make row 1 of Sheet2 display the same values as row 1 of Sheet1, based on value entered in cell A1.

•           VLOOKUP in VBA returns corresponding value via Worksheet_Change event - Enter a country name in column A of Sheet1 from the list of countries on the Data sheet, and column B will display the corresponding value that is in column B on the Data sheet for that country name.

•           Allow date entry only - Using a WorksheetChange event, non-date values in A2:B3 will be rejected.

•           Double-click a cell to insert a comment with text from a text file. - Double-click a cell to insert a comment with text from a text file, corresponding to the target column.

•           Calculation mode set to Manual at Open, and re-set to its pre-existing mode at Close - Set the Calculation mode to Manual when the workbook is opened, and then to re-set the Calculation mode to whatever it was (Automatic or Manual) at close, through Open and Close events.

•           Double-click to open files listed in a cell - By double-clicking cell A1, each file name in that cell will be opened in Notepad.

•           Open text files in Internet Explorer - A text file is opened in Internet Explorer by double-clicking its name as cell value.

•           Calculation event to change cell color - Cell value changes InteriorColor Index when its formula returns TRUE or FALSE.

•           WorksheetSelection event changes active cell color - Upon selecting a single cell, the active cell will be shaded yellow. When exiting that cell, its previous color will be restored.

•           WorksheetSelection event temporarily changes formatting of selected cell - Using a WorksheetSelection event, cells in a range are temporarily formatted for easier readability and for their true underlying numeric value to be displayed.

•           Change value depending on presence or absence of values in other cells or worksheets - Certain value in row 1 is changed, depending on existence or absence of value in row 2 and both values existing in predefined lists on another worksheet.

•           Value in one cell is changed depending on entry or edit of value in another cell - The value "A" in row 1 shall be changed to "(A)" when the cell's value below it in row 2 becomes "BC". If the cell's value in row 2 changes from "BC" to something else, the "(A)" value in row 1 shall become "A".

•           Cells on target sheet reflect color index of cells on source sheet depending on value entered - On a source sheet, values in cells are shaded a certain color. In the target sheet, values entered that are found on the source sheet shall cause their cell's color to be the same as the source sheet's cell color.

•           Function key F11 is disabled - The F11 Function key is disabled at Open and restored at Close.

•           Font size set at SelectionChange depending on value type - If cell I2 contains a numeric value, its font shall be set at 24; otherwise its font shall be set at 10.

•           Double-click event matches a date and sorts a date range. - A date shall be matched from a range on one sheet to a range on another sheet. That range on the other sheet shall be sorted, with the matched date appearing as the first record.

•           WorksheetChange event opens a file if it exists - Using a WorksheetChange event, changing the path name in cell B1 or the file name in cell B2 will open the file if it exists, or will inform you with a Message Box that the file does not exist.

•           A selected cell's entire row shall be selected. - A selected cell's entire row shall be selected. Selecting any quantity of vertical cells will still result in the active cell's single row being selected.

•           Worksheet_Change event defines a range's custom formatting - For the range B2:D6, entries made shall clear any existing formats in that range, and will format the range with the custom number format of ";;;", which will make the entries invisible.

•           Sheet activation attempt for one sheet activates another sheet instead - If Sheet 1 is attempted to be activated, Sheet3 shall be activated instead. If Sheet 3 is attempted to be activated, Sheet1 shall be activated instead.

•           Open event opens a separate workbook - As this workbook opens, the Open event code in the workbook module searches for a workbook named "Test1.xls" in this folder path, and opens it if it exists.

•           Find last used cell - Keyboard shortcut of Ctrl+End locates the cell belonging to the last used column and last used row.

•           Limit data to numbers only, warn if outside floor or ceiling - How can I limit data entry in column A to numbers only, and if the number entered is less than 100 or greater than 200, accept the entry but issue a warning?

•           Disable double-click - How can I disable the double-click feature and the Toolbar list while this workbook is open?

•           Graphic is randomly displayed triggered by Calculate event - How can I display one of three graphics in random order by recalculating the worksheet?

•           Unprotect ranges for access depending on username - How can I set up the workbook such that only the column(s) I specify shall be made accessible (unprotected) for different users, depending on username?

•           Double-click to copy row to matching worksheet - I have a table of data on one sheet with sheet tab names in column A. If I double-click on any cell in that table's range, how can I copy the target row into the next available row of the worksheet whose tab name matches the value in column A?

•           Double-click to fill comment with graphic image - How can I double-click on a value in column A which might be a graphic file name, and if a graphic file exists by that name in a specified path, a comment will be inserted into the target cell, with the graphic image filling the comment shape?

•           Register last 10 cell selection addresses - How can I maintain a running list of ten cell addresses that I have most recently selected, and have that list be updated with each new cell selection?

•           Find today's date in a cell - Determine if today's date is a value housed in a cell among the worksheets in this workbook.

•           Custom right-click menu when entire row is selected - How can I generate a custom button on my right-click pop-up menu when one or more entire rows are selected? I also want to assign a macro to that custom button.

•           Data validation list avoids duplicate items - With a range of values representing the list of acceptable values for data-validated cells, how can I ensure that the data validation list gets revised with every entry so no listed value is offered more than once?

•           Character conversion - How can I convert commas to " . " dot characters if commas are entered as part of values in column A?

•           Disallow duplicate values based on formatting - How can I disallow the entry of a value if the target cell is formatted for bold font, and the same value exists elsewhere in the current region in a cell that is also formatted for bold font?

•           Deny workbook save - How can I disallow the workbook to be saved if certain cells are not filled with data?

•           Worksheet_Change displays graphic - How can I enter an Item Number on Sheet1 that looks up the same value in a table on Sheet2 and displays a graphic on Sheet1 associated with that Item Number?

•           Identify active sheet name - When I activate any worksheet in the workbook, how can I make a message box pop up to tell me the name of the worksheet I activated?

•           Call macro from data validated selection of macro name - How can I data validate a cell to call a certain named macro when that value is entered in the cell?

•           Set cell color by matching value - How can I set up my workbook to change the color of a cell based on the value I enter into it, when that entered value matches the value in a master sheet whose cell color is assigned to that value?

•           Worksheet Change event calculates inventory - How can I forego formulas and use VBA's Worksheet Change event to recalculate existing inventory based on manual entries of In and Out for a given item?

•           WorksheetChange with VLOOKUP function - How can I use the WorksheetChange event to populate product fields on one sheet from a source table on another sheet?

•           Format cell color and font of edited cell - How can I enter a value in a range of cells and have the target cell's color and font identify that cell?

•           Disable menu item on sheet activation - I want to disable the "Cut" item on the right click pop-up's menu when a certain sheet is activated, and then re-enable the "Cut" menu item when that sheet is deactivated. How can I do this?

•           RightClick pop-up menu is range values - How can I supplant the right click pop-up menu with values in the target row, and by selecting one of those values from the menu, making it be the new value of my target cell?

•           RightClick pop-up menu disabled over range - How can I arrange for the right-click pop-up menu to be disabled over a specified range?

•           RightClick pop-up menu of month names - How can I make my right-click pop-up menu be that of the names of the 12 calendar months, and when I select a month name, a message box will appear to confirm my selection?

•           RightClick custom filter pop-up menu - I have a list of dates in column A, formatted as weekdays. How can I customize my right-click pop-up menu with a list of the 7 weekday names, and when I select one, filter my date list by that weekday?

•           RightClick pop-up replaced by FindControl menu - Please show me an example of how I can replace my standard right click pop-up menu with another dialog's menu, say the fly-out menu to the Insert > Name menu?

•           Add two custom items to right-click pop-up menu - I often need to hide and unhide columns. How can I add two items on my right-click pop-up menu, one to hide columns of selected cells, and the other to unhide all columns?

•           Custom item and 2 fly-outs added to right-click pop-up menu - How can I add a primary item on my right-click pop-up menu, and two fly-out menus items from that, one of which to hide columns of selected cells, and the other to unhide all columns?

•           RightClick pop-up menu lists workbook sheets - How can I replace my normal right-click pop-up menu with a list of the workbook's sheet tab names, and when I select a name I'll be taken to that sheet?

•           Force selection to certain range - How can I force a certain range to be selected if any cell outside that range is attempted to be selected?

•           Single cell selection, comment text as cell formula - How can I force only one cell to be selected at a time? If the cell contains a formula, I want the comment text to be that of the selected cell's formula.

•           Display selected cell's address - How can I display any selected cell's address by placing the display in a textbox on top of the cell?

•           Format selected cell - How can I easily identify the selected cell by making its color yellow?

•           Record history of selected ranges - How can I maintain a running history list of selectedl addresses?

•           Call macro at cell deactivation - How can I call a macro when I leave (deselect) a cell?

•           Call macro when cell is selected - How can I call a macro when I select a cell?

•           Expand selection's column count - How can I increase by 9 columns the column count of my selected range?

•           Format selected cell - For any selected cell in my used range, how can I increase its font size and autofit its row and column? Upon deselection I want to return the cell's format back to normal.

•           Change cursor style depending on column of selection - How can I set my cursor's style from its usual Default style to another style when selecting cells in certain columns, and then return the cursor to its Default style when exiting those columns?

•           Dependent data validation lists - How can I select a cell in a certain range have that cell's data validation list be determined by a value in another cell?

•           Force selection from one cell address to another - How can I program a cell such that if it is selected, another predetermined cell shall be selected instead?

•           Allow selection of certain cells - How can I allow only certain cells to be selected?

•           Force selection of one cell only - How can I force my worksheet to accept the selection of only one cell at a time?

•           Data validation list automatic pull-down - How can I make a data validated cell's drop-down list appear just by selecting the cell?

External References

•           Change sequence of digits to external relation with double click - How can I create an external link with a doubleclick?

•           Create Hyperlinks to VLOOKUP-LinkWorksheets - How can I create Hyperlinks to the Link Worksheets for some series of VLOOKUPs automatically?

•           Create a Link to the preceding Worksheet - How can I create a Link that relates to the preceding Worksheet whenever I copy the Worksheet?

•           Create Links transposed in a second Worksheet - How can I create Links to a Cell Area in Worksheet2, transposed in Worksheet2, in which the Area for the Input should start with Cell D1?

•           Divert all Links of a Workbook - How can I divert all Links of a Workbook to an other File which is named in the Worksheet?

•           Delete the last Link in a worksheet. - How can I delete the last Link that is contained in a worksheet?

•           Change the workbook name in a link formula. - How can I use an input box to change the name of a workbook that is referenced in a paste link formula?

•           Link to a Workbook through the Input of the CellAddress - How can I create a Link to the Header of the Column named Workbook and to the Cell below named Worksheet by entering a CellAddress (F16) in a Cell?

•           Change URL's of a Selected Area into HyperLinks - There are Internet Addresses in different Cells of a Worksheet. How can I change these Cells into HyperLinks without having to type the Addresses in the

•           Divide a Hyperlink - How can I divide information of a hyperlinked cell so that the text is in one cell and the address of the cell with the hyperlink is in another cell?

•           List the Links of the active Workbook - How do I list all of the Links in the active Workbook in a Worksheet?

•           Diversion of Links - How can I divert all existing Links in a Workbook to an InputBox supplied File via a VBA-Macro?

•           Delete all external links - How can I delete all external links using VBA?

•           Delete external Links. - How can I delete links to other Workbooks?

•           Two hyperlinks in one cell - One cell accommodates two hyperlinks. This is done by placing two transparent drawing objects over the URLs and assigning the hyperlinks to the drawing objects.

•           Verify hyperlink validity - Confirm which values are hyperlinks.

•           Dynamic hyperlink - Hyperlink formula shall be kept relative to the path of the active folder.

•           Convert all external links, from formulas into values. - All external links are to be deleted and replaced by their values.

•           Update worksheet from internet web page. - The table on Sheet1 is updated from a web page.

File Handling

•           Search for graphic file - Files in column B (suffix *.jpg is added automatically) are to be searched in a determined file

•           Read data from file folder into sheet - Data from the folders in cell A are to be listed in column B

•           Delete files when closing a workbook - Delete all doc and pdf files in folder c:\temp when closing the workbook

•           Open file with filename entry in cell - When entering a filename in cell B2, the file is to be searched in the folder named in cell B1 and then opened

•           Save sheet without code, control element and formula - The worksheet is to be saved as a new workbook without the action code, button and formula

•           Search application on harddrive - Acrobat Reader - file AcroRd32.exe - is to be searched on the hard drive C

•           Backup copy of selected worksheets - The sheets 1 and 3 are to be saved as backup files with the suffix *.bak in the file c:\temp

•           List files of a folder in a ComboBox - A folder is to be selected through a dialog. The files of the selected folder are to be listed in a UserForm-ComboBox

•           Save text by rows - Contents of column A are to be saved in a text file with file names from column B. The path is in cell C1

•           Delete active workbook - How can I delete and close a workbook form the hard drive

•           Close workbook with button. - How can I close a workbook with a button?

•           Start new Excel session with workbook - How can I start a new Excel session with an empty workbook through a button

•           Manipulate file date - How can I set the file date to the date from cell A1?

•           Search for a word in workbooks of a file folder - Count the number of occurences of a specific word on Sheet1 of all workbooks in a file and enter the number in this sheet.

•           List data from closed workbooks. - Read first and last value in column F of all Excel tables in c:\temp without opening the workbooks. Enter the values in a continuous range.

•           Change the Keywords in all Files of a Folder - How can I determine the Keywords in all Excel-Workbooks of a set directory?

•           Search for the latest Text File of a Directory and rename it - How can I search for the latest TextFile in a set Directory and rename it?

•           Set the Workbook to ReadOnly after filling the InputCells - How can I set a Workbook immediately to "ReadOnly" after filling 3 InputCells?

•           Read in XL-Files from Directories and SubDirectories - How can I read all Excel-Files of the current Directory including all SubDirectories in another Worksheet?

•           Open a password protected Workbook, copy the Data and close it - How can I open a password protected Workbook, read out some Values of an Area of the active Worksheet, transfer it to another Workbook and close the Workbook again?

•           Check, if a File exists and a message if it doesn't - How can I ask if a Workbook with the set name exists? If it exists it should be opened, if it doesn´t exist a corresponding Message should be given out.

•           Save the BackUps of Workbooks - How can I create BackUps of Workbooks after I have asked, via an InputBox, which Workbooks should be saved?

•           Search Files in one Directory and Subdirectories - How can I search for a certain Filename beginning in the Start Directory and then in all Subdirectories?

•           Create a FileList with DOS- and Windowsnames - How can I list all Files of the Computer in the current Worksheet? I need some information about DOS- and Windows-Names Creating- and Changedate.

•           Select a Template and load a Workbook - How can I select a Template in a Dialog of a set TemplateFolder and load a Workbook that is based on it?

•           Save the Workbook with the absolute Values as a new name - How can I change all References of the active Workbook into absolute Values and save the Workbook as another name which should be queried by an InputBox?

•           Select a directory in a Dialog and then create a new Folder - How can I select a directory in a Dialog and create a new directory?

•           Call the Folder-Dialog with the following File-Dialog - How can I initially call a Dialog to select a directory and then call another one to select an Excel-File out of the directory?

•           Select and open a File and show the Function Dialog - How can I view a Dialog for the FileSelection, open the in the Dialog selected File and call the Function Dialog immediate after opening the File.

•           Check the Sheet type and the name of the Workbook - How can I ascertain the Sheet type (Worksheet or Chart) and the complete filename?

•           List all Files in a Directory-list - How can I list all Files of the named directories in Column A with the in Cell B1 named Suffix in a new Worksheet?

•           Create Hyperlinks to all Excel-Files of a directory - How can I create Hyperlinks to all Excel-Files of a certain directory in Column A of the active Worksheet?

•           Save the Workbook as *.xls und *.bak-File all 10 minutes - How can I save a Workbook as Excel-Workbook and as *.bak-File all 10 minutes?

•           Create private FunctionCategories - How can I create private FunctionCategories?

•           Change the Directory via VBA - How can I save the actual Workbook in an other Directory as the current and change there and back again?

•           Open all Workbooks of a Directory - How can I open all Workbooks of a Directory by clicking on a Button?

•           Stop an Error when a Workbook isn´t open - How can I disable an Error-Message when I address a Workbook that isn´t open? In this case the Workbook should be opened.

•           Read out the names of the Workbooks and Worksheets - How can I view all Workbook- and WorksheetNames belonging to it from the current Directory through a MsgBox?

•           Change the Workbooks of a Directory - How can I open all Workbooks of the current Directory, perform a change of the Value in a certain Cell of all protected Worksheets, protect the Worksheets again and close them again?

•           Create a BackUp in another Directory - When I activate the CheckBox "Create BackUp-File" and when I save a Workbook, the BackUp-File are created in the same Directory as the Workbook. Can I save it in another Directory?

•           Copy the File if it doesn´t exist - How can I check if a File is already existing before I copy it into another Directory?

•           Arrange Files of a FolderList in a Worksheet - How can I create a List of all Files with the Directories and then placed in Column A of a Worksheet?

•           Convert a series of Files into the XL5/7-Format - How can I convert a series of Files into the Excel-5.0/95-Format when the names are in Column A?

•           Save an individual Worksheet as the date of the day - How can I save a separate Worksheet of a Workbook as the current date?

•           Displace Files - How can I move Files - also not-Excel-Files - from one Folder into another? Error-Messages should be absorbed.

•           Read in the names of a Workbook - How can I list the Area Names of a Workbook in a ListBox? Besides the Names the AreaAddresses should be shown.

•           Save selected Worksheets as separate Workbooks - How can I save several selected Worksheets of one Workbook as new Workbooks? It should be asked for the Filename and a warning should appear if this is already

•           Call the xlSaveAs-Dialog in a certain Directory - How can I call the xlSaveAs-Dialog so that it shows the files of a certain directory and maintain the status of the current directory

•           Ascertain if a File exists in a Directory - How can I determine via VBA if a certain file exists in a specified directory without trying to open it?

•           List a File of a Directory - How can I list all Files of a SubDirectory that must be set in advance in a Worksheet?

•           Close a Workbook without query - How can I close a Workbook without the questions if the File should be saved and if the Data should be stored on the ClipBoard?

•           Read in FileNames into a Worksheet - How can I read in the FileNames of a named Directory and a Suffix that must be given into a Worksheet?

•           Take the File of a Directory in a ListBox - How can I take all Files of a named Directory in a ListBox from a DialogSheet and open the File "Index.xls" from the Directory that now can be chosen?

•           Create Links to Cells in a closed Workbook - How can I create Links to a closed Workbook of which the name is in Cell A1?

•           Change the name of a File - How can I change the name of a File? The Source Name is in Cell A2 and the new Name in B2. ErrorReports should be absorbed.

•           Close a Workbook out of a Dialogue - How can I close the active or another Workbook out of a Dialogue?

•           Access on a closed Workbook - How can I access Cells of a closed Workbook without having to give the entire FileName?

•           Copy a Workbook with lightning speed - How can I copy the Workbook with lightning speed 100 times in only one stage? The SaveAs-Method of a VBA-Macro is too slow.

•           Create a TextFile with set DataField-Width - How can I create a TextFile with set DataField-Width?

•           List opened Workbooks and Worksheets - How can I list all opened Workbooks and their Worksheets?

•           Open the workbook whose File Name is displayed in a cell - The active cell's value is a file name. How can I open that file, using VBA?

•           Custom alert when saving the file as a name that already exists. - How can I save a file by overriding one with the same name, and get a friendly message asking if I am sure?

•           Open the workbook without alerted to update links - How can I open a workbook without asking to update links?

•           Save the Workbook as a person's name - I have a First Name in cell B3 and the Last Name in cell B4. How can I save the file in the naming syntax "Tom Urtis.xls"?

•           Choose the disk drive via an Input Box - How can I let the user select a certain disk drive via an Input Box?

•           Save the Workbook as a back up copy. - How can I create a back up copy of a workbook any time I want?

•           Save the Workbook as a date value - How can I save the active Workbook as the date that is displayed in cell A1 of the 1st Worksheet? The FileName should have the Format MMDD.xls

•           List all files modified as of a certain date - How can I create a list of files that were modified after a specific date?

•           Close all open workbooks except the active one - How can I close all open workbooks except for the active one?

•           Save a separate Worksheet - How can I save a separate worksheet and name it as a file name?

•           Create a Workbook-History - How can I record the Path and the Name (separate) of all opened Excel-Workbooks in an endless list of a Workbook?

•           List the Excel-Files of a Folder - How can I list all the Excel-Files of a certain SubDirectory in a Worksheet?

•           Convert Excel 5/7 Files to Excel 8 - How can I convert all Excel 5/7 files to Excel 97 Format?

•           Delete SubDirectories that have Contents - How can I delete a certain directory tree including the Files with VB code?

•           Send a File - How can I send an ExcelFile over the General E-Mail program with VBA?

•           Open the Workbook with the Name of the current Date - How can I open a Workbook with a VBA Macro, that is named with the current Date in the Date Format "YYYYMMDD", so for example "19980512.xls"?

•           Create a Tree - I can create a SubDirectory via the MkDir Command. But how can I create a complete Tree using an Input Box?

•           Create a SafetyFile automatically - How can I create a backup file automatically when saving a Workbook?

•           Determine FileNames and Paths - How can I determine the actual FileName and the Path from the complete FileName which is determined with the Command "GetOpenFilename"?

•           Start 400 empty TextFiles - How can I start 400 empty TextFiles whose names go from "0001.txt" to "0400.txt" as fast as possible?

•           Floppy disk in disk drive A? - How can I check if a floppy disk is currently in drive A:\?

•           Extract the FileName out of the whole Name - When I use the GetOpenFileName Method I get a Path and Filename, but how can I just extract the Filename from the String?

•           List of Files - How can I add a file names and path to a ListBox?

•           Update the current Path - How can I add the file path to the footer on print, and then save the workbook with that new information?

•           Storing the last date saved - How can I display in a cell the date of the last time the active Workbook was saved?

•           Open all Files in a Directory - How can I use VBA to open all Excel files in a Directory?

•           Check to see if a Workbook is opened - How can I find out if a Workbook is already open before the Open-command?

•           Filter names of Files - When using VBA to display the Open Dialog, how can I limit the displayed files to only certain types, say Text files?

•           File status: open, closed, or nonexistent. - For a given file name and file path, determine if that file is open, closed or nonexistent.

•           Save workbook as incremented name. - Each time a workbook is saved, its name increments by numeric value of one (1).

•           Open a closed or in-use workbook - Determine if a workbook is closed, or open and in use by another user. If it is closed, open it. If it is open, loop until the other user closes it, at which time the macro shall open it for you.

Formatting

•           Merge cells without loosing values - The cells from column A and B are to be merged without losing the values from column B

•           Mark lotto hits in a table of a lotto group - All hits of a list of a lottogroup are to be marked yellow. Solve with menu FORMAT/CONDITIONAL FORMATTING

•           Color marking of value relations - Mark Sell price lower than 200% of buy price in green and sell prices higher than 260% of buy price in blue

•           Format table depending on number formats - The columns sheet data are to be formatted according to the number format template in sheet "Formats"

•           Set up conditional formatting for an area with VBA - How can I compose a macro that will conditionally format the cell containing the max value in a selected range?

•           Automatically mark minimal and maximal values - Mark the minimal and maximum values in a calorie consumption table.

•           Mark formulas with conditional formatting - All cells in column A, which are empty or do not contain a formula, are to be marked yellow. Solution with user-defined function in Module1 and ConditionalFormatting

•           Background color of cell if a specific value is in a cell. - How can I mark row A:H with a color, if a cell in the row contains a "x"?

•           Mark maximum values in a selected area - How can I mark the maximum values in the selected area violet through conditional formatting?

•           Adjust row height of merged cells - Merged cells do not have the correct height after a row break. How can I correct this?

•           Set back, if more than 9 entries - Mark the first entry in yellow for more than 9 continuous entries in column B

•           List all fonts available in Excel - How can I list all fonts available in Excel in column A and format in the respective font.

•           Conditional formatting depending on a cell comment - How can I make a conditional formatting depending on a cell commentary?

•           Adjust row height of merged cells - When I merge the cells with row breaks, the row height is not adjusted. How can I adjust this?

•           Yellow background for rows with content - How can I highlight yellow all rows containing a value?

•           Visitor list for customer with various criteria - How can I set up a visitor list for customer with three different categories.

•           Fill each second Cell with an Interior Color - How can I fill each second Cell with an Interior Color?

•           Write the first name with the first letter starting bold - How do I make the first name of a Column that starts with a new letter be shown with the Script-Attribute "bold"?

•           Mark the Data Area depending on 3 criterias - There are Headers in Row 1 and DateSeries below it. There are Header-Value, Start- and EndDate as criteria in the Cells H1:H3. When I change the Entries, the marking of Date Area should fit.

•           Mark weekends and holidays in a list of the year - How can I mark weekends and holidays in a month list the way that the marking adapted, automatically when I enter another year or month?

•           Show the topical birthdays when the Workbook is opened - How can I have the Interior Color of the Cells with the topical birthdays be yellow and of that with Values up to a week before be blue as advance warning when a Workbook is opened?

•           All Cells of Column A without Input with Interior Color yellow - How can I change the color of a cell? When its empty it should be yellow, and when there is a value, the interior color should be clear.

•           Mark double existing values - How can I mark all double existing Values in one Column?

•           Difference of Start- and Endtime in seconds - How can I view the difference of Start- and Endtime in seconds?

•           Mark the HeaderCell with the active Autofilter - How can I mark the HeaderCells of these Columns in which the active Autofilter is?

•           Change the cell color via the conditional formatting with celInputs - When I enter a 7 in Column A the seven Cells right of the InputCell should be covered with the Interior Color yellow. Can I solve it with the conditional Formatting?

•           List all userdefined NumberFormats - How are all userdefined NumberFormats of the active Workbook listed in a Worksheet?

•           Fit a watermark in a Worksheet - How can I fit a watermark in a Worksheet?

•           Set dots in front of an enumeration - How can I set enumeration dots in front of a selection of Cells?

•           Read out a conditional Formatting - How can I display the conditions of the conditional formatting and the effects of the formatted Cell?

•           Assignments of Templates in dependence on the Cellcontents - How can I assign userdefined Templates to selected Cells depending on the individual Values of the Cells?

•           Calendar of a Year and conditional Formatting - How can I create a CalendarSheet of a Year and mark the weekends, the current day and the holidays colored without using VBA? After entering a new Year the

•           Mark the MinimalValues per Row - How can I cover the Cells with the Minimum Values per Row with a red Interior Color?

•           Shade Cells with negative Values - How can I get a cell with a negative numerical value to be shaded automatically, and then have the shading disappear in that cell if a positive number is entered instead?

•           Double a font size upon copying. - While copying the contents from one cell to another, how can I double the original font size in the destination cell?

•           Mark the Weekend - How do I make all Saturdays and Sundays in a pre-determined field a different color with VBA?

•           DateInput in the Format DDMMYY - How can I enter the Date in the Format DDMMYY (without Points) and order Excel to write it in the Format DD.MM.YY ?

•           Set the Script and Size of a Comment -XL8- - How can I set the Script and Size of a Comment in XL8 with VBA?

•           Set the Fill Colors with VBA - How can I set the fill colors of a cell from the Color Pallette using VBA?

•           Automatically sum and format Cells Excel 97 - The following actions should be performed if a value is present in the first row of a column: format it as a number #,##0.00, add the Values and set the Sum in the first empty Row underneath. Afterwards, a PageLayout should be assigned to the Worksheet.

•           Delete styles - How can I delete all styles, except for the built-in styles, using VBA?

•           Delete all styles in workbook. - How can I delete all styles except General using VBA?

•           Number Formatting with a point after the first number. - How can I format Cells so that there is a point after the first digit? Examples: 1 = 1., 10 = 1.0, 123455 = 1.234455

•           Suppress the automatic DateFormatting - When I replace the commas through points in a Field where the Cells are formatted in the NumberFormat "Text" over Menu Edit / Replace one part of the Numbers is formatted as Date ("Apr 98"). How can I prevent this?where the Cells are formatted in the NumberFormat"Text" over Menu Edit / Replace one part of the Numbers is formatted as Date ("Apr 98"). How can I prevent this?

•           Force a Line break in a Formula - How can I force a Line break in a Formula? I want to link Address Data that are divided in the Columns "Address", "First Name", "Last Name", "Street", "Zip code," and "City" (Columns A-F) in that exact order.

•           Fit the Width of a Column - How can I set the Width of the Column to the Value of the Cell?

•           Prevent the changing of the Format through Excel - Using Edit-Replace, changing the century from 20 to 19, Excel automatically returns a cell previously formatted as mm/yyyy to mmm yyyy, how can I stop this occurrence?

•           Make the Input of Time formats easier - How can I change the input format for time so that Excel allows me to enter it as hh:mm:ss(hours:minutes:seconds)?

•           Enter the EURO-Currency Symbol - How can I format a Cell to show the EURO Dollar Symbol?

•           Converting date format (from Heinrich Stuerzl) - How can I change the format of a date from an imported file to fit the format of the date on my Computer?

•           Add the symbol for diameter - How can I add the symbol for "diameter" to existing text?

•           Copy non-blank data row - Copy rows to Sheet2 that do not have cells blank in column D of Sheet1.

•           Format based on exceeded date - The exceeded dates of payment are to be color marked.

•           Conditional formatting of dates - The cells whose date values fall between the start and end dates of a second table are to be conditionally formatted.

•           Multiple conditional formatting - Lottery numbers are conditionally formatted when they are among the selected winning numbers.

•           Delete rows and formatting past last used cell. - Using the keyboard shortcut Ctrl+Q, delete all columns to the right of the last used cell, and delete all rows below the last used cell.

•           Conditional Formatting separates alphabetized list with border - Using Conditional Formatting, a border line is placed at each change in the first letter of an alphabetized list.

•           Identify non-matching cell values between ranges - Utilize the Conditional Formatting feature to identify cells that do not match between two ranges, in this example where Sheet2 and Sheet3 differ.

•           Userform shows the Format dialog - The userform provides for bringing up the Format dialog, so you can select a number format for the used range.

•           Border toggle - Click the button to toggle borders on and off around the area you select.

•           Conditionally Format weekend dates - How can use Conditional Formatting to color cells that contain weekend dates?

•           Conditional Formatting depending on conditions in two other cells - How can I arrange for Conditional Formatting to mark cells for shading, where certain conditions for values exist in two other cells?

•           Conditionally format an entire column based on current date - How can I use Conditional Formatting to shade the cells of an entire column whose current date is in row 1 of that column?

General Topics

•           Combine column text and replace - Text from column C:D is to be combined and column D to be reset

•           Copy all rows of a column without a value - All rows, which do not contain a value in column G are to be copied to the second table.

•           Set worksheet protection with enabled AutoFilter - Worksheet protection is to be activated but working with AutoFilter still has to be possible.

•           Prevent entry of values, if a value is in the next column - Prevent entry of values in column A or B, if in respective corresponding column is already a value existent.

•           Change address blocks and put in new sheet - The address blocks in column A are to be listed in a new sheet

•           Reset VBA action with 'Undo" button - Per button click, the values in the selected areas are to be rounded to two decimal places. The action is to be reversible with the Undo button

•           Search value in external workbook and paste with format style. - When entering a value in column B, value should be searched in a different workbook in row 1 the value in column A should be searched in column A of the second

•           countdown in status bar - A count down from 30 to 0 seconds is to be displayed in the status bar.

•           validation list without empty cells - The validity list in cell A1 shall contain data from column A from Sheet2 without empty rows and shall be adjustable.

•           Dialog message, if two cells contain values - Entries in column A and Be are to be retrieved in a UserForm if both cells in a row are filled.

•           Search row 1 for value in active cell - The area to the right of the active cell in row 1 is to be searched for the value in the active cell and a result message is to be displayed.

•           Create worksheets from a list of names - For each name, a worksheet is to be created. The respective data is to be copied in the specific sheet.

•           Navigate to values selected with DropDown fields - DropDown fields in row 1 are to be actualized with every entry and the values to be displayed in the respective column without empty rows.

•           Determine employee anniversaries from employment start data. - From the employment start date in column E, the 25 year and 40 year anniversaries with a waiting period of 5 days are to be searched. Results posted to new sheet.

•           Open data in two dimensional array and save in sheet - The weekdays and dates of a month are to be opened in a two-dimensional array and then inserted in the sheet

•           Replace all "u" with "U" up to today's date - Replace all "u" with "U" up to today's date

•           Divide names randomly in various groups - Names in column A are to be divided randomly with a variable group size. The groups are to be pulled up by an input box

•           Copy only rows with specific content - How can I copy entire rows from one sheet into another sheet, based on any cell in a any row containing the text "Hello"?

•           open file structure in UserForm and open file - open file structure in UserForm and open file

•           Retrieve and save data with user-defined type - The data from a sheet shall be imported and exported in the fields of a user-defined data type

•           Insert rows under the condition of cell values - Underneath cells with a value higher than zero in column "Number" (D) , as many rows are to be inserted as the value in the cell is. Under the value, a zero is to be entered after the insertion.

•           Generate total for dynamic area - With VBA a total for a dynamic area is to be formed. The first cell is the cell above the sum formula or with VBA - the active cell. The last cell is the cell before the empty cell

•           Search, enter, and delete values - The value in the active cell in column A is to be searched in the other cells of the column. If found, the value from column C of the found place is to be

•           Replace calculated value by next higher value - A calculated value is to be replace with the next higher value from column A.

•           Mark weekends - Mark all weekends with a gray background

•           Select an area from a series of workbooks - From a source folder, which is to be selected in a dialog, the areas A1:C10 in the existing workbooks are to be copied in this worksheet

•           Divide values of every other column in two steps - Values in column K, M, O, Q and S are to be divided by 100 and 1.5 and be displayed with two decimal places

•           Spell out values - Values in column A and B are to be spelled out in column C

•           Insert auto text with short cut - With the keyboard shortcut CTRL+T an auto text is to be inserted.

•           Mark each current date - Mark the respective current date.

•           Total values after changing of cost place - If the value of the respective cell in column A is different from the value in the cell above, an addition is to be executed.

•           Anchor buttons on top border of sheet - How can I anchor buttons on top border of sheet?

•           Updated list depending on a validation selection - The team names on sheet 2 are to be available for selection in validity field in cell A1 of sheet1. When selecting a team, the crew of the team is to be shown in the cells below the validity cell.

•           Sort by birthday - How can I sort a sheet with names by birthdays without considering the year in the birthday?

•           Display AutoFilter criteria after filtering - After filtering with AutoFilter, titles of filtered data with criteria are to be displayed at the bottom of the sheet

•           Sort by sort criteria in second sheet - Column A is to be sorted by a sort order in the second sheet

•           Save tables as text file with determined name - Values from column A in sheet 2 is to be saved as a text file in folder c:\temp with the file name in cell A1

•           open and close a footnote - The name from a footrt is to be inserted in the last row of the above text box

•           New order of a in a second sheet - Data from one sheet is to be reorganized in a new sheet.

•           Opened a data form with a specific record - The data mask to sheet 1 shall be opened with the standard record from cell A1

•           Copy and rename a worksheet - The sheet Tab_Total shall be copied and renamed. In the target sheet, the range "Area" is to be deleted.

•           Divide sheet by groups - The shall shall be divided into new sheets by criteria in column A

•           Filter VBA by date - From the sheet data the rows upto 05.01.2001 are to be filtered. Filtering via VBA

•           Distribute table into several worksheets - Data from above table is do be divided to new worksheets according to the numbers in column A

•           Legend of a worksheet including color marking. - How can I open and transfer a legend of a worksheet including color marking?

•           Search for phrase and mark row of found phrase - How can I search for a phrase with the input box and display as found rows? A message shall be displayed if phrase is not found.

•           List data area in second table without duplicates - How can I list data from sheet 1 in column A and sheet 2 without duplicates?

•           Copy sheet content of three sheets in a new sheet - Data form Sheets 1 to 3 are to be copied in a new sheet.

•           When sorting replace Ä with Ae and set Sch before S - Sort column A with taking Ä as Ae and Sch before S

•           Copy date if date is empty or later than today - All rows with column C empty or the date higher than the current date are to be copied in sheet2.

•           Generate validation list depending on a second list - Set the number of days in validity field D1 depending on a selection in validity field B1

•           Sort addresses by given start name - Sort the names from column A in that way that the following names are in this order: WERNER, DANIELA, ANGELA, JOACHIM, ROSI, HARALD

•           Sort values by frequency - Values in column A are to be sorted by frequency

•           Undo macro action with undo button - With a button click, values in column A are to be entered. This action shall be reversed with menu EDIT/UNDO.

•           Proof values with criteria and distribute into worksheets - Values from columns A:B are to be copied in new table sheets and divided in groups up to 100, 100 to 1000, 1000 to 10000, 10000 to 100000 and over 100000. For each group an individual is to be added. The data in-carrying is to take place starting from line 3. If the data already exists, the new data is to be added to the list.

•           Invoice form with access to customer and article database - How can I

•           Insert data from entry form in monthly table - Data from area B6:C6 are to be entered in monthly table according to date in cell F16

•           Divide worksheets in new workbooks - The last two sheets of an existing workbook are to be divided in to 2 separate files.

•           Determine values up to a certain time point - Measured values +3 minutes in sheet2 are to be added in the area A1 of sheet1 and be displayed together with B1

•           Consolidation of lists with index numbers. - Given is a listing of key numbers from companies, for which faxes are to be sent. The company data is in the sheet FaxNumbers. The sheet is based on the key number of the distributor

•           End macro with ESC button without error message - A macro is to be interrupted with the ESC key. After that a confirmation message is to be displayed.

•           Proof and copy values - If an article number is not yet present in column A, the next higher number is to be used as article number and the row is to be copied to sheet "Target." If the article number is present in the sheet "Target," the range of values is to be copied to sheet "Available."

•           Transfer values if numeric - Values in rows and columns shall be transferred to a second sheet if value in column A is numeric.

•           Search for phrase in table and select found rows - How can I search for a phrase with the input box and display as found rows?

•           Transfer data or add up data - The data from Sheet1 is to be copied into Sheet2. After copying, an X is to be added in column B of the respective line so that the data record is not considered during the next copy. If the data from column A is already in sheet2, the number of items from column B is to be added.

•           Compare tables and mark discrepancies - Compare Sheet 1 with Sheet 2. Set a color background for every row with mismatching data.

•           Sort activated and deactivated rows - Hidden rows are not sorted in normal mode. How can I avoid this?

•           Copy only unhidden cells in different worksheet - In area A1:B6 are hidden rows and columns. Only the unhidden values are to be copied to another sheet

•           Compare tables and replace rows - Column A of sheets 1 and 2 shall be compared with sheet 1. If matching, replace row in sheet 1.

•           Sort several adjacent columns - How can I sort data into adjacent columns?

•           Sort address list by name, street and city - How can I sort an address list alphabetically by name that contains the name in the first row, street in the second row and city in the third row .

•           Activate/Deactivate worksheet protection for a series of tables - With a first button, a worksheet protection shall be set for sheet 2 up to sheet 6 and with a second button it shall be deactivated.

•           Search for value in table 2 and carry over found place. - The values from column A are searched for in Sheet 2 in any place and values from columns B:C be transferred to this sheet.

•           Search for second table and replace source file. - The values from column A shall be searched in sheet 2 in column A. If value is found, replace row in active sheet with row from found value.

•           Read, sort and select in array - Read values from table and transfer them to an array, sort them in a temporary workbook and reopen them in an array.

•           Collect matching values in column 2 - If values of column A and B are identical, collect them by columns

•           Determine highest date in a row and insert. - Read the highest date in column A and insert dates in column B

•           Calculate values in EURO and vice versa - How can I calculate values from EURO to DM with a button click.

•           Compare values and insert result in table. - Compare values of columns D:G one by one with column A. Insert the result in area E12:E16

•           Data from address form in address databank - Enter data from area C2:C6 in sheet Addresses in the next free row

•           Insert value of active column into next free position. - Insert the value from column B in the cell in which the cursor is positioned into the next free position in sheet Sheet2 in column B.

•           Collect print data on print sheet - Data from the source sheet is to be transferred to a sheet that will be a print template.

•           Display table rows depending on a second table. - Verify the contents of the first 25 cells in column A. If a cell is not empty, the corresponding row should be displayed in sheet 2

•           Add the values, enter in first empty Row and calculate difference - How can I add up two Columns of numbers, enter the sums in the first empty Row under the Columns and show the difference of the sums in the left Cell under it?

•           Copy Selected Area that isn´t coherent in the next Row - How can I copy a Selected Area that isn´t coherent in the first empty Row of another Worksheet?

•           Add to a String a second in another Script - How can I add a string with another Script Color and other Script attributes to a Cell Input?

•           Multiply Values with random number between 1 and 2 - How can I multiply the Values of a Selected Area with a random number between 1 and 2 ?

•           Search for the Article Number and list each last area of found - How can I search for a list of Article Numbers through several Worksheets and enter each last area of found beneath the Article Numbers?

•           Enter the account number in the Registry, read out and delete it - How can I enter an account number in the Registry, read it out later, reset it and delete the RegistryInput again?

•           Always filter 10 Addresses per postcode from a list of addresses - How can I filter the addresses in a list of set postcodes out of an address list and list from this the result, 10 pieces per postcode as maximum?

•           Example for the Goal Seek - How must I handle the Goal Seek?

•           Analyze a String and list the Symbols - How can I analyze a long String by listing all existing Symbols with the Number of their occurrence in a list of a second Worksheet?

•           Sort several independent Worksheet Areas - How can I sort several independent Worksheet Areas descendingly by pressing a Button?

•           Set the Sort-Column-Header in advance and show a message for 2 sec - How can I sort a Worksheet with Column-Headers by a Column-Header- Text that is named in a Cell and show an Execution-Message for 2 seconds in the Statusbar afterwards?

•           Check, which Cells have been changed after opening - How can I determine which Cells of a certain Area have been changed after opening the Workbook?

•           Copy each second Cell - How can I copy all Rows beginning with one that is set through an InputBox-Input into a second Worksheet?

•           Set and change the Area Names with the help of a VBE-Routine - How can I change a series of set Area Names with the help of a VBE-Routine?

•           Sort RecordSets which are set in blocks of four datas - How can I sort two Worksheets simultaneously? You have to consider that there are two blocks of four Datas expanded RecordSets from Worksheet1 in the second Worksheet.

•           Copy a Worksheet and number it three-figure continuously - How can I copy a Worksheet and set a three-figure continuous numbering to it when I press a Button? Already set names mustn´t be repeated even if the Worksheets are deleted.

•           Delete the double contents in several Columns - How can I delete multiple column inputs that correspond with the Input in the upper Cell?

•           Calculate the Modal-Value of a filtered Series - How can I ascertain the Modal-Value of a sequence of numbers that was filtered with the Autofilter?

•           Generate chance numbers till four times Value - How can I generate chance numbers of a Worksheet Area in a way that four times Value of the current Cell can be reached is the maximum?

•           Filter a Worksheet to the smallest and the tallest date - How can I filter a Worksheet to the Min-/Max-Date when I press a Button? Start and End date are in two Cells.

•           List the Cells with Background-Color in a new Workbook - How can I list all Cells with a Background-Color in a Worksheet of a Workbook, in a new Workbook, with information about Value, Address, Background-Color and ColorIndex?

•           Fit in Rows, enter Values and References to the Values - How can I fit in a number of Rows that was set, via an InputBox, to the beginning of two worksheets, enter Values in the one and References to these Values in the other Worksheet.

•           Multiply the place of a found term with another Cell - How can I multiply the Cell next to the place of a found term with a Value of a second Worksheet and view the result in a MessageBox?

•           Open a validity list conditional - How can I open a validity list when I select Cell B3 whenever Cell A1 isn´t empty?

•           Copy an via InputBox set Area - How can I select and copy a Copy Area via InputBox?

•           Cell selection depending on the Column-Header - How can I search for a term in the Header and set the CellPointer depending on the place it was found?

•           Read out the positions of single Signs in a long String - How can I read out the positions of single Signs in a String that contains nearly 10000 Signs?

•           Mark DateSeries according to a setting - How can I select a DateSeries after I have set the day- and month-Index and fill it with AreaNames?

•           Search for a term of search in previous Worksheets - How can I search for a term in Worksheets previous to the active Worksheet?

•           All Values with point from Column A to Column B - How can I transfer all Values of Column A that include a point to Column B?

•           Call the Excel-SortDialog via VBA - How can I call the Excel-SortDialog via VBA?

•           Count the same chance numbers and show it in a Chart - How can I enter chance numbers from 1 till 10 in Column A1:A100 and output the respective number in a Chart?

•           Search for terms in a second Worksheet and add Values - How can I search for the Strings in Column A of an active Worksheet and in Column A of a second Worksheet and enter the right values into the correct places of the active Worksheet?

•           Random sentences - How can I construct random sentences by assigning each of four segments to a collection of four randomized arrays?

•           Select and enter names randomly - Names should be selected randomly in the Columns A:B and entered in the Columns C:D.

•           Sort with Empty-String in Formula at the End - How can I make a Worksheet be sorted so that the Formula- results produces an Empty-String that appear at the end of the Worksheet?

•           Show Area of another Worksheet for 2 seconds - How can I view a set Area of a second Worksheet for 2 seconds in the active Worksheet?

•           Copy a set number of Inputs in a second Worksheet - How can I take a certain number of last Cells from the actual Worksheet and copy on a second Worksheet?

•           Check which Worksheets of a List exists - How can I check which Worksheet of a List in Column A are contained in the active Workbook?

•           Ask the Password when a Workbook is opened - How can I ask a Password when a Workbook is opened and repeal the Sheet Protection of all Worksheets when it is correct?

•           Select the Cell, create a Link and take the Format - How can I select a Cell via an InputBox, transfer the Format to the active Cell and create a Link to the selected Cell?

•           Search the Date and output the address of the Cell of find - How can I search a date in Column A and output the address of the Cell in a MsgBox?

•           Filter and transfer the results to a Worksheet - How can I filter a Worksheet to 3 Criterias and transfer the results of the filter to 3 Worksheets?

•           Hide / unhide empty Cells or Cells with 0 - How can I unhide and hide all Rows whose Cell is empty or comprises an 0 in Column A, via a Button?

•           Read the names of a Selected Area - How can I ascertain all Area Names that exist in a Selected Area?

•           Multiply Values of Column A with Values of Column B - How can I multiply all Values of a variable Area in Columns A and B with the result appearing in Column C ? Only Formulas should be entered.

•           Multiply numbers depending on its Values - How can I multiply numbers in a set Area depending on its Values with other numbers?

•           Search surnames in Strings - How can I ascertain a certain surname in a CellArea? Name and surname are together in one Cell. You have to make a difference between name and surname.

•           Change Signs into Strings and delete spaces - How can I replace all points by spaces in the Strings in Column A and delete the useless spaces? The result should be lower case and be outputted in Column B.

•           Create month sheets with validity list - How can I create 12 month sheets via VBA and limit the validity of the Values in Column A of each Sheet to a certain Area of the first Worksheet ?

•           Summarize the activities and hours of a set period - I´ve got key numbers for activities in Column A, date information in Column B and hours in Column C in a Worksheet. How can I list and sum this Data in a second Worksheet over a given period of time?

•           Summarize the Cellcontents befor linking the Cells - How can I prevent losing the trailing cells when I link Cells?

•           Copy Rows depending on the Value in Column A - How can copy rows into a new Workbook where the value of Column A matches a certain condition?

•           Summarize two Worksheets without duplicates in a third - How can I summarize two Worksheets without considering double RecordSets in a third Worksheet?

•           Copy the Row with the active Cell into another Worksheet - How can I copy the active Row into a second Worksheet?

•           Check to agreement and show in the MsgBox - How can I compare the Values in Column A and show a MsgBox when they match?

•           Mark with color and list double RecordSets - How can I mark double RecordSets in Worksheet1 with color and transfer it to Worksheet2 ?

•           Enter a Value from a Cell into a Worksheet-TextBox - How can I enter a Value from a Cell into a Worksheet-TextBox via VBA? Forced Linefeeds should be received.

•           List double existing Values including the CellAddresses - How can I list all duplicate existing Cell Contents of a Worksheet with their CellAddress in a new Worksheet?

•           List spaces in series of numbers - How can I list gaps in a series held in Column A, in Column B?

•           Transfer the names of the people with the largest turnover - How can I list the name or names with the largest turnover in a Column with the help of a Worksheet where the names and turnovers exist?

•           Filter and Copy - How can I filter a Worksheet using a criterion that is in a Cell and transfer the found RecordSets to a second Worksheet?

•           Values from Worksheet1 with additional EmptyRows in Worksheet2 - How can I add Rows of Worksheet1 into Worksheet2 so that each time an emptyRow is also added?

•           Take the Value from A1 on several Cells - How can I take the Value that is in Cell A1 on several other Cells via VBA?

•           Search and transfer Data - How can I search for values in one worksheet, and then place those values into a column next to currently active one in this workbook?

•           Replace all #DIV/0!-Error-Values by 0 in the Worksheet - How can I replace all #DIV/0!-Error-Values by the Value 0 in the Worksheet via VBA?

•           Unite the Values of each two Rows - How can I unite the Values of two on top of one another following Rows to a new, common Value?

•           Query the term of search via the InputBox and delete the Row that was found - How can I query a term of search via an InputBox, search for it, and then delete the Row in which it was found?

•           Delete Linefeeds in the active Worksheet - How can I delete all Linefeeds in the active Worksheet?

•           Assistant for calling a Dialog and evaluating Inputs - How can I call the assistant with a CheckList and evaluate this CheckList later?

•           National Lottery Numbers-Generator - How can I ascertain National Lottery Numbers randomly?

•           Ascertain the MaximumValue in an Area and enter it in Column A - How can I ascertain the Maximum Value of Column A in a Worksheet and enter it in the Row?

•           Turn off/on all Buttons with a function - How can I turn off and turn on all Buttons with a function when I press a Button?

•           Distribute a booking list to a Workbook with accounts that have to be created - How can I distribute the Booking Sets from a Booking List to accounts in a new Workbook? The accounts have to be created.

•           Distribute a Row of Values to 4 Columns randomly - How can I distribute the Values in Column A to 4 Columns in a second Worksheet randomly?

•           Link the Cellcontents via VBA - How can I unite the selected Cellcontents in Column A with the Cellcontents that are right of it at a time?

•           Control the multiselect via a Button - How can I select several Cells by clicking on a Button?

•           Distribute Data of a Table according to criterias - How can I distribute Values that are contained in a Worksheet according to criterias that are contained in this Worksheet to different Worksheets?

•           Switch on the FullScreen-Procedure when a certain Worksheet is activated - How can I switch on the FullScreen-Procedure when a certain Worksheet is activated and switch it off again when I leave it?

•           Select a File and delete it without query - How can I select a File via a Dialog so that it is deleted without query?

•           Ascertain the time of working on - How can I ascertain the length of time that a Macro has been running?

•           Unite strewed Data of different Worksheets - How can I unite to several Worksheets strewed Data in lines in an additional Worksheet?

•           List all multiple existing RecordSets in a second Worksheet - How are all multiple existing RecordSets of a Worksheet listed in a second Worksheet?

•           Multiply the selected Area with the current VAT-rate - How can I select a rate in a list of value added tax rates and add this VAT to an Area that has been selected?

•           Filter and print a Worksheet in succession - How can I filter a Worksheet in succession with different Criterias and print the respective result?

•           Bring the Data of all Files of a Directory together - How can I bring the Worksheetcontents of all Workbooks of a Directory together and leave out certain SheetAreas with it?

•           Fit in a new Worksheet with the current date via a Button - How can I fit in a new Worksheet with the current date as name of the Sheet via a Button?

•           Enter the written calculation in a journal - How can I enter a written calculation in a journal and initial the CalculationSheet for a new calculation?

•           Unhide the hidden Window and hide the active Window - How can I hide the active Window and unhide a hidden one via a Button?

•           Change the Values that exist as Text into Numbers - How can I change the Values that exist as text into numbers?

•           Set numbers that depend on the names - How can I add a second Column with numbers that depend on the first letter, to a Column with names?

•           validate a cell based on a list from another worksheet. - How can I use a list from a second Worksheet as a basis of validating a cell on the first sheet? The validation list on the second sheet must be able to be changed.

•           Identify the cell with the smallest value. - How can I always make the cell holding the smallest value a shade of yellow, as I enter values into column D?

•           Solve an inventory management problem using Sumproduct formula. - How can I solve an inventory control problem with a formula?

•           Merge cells, enter text in some rows, and fit the height. - How can I merge several rows in a Worksheet, enter text into some of the rows, and fit the height of the row to the text?

•           Put the headings of Column C in the relevant row of Column D. - I have put up headings at irregular intervals in Column C. How can I move them into the relevant rows of Column D at one time?

•           Test, if the parallel Cells match - How can I use a MessageBox to view if the Value in Column A and B match?

•           Change strings when they contain a certain text. - How can I change all Strings of Column A that contain a certain text?

•           Search for values in a hidden column and select its row. - How can I search for values which I enter in an input box? The values are hidden in column A. I want to select the entire row that the value resides in.

•           Sum a range of rows based on input box row numbers - How can I sum the values of rows that start and end using input boxes, and place the sum value in A1?

•           Label set rows in a second Worksheet. - How can I determine beginning and ending row numbers, using input boxes? I want to label the corresponding rows in a second worksheet.

•           Read out a NumberString with Formula and prevent an Error-Message - How can I test to see if a Header contains a certain NumberString, and suppress an ErrorMessage when the term doesn't exist?

•           Jump from InputBox to InputBox - How can I jump from InputBox to InputBox in a Worksheet- form without touching the other Cells?

•           Search for a value in one worksheet; copy to a second Worksheet. - How can I search for a certain value in a Worksheet and enter the found Values in a second Worksheet?

•           Show a hidden worksheet with a password input. - How can I view a hidden Worksheet after entering the right password?

•           Transfer cell contents from separate Sheets into a cover sheet - How can I transfer Values from separate Worksheets into a cover sheet, and enter the current name of the Source-Sheet in an additional Column?

•           Test a field variable to contents - How can I determine if a matrix contains a certain value without running through the separate fields?

•           Create a Workbook with 12 month sheets. - How can I create a Workbook with 12 month sheets?

•           List the ColorIndex from 1 to 56 - How can I list all ColorIndex-Numbers from 1 till 56 with the Colors belonging to them in a Worksheet?

•           Show a time-controlled user form when the file opens - How can I view a UserForm for a set time when I open a Workbook and close the Workbook again when the Label was shown?

•           Search filename in directory and subfolders. - How can I search for a file in a directory, including in the subordinate folders?

•           Display values in non-contiguous range of cells. - How can I display the values of non-contiguous cells in a range?

•           Delete all rows except the one with the highest value. - How can I delete all rows that do not contain the highest value in a range?

•           Display possible combinations from a list of teams - How can I see a list of possible pair combinations from a list of teams?

•           Copy a worksheet range from one workbook to a new workbook. - How can I copy a range in the worksheet of one workbook, and paste that range into a new workbook that I create?

•           Count the number unique values in a list - How can I display the number of unique values in a list?

•           Delete duplicate records and empty rows. - How can I delete all duplicate records empty rows in a worksheet?

•           Ascertain the Area Names and show them as Comments - How can I ascertain in a Worksheet the set Area Names and view them through Comments?

•           Ascertain if a certain Cell is selected - How can I ascertain if a certain Cell is contained in the current Selection?

•           Format the Script in the Rows alternately bold / not-bold - How can I alternately change the Type-face "bold" in two Rows?

•           Count the words in a set Area - How is the number of words within Cell A1 coherently counted?

•           Change the series of a part of a FieldName of a Workbook - How can I replace the FieldNames of a Workbook in the form of Weber_A1 or Müller_C1 by Schorsch_A1 or Wilhelm_C1?

•           Transfer the Values with the Number Format only - How can I take Values from one cell to another Cell without transfering the Interior and Script Color? The Number Formats should be kept.

•           Create a Comment-Shape in a definite size - How are Comment-Shapes created in a definite size?

•           Compare the Data in one Column of two Worksheets at the same time - How can I compare the Data in one Column of two worksheets at the same time and delete the double RecordSets? Values that are only in the first in the first Worksheet and not in the second should be at the end of the Worksheet.

•           Remember the Address of the selected Cell - How can I ascertain, later on, which Cell the Cursor was set during a certain Action and select this Cell again?

•           Call a numerical named Worksheet 1+X - I have named the Worksheets from 1 to 100. How can I call the Cell A1 in the Worksheet 1+X. "X" is a variable.

•           Limit the ScrollArea - How can I limit the Movement Area of the Cursor?

•           Enter Data that depends on the site of a CellValue - How can I search for the Value of a Cell in a Worksheet and enter the Header and the Value of the Predecessor-Cell in a second Worksheet?

•           Delete all Formulas and Numbers - How can I delete all Formulas and Numbers that are in a Worksheet so that I have only the text in it?

•           Show the Formula with the Source-Sheet-Information - I can view the Source-Cells of a Link over the detective. But the right WorksheetName isn´t shown when the Cells are in another Worksheet. How can I change this?

•           Limit the CellSelection to a selected Area - How can I limit the selection of Cells to the selected Area and reverse this limitation by command?

•           Hide Rows with Cells with a red background - How can I hide all rows that have of cells with a red background?

•           Enter the SumFormula via VBA - How can I enter the SumFormula one below the other in a variable number of Cells?

•           Compare Values - How can I compare CellContents with a group of constant Values?

•           Filter to date with the use of VBA - When I run the filter of Data via VBA it only filtered the date called by the FilterCriterion manual. How can I change it?

•           Compare the 99est SalesList with the 98est - How can I compare the customer order SalesList of 1999 with the customer sales from the list of 1998?

•           Generate a Marquee - How can I generate a Marquee in Excel?

•           Add a Worksheet and fill it with names from a List - How can I add a Worksheet and fill Column A with the workbook names?

•           Close the Properties Box - How can I close the Properties Box via a VBA-Code?

•           Remove all empty Rows and Columns - How are all empty Rows and Columns of a Worksheet deleted?

•           Search for the last Cell with contents - When I delete the Cell Contents at the extreme end of a Worksheet and call the last used Cell with END + Pos1, the just used Cell is still taken into account. How can I find the true last cell?

•           Select all Cells with the #REF-Error - How can I select all cells of a worksheet that contain a formula error ?

•           Copy the Formula till the last Row of the side Column - How can I copy a Formula in Column B till the last Cell with contents to Column A? The Cells of Column A are not filled continuously.

•           Import a TextFile into a Worksheet - How can I import a TextFile into a Worksheet of the active Workbook? The semicolon is the FieldSeparator and the contents of the active Worksheet should be deleted

•           Delete the empty Rows and Columns in a Selected Area - How can I delete all empty Rows and Columns in a Selected Area via a VBA-Code?

•           The same AreaName in several Worksheets - How can I place the same Range Name in several Worksheets? It does not work with the common selection of the Worksheets.

•           Hide all empty Columns - How can I hide all empty Columns of a Worksheet?

•           Red if the Value decreased, green if the Value increased - How can I make the Interior Color or a Cell turn red if the cell value is decreased and green if it is increased?

•           Leaf through a Workbook - How can I select the Worksheets of a Workbook in succession?

•           Arrange the RecordSets differently in a second Worksheet - How can I arrange the RecordSets that exist in 1st Worksheet with the Column-Header "Number", "Lastname", "Name" and "Place", in a 2nd. Worksheet, so that the

•           Select Column C after leaving Column B - How can I completely select Column C after leaving a Cell in Column B?

•           Change all Formulas and Links into Values - How can I change all Formulas and Links of all Worksheets of a Workbook into Values and save the Workbook as a new name?

•           Sort in lines - How can I sort all rows in the worksheet, in ascending order?

•           Compare the Columns A and B and list the double in C - How can I make Excel search through the Columns A and B for double Cellcontents and list the founded double Values in Column C?

•           Call the actual View of Cellcontents via VBA - How can I check via VBA if a Column is too narrow so that ##### is shown?

•           Copy the contents of a Worksheet from one to another Workbook - How can I copy the contents of a Worksheet of one Workbook to a Worksheet of a second Workbook so that the program itself identifies where the Data should be added

•           Protect the Workbook out of a hidden Module - When I try to protect a Workbook from a hidden Module I get an Error-Message. How can I avoid this?

•           Enter Subtotals - How can I run through a list and make Excel add in a Subtotal whenever part of a String goes in front of the first blank changes?

•           Create a PasswordFile - How can I enable the user a Password-Protection independent from the Office- and ExcelPasswords? The password should be on call every time and the Input is

•           Create a PasswordFile - How can I enable the user a Password-Protection independent from the Office- and ExcelPasswords? The password should be on call every time and the Input is

•           SafetyCheck before performing the Command - I have created a Macro that should delete the contents of an area of the Worksheet. How can I make a SafetyCheck before the deletion?

•           Take RecordSets according to two criterions on a new Worksheet - How can I take RecordSets that fulfil 2 criterions on a second Worksheet?

•           Fill all empty Cells with a placemarker - How can I fill all empty Cells of a selected Field with a placemarker and change the BackgroundColor?

•           Taking over Values with "x" in a second Worksheet - How can I take all Values that comprise of a "x" or "X" in a second Worksheet?

•           Sort IP-Numbers into groups - How can I sort IP-Numbers into groups?

•           Sort the Data into several Columns - How can I sort the Data into several Columns?

•           Arrange Data by criterions - How can I arrange Data as follows: In the Cells A2:CV11 through a RandomGenerator to ascertain numbers. All combinations should be ascertained where : A) The Value of the respective Cell is found in the Header; B) The Column with this Header comprises a Value that is found in the starting Column.

•           Enter the Football Results in a Worksheet and convert it to HTML - How can I enter the Football Results of a game day into a Table, update the chart, and then convert it to HTML?

•           Automate the bill of the water Account - How can I automate the waterbill charge for each individual tenant? Address and consumption should be called out of Tables and the costs should also be

•           Correct the SumLinks - When I delete Rows, there are ErrorReports with links to Sums. Can I correct this mistake?

•           List the Formula COMBINATIONS() with the determined Elements - How can I list the individual possibilities of combinations which I determine with the Excel-Function COMBINATIONS()?

•           Set one of three measures via the RandomGenerator - What do I have to do to use a RandomGenerator that ascertains through 50 runs if measure 1, 2 or 3 should be performed?

•           Sort alphanumeric - How can I sort a Column with alphanumeric Data?

•           Progress bar in the StatusBar - How can I install a Progress bar in the StatusBar that determines where in the VBA-Routine the work is?

•           Delete all useless blanks in a Worksheet - How can I delete all useless blanks in a Worksheet?

•           List a String from AAAA till DDDD - How can I list all combinations of a String from AAAA till DDDD in a Worksheet?

•           Run the AutoFilter through several Worksheets - How can I run the AutoFilter through several Worksheets in one go?

•           Change the Script for a Comment - How can I create a CommentBox for the active Cell in a certain Type Size by pressing a Button? An immediate Input should also be possible.

•           Make the Worksheet with Football Results topical - How can I take FootballResults on a Worksheet and update it?

•           Collect duplicate Values - How can I compare the Data in a Field that must be set and collect the duplicate Values in a second Worksheet?

•           Add and sort Worksheets - How can I add Worksheets whose names are in the Cells to a Workbook and then sort the sheets?

•           List double CellInputs - How do you list all duplicate Cell values in a Worksheet in a new Worksheet including the Cell Address?

•           Check the Areas after a Multiselection - How can I check if some Areas are in- or outside the selected Areas after a Multiselection of Areas?

•           Integrate into FunctionCategory - How can I integrate a userdefined Function into the Function- Category "Financial mathematic"?

•           Test, if 16- or 32-Bit-System - How can I test if a 16- or 32-Bit-System is installed on a Computer?

•           Take a Variable on the ClipBoard - How can I take in a Variable saved on the ClipBoard so that I can paste in any cell in the WorkSheet with CTRL+V?

•           Web-SharePriceSearch in YAHOO - How can I generate a Web-SharePriceSearch in YAHOO and put the results accurately on a DataSheet?

•           Delete the Row if a certain Value is found - How do you delete all Rows in which the Value "g" is found in Column C?

•           Select all Rows that are not empty - How can I select all Rows that are not empty via VBA?

•           Close all Workbooks or end Excel - How can I close all opened Workbooks without saving, or end Excel so that the opened Workbooks are not saved?

•           Read out selected Worksheets - How can I find out which Worksheets the User has selected?

•           Restore the StartView - How can I restore the StartView that was shown before the run of a VBA-Program at the end of the Program?

•           Copy the row height and column width. - How can I include the row height and column width when copying?

•           Enter a value in all worksheets - How can I enter a Value in the same Cell of all worksheets, using VBA?

•           Highlight the cell with the maximum value - How can I highlight interior color of the cell containing the highest value in a range?

•           Cell value as AutoFilter criterion - How can I use a cell's value as the criterion of an AutoFilter?

•           Set all non-numeric values to zero - How can I replace all non-numeric values in a selection with a zero ("0")?

•           Summarize values - If there are values in Column B, how can I move them to the following row when the term "Number" is in Column A.

•           Determine the Sum of a range of cell values - How can I display the Sum of a range pf cell values, using VBA?

•           Select three cells right the active Cell - How can I select 3 cells right of the active Cell?

•           Determine the language code of the current Excel application - How can I determine the language country code being used by the current Excel application?

•           Continue a macro after a temporary stop - How can I pause a macro while it is in the middle of a task?

•           Generate random numbers that are not repeated - How can random numbers from 0 to 24 be returned without duplicates, in the range A1:E5?

•           Go to the next worksheet - How can I always change from one worksheet to the next, using VBA?

•           Increment a number in the active workbook by obtaining the incremented value from a second workbook. - How can I Increment a number in the active workbook by obtaining the incremented value from a second workbook, and then saving and closing that second workbook?

•           Insert quantity of rows based on how many are contiguously selected - How can I insert as many rows as I have contiguously selected?

•           Display version of Excel being used. - How can I display what version of Excel I am using?

•           Display workbook file properties - How can I display workbook file properties?

•           Random sort - How can I randomly sort a list?

•           Connect and divide cells - How can I toggle to merge and unmerge a range of cells by using a command button?

•           Adding new terms to the AutoCorrection list - How can I add to the list of terms in the AutoCorrection list?

•           Autofilter also with Figures of Numbers - The AutoFilter only accepts parts of Strings not of Numbers. Can I use VBA instead of the AutoFilter?

•           Compare Worksheets - I want to compare 2 Worksheets from 2 different Workbooks and collect data that isn't doubled with VBA?

•           Add 40 new Worksheets - How can I add 40 new Worksheets to the active Workbook and name them from 1 to 40?

•           Copy a Worksheet 40 times - How can I copy the active Worksheet 40 times in the same Workbook?

•           Insert Comments in protected Worksheets - In Excel5/7 I can only enter CellNotes in protected Worksheets when the CellProtection is switched off. How can I avoid being to change the comment in Excel8 when the cell is protected?

•           Increase Values by a set Factor and round them differently - How can I increase the Values of a Selected Area by a Factor which is in Cell G1 and round them as follows: <= 20 to 2 positions after the point > 20 and <=50 to 0.05DM >50 and <100 to 0.100DM>100 and <=500 to 0.500DM > 500 to 1.00DM?

•           Order the Values 1 and 0 by chance in a definite ratio - How can I order, by chance, the Values 0 and 1 in 100 Cells in a ratio of 40 to 60?

•           Take Values that are repeated in a new Worksheet - How can I transfer Values of a Column that are repeated in a new Worksheet with VBA?

•           Arrange Matches - How are the Matches for 6 Tennis players arranged with VBA?

•           Transfer filtered Data to a new Worksheet - How can I filter a certain Group of Goods in VBA, and transfer them to a new created Worksheet with the names of the Group of Goods?

•           Search for a Number +/- 1 - How can I search for a Number +/- 1 in a Column?

•           Count formated cells - How can I count the number of all the Cells that are marked with the Interior Color red in a Selected Area?

•           Custom footer to be yesterday's date - A macro shall produce a center footer that is yesterday's date, in the format "MM/DD/YY".

•           Compare and mark Cells - I want to compare certain Columns of two Worksheets in different Workbooks. When the Cell match the interior color of relevant cells in both and the cell beside should be set to red.

•           Mark Rows - A pre-determined number of rows should be marked with a pre- determined interval in a pre-determined start row. The start numbers should be determined with input boxes. How can I run this

•           Delete Errors - How can I delete all Formulas that produce an Error Entry from a Worksheet?

•           Enter the Value in the first empty Cell - How can I fill Input Breaks with Values?

•           Sort the Cellcontents in lines - How can I sort Rows in the same way as the Columns?

•           Worksheet Names According to Date - How can I name 30 Worksheets with the Date "01.09.98" rising till the 30.09.99 with a VBA Macro?

•           Reduce a Text - How can I reduce the Text of a Cell to 15 Symbols with a VBA-Macro?

•           Open an AddIn with a Macro - How can I open an AddIn Sub with a Macro?

•           Change the Window Name - How can I add the UserName to the Name of the active Window?

•           Cell index of a found Value - How can I search for a Value so that instead of the searched Value only the Cell Index is put out (Z17S2)?

•           Transfer Values without the ClipBoard - How can I transfer Values from one field to another without using the ClipBoard?

•           Expand the named Field - How can I expand a named CellField ("DataField"), by selecting it and setting the Cursor on the lower left corner of the new defined Field?

•           Complete a Cell Input automatically - During an Input of Series of Data, is the series broken through an empty cell? The preceeding inputes are not taken into account any longer.

•           Convert DM into EURO - How can I convert a selected Field of DM-Values into EURO-Values?

•           Change comments on a group of cells Excel 97 - How can I determine if Cells in a particular range have a comment and then change them?

•           Take a Cell Value on a Cell Comment Excel 97 - How can I take the Value of a Cell on the Cell Comment of this Cell so that there is also a changing of this Cell Comment with each new Input?

•           Change a cell comment based on the value of the cell. - How can I put the value of the cell into a cell comment, which changes the comment with each new Input, too?

•           How can I obtain the properties of an active Cell with a Macro? - How can I retrieve the properties, i.e. Row & height, of the active cell?

•           Transfer filtered Data without using the ClipBoard - How can I transfer Data using an Autofilter from one Worksheet to a second without using the Clipboard?

•           Call a Macro in a second Workbook with an Argument - How can I call a user-defined Function in a second Workbook that uses an Argument?

•           Select a Worksheet - How do I choose the part of a Worksheet Name in a Dialogue Box, and select the worksheet with the part of the Worksheet Name?

•           Mark the Field with the Maximum Value - How can I mark the Cell or Column so the Maximum Value of the Worksheet is colored?

•           Convert short cuts - I copy Data to a Worksheet out of another Workbook. There are short cuts in these Data which I want to view in its whole Text in the marked Workbook. What do I have to do?

•           Sort Fields with VBA - How can I sort data fields with a VBA routine?

•           Cancel out the Links to named ranges in other Workbooks - How can I view and delete links to other Workbooks?

•           Insert Worksheets with Sequential Names - How can I insert a new worksheet and have it automatically name the worksheet sequentially?

•           Search for a specific word via an input box. - How do I search for a specific word in a Workbook through an Input Box?

•           Disable the save/replace file confirmation dialog box. - When saving a file that already exists, how can I suppress being asked if I want to overwrite the file?

•           Separate Characters - How can I divide a String into its individual characters?

•           Test if an AddIn is installed - How can I tell if a certain AddIn is enabled with VBA?

•           Divide a String - How do I divide a name into its individual Elements?

•           Hide and slot in Columns/Rows - How can I automate the costly process of hiding Columns and Rows?

•           Determine the Name of a Column - In VBA, how can I determine the column of the active cell?

•           Delete double databases - How can I delete double databases in a Worksheet without checking every separate database?

•           Correct the String - When I import Data from a Database in Excel, how can I change the string "Weber Gmbh & Co. Kg" to using a shortcut "Weber GmbH & Co. KG"?

•           Hide the Columns of a Multiselect. - How can I hide the specified columns in multiple selections with VBA?

•           Set the Color Palette to Greyscale - How can I change the color Palette so that only Grey Scales are available?

•           Delete empty Rows - How can I delete all empty Rows of a Worksheet?

•           Disable Sheet Protection - How can I disable the Sheet Protection of all Worksheets in every Workbook that are opened with a VBA Procedure?

•           Strings in numbers after the import of a text - How can I ensure that Excel recognizes a number as a number instead of as a String when importing it from another locations?

•           Disable the Workbook-Close-Test - How can I intercept the values of the ExcelTest by closing the Workbook via VBA to branch the Macro per decision.

•           Mark the Cell with the highest Value - Using the Excel Function, =MAX(), I can determine the highest Value in a matrix, but how can I SELECT the Cell with the highest value?

•           Change the European Decimal Separator to English - When I change a European style decimal point to an English period, I get an error. How can I prevent this error from occuring?

•           Change of Cells - How can I change the values in Cells A1 and B1 with a Macro while retaining the cell formats?

•           Username not printed bold in the Comment - When inserting comments, how can ensure that the username is not printed in bold?

•           Suppress the printing of cell contents - How can I temporarily set cells so that they don't print?

•           Determine the Name of a Worksheet - How can I determine if a Name of a Worksheet already exists?

•           Value from the previous Worksheet - How can I determine a value from the previously active worksheet without specifying its name and keeping in mind that the Worksheet is changeable?

•           Disable/Enable currently set shortcut keys? - How can I disable and enable currently set shortcut keys?

•           Divide a String - How can I split the String "23,1,522,abc,14" so that the values of 23, 1, 522, abc, and 14 appear in different columns?

•           Name Worksheets by Months - How can I create a new workbook that contains 12 sheets automatically labeled from January thru December?

•           Format Cells based on the Value of another Cell - How do I delete the contents of a Cell on the right of a selected Cell, and format the contents left of the selected cell, when the selected cell begins with "--".

•           Resize Cells - How can I resize all Cells of a Worksheet that already have a specified format?

•           Text Wrapping - How can I create text wrap formatting in a Cell using VBA?

•           Disable the Error-Message that appears when a text string is not found during a macro search. - How can I disable the Error Message that alerts me a when a text string is not found when using a search Macro?

•           Is the active Cell in a certain Range? - How can I find out if the active Cell is in a certain Range?

•           Find and delete duplicate entries - How do I search a column for duplicate entries and delete the duplicate entries?

•           Hide Modules - How can I hide Modules from the user?

•           Determine the first non-empty Cell. - How do I determine the first Cell containing a value in another Column?

•           Select and report Red fonts - How can I select all Cells that contain red fonts, and have a message box report the cell references?

•           Change the Mousepointer - Can I change the Mousepointer picture in Excel?

•           Copy Worksheets from other Workbooks - How can I copy Worksheets from one Workbook to the end of another using VBA

•           Search and choose a Cell - How can I search for text in all worksheets and report their location?

•           Suppression of BackUp Warnings - How can I stop Excel from displaying alerts?

•           Changing Row Height in centimeters - How can I determine the Row height in centimeters instead of points?

•           Separate a value string based on carriage return line breaks - Separate a cell's value based upon the location of carriage return line breaks.

•           Find and highlight values across multiple worksheets. - From a list of values in column A of a source sheet, search through all other sheets in the workbook and highlight values in column A of the subject sheet that are found elsewhere in the workbook.

•           Add or subtract tax price from value - Select a range of cells, and those containing a numeric value shall have 10% added or subtracted from them.

•           Web query and list sites - Through Google, a query shall list the result of related web sites.

•           Available space on a drive. - Check for available space on a drive.

•           List all possible combinations - List all possible combinations of 3 numbers from a pool of numbers that is 1 to 100.

•           Adjust column widths based on cell value - Column widths in the range A:J shall be adjusted based upon the number value in the column's respective row 1 cell. The number value shall represent a percentage of the existing column's width to then determine the actual width of the column.

•           Move, hide, and unhide a picture object on the worksheet. - Move a graphic object from cell to cell in a predetermined path, or toggle to hide and unhide the graphic object.

•           Preserve protection property of worksheet - Prior to data entry, unprotect the sheet and enter data. If the sheet was protected to begin with, reprotect it. If the sheet was unrpotected to begin with, leave it unprotected.

•           Limited worksheet protection - Protect the worksheet but allow for data entry.

•           DNS and IP query - Determine DNS from IP default, and IP from DNS default. Requires internet connection by telephone line.

•           Column letter in cell value - In the range A1:C2, click the button to toggle for the column letter to appear with the value (separated by a colon), and click again to return the cell back to its original value.

•           Copy sheets from workbooks into this workbook. - All .xls workbooks in the path specified in cell B1 shall be opened, and their first sheets (index #1 sheet) shall be copied to this workbook.

•           Sort table by color - The table is to be sorted according to the colors in column A.

•           Filter by date - Filter a data table based on what records fall in between what dates (in column B).

•           Website title extraction - Return the title of an HTML website whose value is in cell B1.

•           Checkbox confirmation - By clicking the checkbox, you are prompted by a message box to confirm that you really want that action of selecting or deselecting to take place.

•           Find a value having more than 255 characters - Excel's Find method does not accommodate strings longer than 255 characters. This is a VBA workaround.

•           Collect values based on sheet name - The values from column A of monthly sheets are to be copied to a collection sheet in the column whose header value matches the sheet tab name.

•           Hide and unhide worksheets - Hide all sheets except for the active sheet, and unhide all sheets.

•           Data saved in .txt format - Save the workbook as a .txt file without the delimiter quotation marks or commas separating the values.

•           Register unfound value - Each value in column A is to be compared with the values in column B. If the respective value is not found, it is to be registered in column C.

•           List items by its record quantity - The articles in the table on Sheet1 shall be listed on Sheet2, with the number of entries on Sheet2 based on the Quantity of each Article in the table on Sheet1.

•           Sheet protection examples - Examples of protecting the active sheet or all sheets, and unprotecting the active sheet and all sheets, with and without a password.

•           Remove spaces in between characters - Remove spaces in between characters of cells in column A using a formula method and a VBA method.

•           Select every other row - Select a range and have every second row be entirely selected.

•           Distribute a list by groups to sheets - The list in column A of Sheet1 has its group name prefixed with a letter A, B, C, or D. Each item in that list shall be distributed to a new worksheet named by those group prefixes.

•           Display sheet name and same-cell values - Column A of Sheet1 shall contain worksheet names, and the corresponding row in column B shall display the value in cell A1 of each of those worksheets.

•           Limit data entry - Allow only one entry per row through data validation.

•           Standings table update - Update a table of league standings from a gameday result of scores.

•           Save as HTML - Save each worksheet as its own workbook in HTML format.

•           Copy last row of range to another workbook - The last row of Sheet1's recordset is copied to the next available row in Sheet1 of another workbook.

•           Elapsed time data entry - The value in cell A1 is to be registered every 10 seconds, along with the date and time it is registered, grouped in 6 sets per row.

•           Delete duplicate values - Delete the rows in Sheet1 whose values in column A are found in the table on Sheet2.

•           Import a text file having more than 256 columns - A text file with an unknown number of columns but more than 256, is to be imported such that the fields are set in sets of 600 rows.

•           Conditional format based on time of day. - Cells A1, B1 and C1 are conditionally formatted depending on the time of day.

•           Spell check - The values in column A are to be spell checked. If they are not spelled incorrectly, "OK" appears next to them in column B. If they are incorrectly spelled, "Wrong !" shall appear.

•           Web page from separate cell values - A web page is to be accessed based on the individual pieces of the url that each are entered in their own cell as values, in this example in the range A1:A4 on Sheet1.

•           Text to Columns - Parse the value in cell A1 by using the Text to Columns feature to place each section of the value in its own cell where separated by the carriage return (CHAR10) location.

•           InputBox forces number only - Force an InputBox to accept only a numeric entry, without the ability to Cancel or enter nothing.

•           Import data records from text files - A range shall be populated by records that are imported from a series of text files.

•           Sheet saves as individual file - The last 3 sheets of the active workbook are to be copied to a designated folder (defined in cell B1 on Sheet1), with each sheet copied and named as its own workbook.

•           Prevent automatic hyperlink - Enter a URL or email address and disable Excel's automatic transformation of that value into a hyperlink.

•           Values listed multiple times each - The numbers in the range B1:Y3 are each to be entered 4 times in a separate column.

•           Create file folders based on cell values - File folder paths are to be created based on the sequence of their names entered in cells on Sheet1.

•           CheckBox activation dependent on other CheckBoxes - CheckBox3 may only be set to TRUE if CheckBox1 and CheckBox2 are both set to TRUE (selected).

•           Show DataForm - Excel's standard DataForm shall be displayed, populated with the records of the active worksheet.

•           BeforeSave event saves as protected workbook in another folder - Using a BeforeSave event, this workbook is saved in a path shown in cell B1, and protected with a password.

•           Save records in respective file name workbooks. - A recordlist is saved as individual files, where each file contains the records pertaining to its respective file name.

•           Text file read into UserForm label - A userform's Label control displays the text in one of 3 files depending on the command button that is clicked.

•           List common values among columns - In column C, list the common values that appear in both column A and column B.

•           Convert a photograph file into HTML - Create an HTML file of existing photo, and view it in HTML.

•           Path exists or is created - Determine if a folder and subfolder path exists. If it does, a message box appears informing the user of that. If it does not, such path is created.

•           HTML web page saved as text file - An Internet HTML webpage is to be saved as a text file in the active workbook path.

•           Data records copied and dated - By clicking the button, the data records in range A5:E8 of Sheet1 shall be copied to the next available row in Sheet2, with the date of copy to be recorded in column F of Sheet2 for each record copied.

•           Forms button created and positioned in selected range - Create a new Forms button, position it in the selected range, place a caption on it, and attach a macro to it.

•           TextBox deleted if it exists. - Determine if the active sheet has a text box. If so, delete the text box.

•           Convert numeric values to text - Number values (not constants) in a selection are converted to text by placing an apostrophe in front of them.

•           CheckBox selection updates TRUE / FALSE list - Each click of any CheckBox on Sheet1 updates the list on Sheet2 as to which checkboxes are currently selected.

•           List Outlook messages - The messages of an Outlook folder are to be read into their own worksheets.

•           Headings according to custom list - The headings from Sheet2 are to be inserted in the Index column, at each change in Index number.

•           Insert TextBox of specified length - A textbox with 12,000 characters shall be inserted on the sheet, one row below the last row of the used range.

•           Sheet change event and User Defined Functions - In range B2:E5, enter a score (numbers separated by a colon) between 2 rival teams which sorts the teams by points and calculates points, gates, and total Goals.

•           Search keyword in text file - Based on the path, file extension, and keyword, files are searched and keywords are displayed in column A if they appear in those files. Modify for criteria.

•           Cell value transfer for multiple sheets - For each sheet except the first (index #1) sheet, make the value in cell A5 be displayed in cell A1.

•           WebBrowser control in userform - Example of a WebBrowser control in a userform to search the web.

•           VBA TRIM deletes excessive spaces - Delete the excessive blank spaces in between words of the strings, using the TRIM function in VBA.

•           Separate the street name - The street name in column A shall be identified and entered in column B.

•           Replace full string with abbreviation - The table on Sheet2 shall be used to search for certain string values in the sentences on Sheet1, and replace the longer full name in those sentences with its abbreviation.

•           Comment text - The comments in column C shall be deleted from those cells, with the text being placed in the cell in column D.

•           Copy a range to another open workbook - Copy a selected range into a predetermined destination file that must be open, containing a certain sheet name.

•           Sheet activation to populate ComboBox - Populate an embedded ComboBox by activating the worksheet it is on.

•           Text file with comments identified - The comments in the used range of Sheet1 shall be transferred to a text file where they will be listed along with the cell values in this range.

•           Create array from filtered recordset - Create and populate an array from the visible cells of a filtered recordset.

•           Replace number with its associated name - Replace the numbers in column A with the names they are associated with, from the table on Sheet2.

•           Re-order list fields - Re-order the lists as they are presented in columns A:C, to place the dates and other headers in their own fields.

•           Add-in files identified - Display the names of add-ins associated with the open workbook.

•           Duplicate array redimension - Click the Start button for 10 message boxes that each display a unique value in a 13-value array, where 3 values are duplicates (see the macro code for how that is set up for this example).

•           Examine whether a text box with given name exists. - It is to be examined whether or not a text box with the name "txtName" exists in the active sheet.

•           Animated graphic download - In the active sheet a GIF animation from the internet is to be loaded. This requires a connection with Internet Explorer 5 or higher.

•           Disable command buttons - 2 of 4 CommandButtons shall be disabled by code.

•           Module comment block - Comment out the entire lines (all macros etc) of a module.

•           Checkbox control toggle - The checkbox shall toggle to hide and unhide column H on all worksheets.

•           Mouse move event - Make a comment pop up showing current time, when hovering over an object with your mouse.

•           Color the comment indicator - Place a colored drawing object shape over the comment indicator to give the illusion of a different color.

•           Conditional format - Conditionally format the cells in column C so that they are highlighted if they fall more than 5 away in either direction from the average of all the numbers in column C. Average is in cell B1 of Sheet1.

•           Find values and copy rows - Using an input box, enter what value to search for, and copy all rows where that value is found to another sheet.

•           Desktop shortcut of Excel file. - Create a shortcut icon on the desktop of an Excel workbook whose name and path are in a cell.

•           Drive letter verification - Verify that the drive letter in cell B1 actually exists. This procedure requires a library reference to the Windows Script Host Object Model.

•           Add hyperlinks to Favorites - Hyperlinks in column A are added to your browser's Favorites list. Modify the macro depending on your ISP and Favorites folder path.

•           Monitor file change by the second - A determination is made once per second if the file specified in cell B2 was changed, and if so, a message shall appear. It is advisable to run these routines in separate Excel instances.

•           Row insertion across sheets - Enter a number in the input box, and anywhere it is found on any sheet, a row shall be inserted below it.

•           Summarize many sheets into one - The Products values listed in the monthly sheets are to be summarized in the "Cover" sheet.

•           Hide rows based on cell value - Hide all rows where the word "TRUE" exists in column A.

•           Insert page breaks - Insert a page break where a certain value exists.

•           Return to previous sheet - The hyperlinks in cell A1 of Sheet1 and Sheet2 will take you to Sheet3. The command button on Sheet3 will take you back to which sheet you were on when you clicked the hyperlink.

•           Create hyperlink addresses - In column B, create hyperlinks based on the worksheet names in column A.

•           Verify hyperlink validity - For the url hyperlinks in column A, verify that they are links to valid destination addresses. Requires a library reference to Microsoft Internet Transfer Control 6.0.

•           List hyperlink addresses - List all hyperlinks with their destination addresses and sub addresses in a separate workbook added for this purpose.

•           Import and paste cells - Import the name of each .xls workbook in the path entered in cell D1, and from each such workbook, paste cell A1 of its Sheet1 into column A here, separated by 3 rows.

•           Worksheet create, delete, hide, unhide - Create worksheet for every week of the year, and provide for them to be deleted, hidden, or unhidden.

•           Examine characters for string value - Using the Like method in VBA, a macro shall determine if a string value exists in a sentence.

•           GetOpenFileName method link formula - Using the GetOpenFileName method, you click the button and select an Excel file, which becomes the source file for a link formula to be placed in cell A2, referring to the sheet and cell range in B2 and C2 respectively.

•           TextBox value changes with ComboBox - The textboxes in column C are linked to the combobox in cell A1. When an item in the combobox is changed, the textboxes display the relevant information based on the table on Sheet2.

•           List the details of formula links in the workbook. - Produce a list that details information about all formula links in a range.

•           Populate ComboBox with selectable macro names - The ComboBox shall be populated with this workbook's macros. Then click the ComboBox drop-down arrow and select a macro name to run that macro.

•           HTML macro button - An HTML file shall be opened, and a Forms button shall be placed on it, with a macro assigned to it.

•           Formula based on quantity of column entries - Enter a formula that sums the numbers in the column that is populated by the most entries.

•           Button creation and macro run - Click a button to create a temporary button that, when clicked, saves the workbbook, calls another macro, and then deletes itself.

•           Create and populate a combo box - Create a combo box in the active sheet and populate it with the 12 months of the year.

•           Combo box and Change event code. - In the active sheet, create a combo box, create a Change event procedure, place the Change procedure in the sheet module, and assign the Change procedure to the combo box.

•           Create a Forms combo box - In the active sheet, create a new ComboBox and assign it to a ListFill range (G1:G12 in this example).

•           Outlook Mail contact - An Outlook Mail contact a note is to be added.

•           Time counted in specified increments - The time in cell B1 of Sheet1 is to be incremented upwards once per second, at an interval in seconds equal to the number of minutes shown in cell E1 of Sheet1.

•           Import and display text file by line - From a text file, any string existing within parentheses, or entire lines not containing parentheses, shall be placed in their own cell in column A. Rerunning the macro shall increment by one (1) the lines listed in column A.

•           Protect non-formatted cells - Shaded cells for data entry are to be unprotected, and non-shaded cells are to be protected.

•           Registry: read, write, delete - Entries are to be written, picked out and deleted into the Registry. In the VBE a reference must be set to the Windows Scripting Host Object Model.

•           Filter by row for vertical display. - A table on one sheet is to be filtered by row and have the filtered records be diplayed vertically on another sheet.

•           Sheet name(s) identified in selection - Select a group of sheets and this macro gives a message box that tells you the name of each sheet selected.

•           Sort cells by color - Sort a column of data by its interior color index number.

•           Sort unique values - The values from one table are to be re-sorted in such a way that they only appear in their unique row based on where they first appeared in their respective column.

•           Change the value of one cell by entry in another cell. - Enter a numeric value in cell A1 to have it be subtracted from the existing value in cell A20.

•           Closed workbook link sum formula - Enter the value of summed values from a given cell on a given sheet from a collection of closed workbooks.

•           Internet disconnection - Disconnect an internet dial-up connection.

•           Conditional proper case - Convert names in Sheet1 column A to proper case, excepting the name prefixes listed on Sheet2.

•           Import a text file with 250,000 rows - Import a text file having 250,000 rows and distribute those rows over several sheets.

•           Data table import from internet - Import an Excel table from the internet.

•           Import and display a .exe file from internet - Import and display a .exe file from internet

•           Sheet tab named as cell value. - Name the active worksheet's tab as the value in cell A1.

•           Consolidation of duplicate header lists - Consolidate multiple duplicates of lists (having same header) into lists under unique headers values.

•           Merge text and align it vertically. - Merge a text value vertically, and autofit the column width.

•           Insert comment after comparison. - Insert a comment in column A if that cell's value equals the value of the cell in column C.

•           Insert picture in every sheet - Worksheet Change event inserts a picture on every sheet, sizes the picture, and assigns a macro to it.

•           Download and display an executable file. - Download and display an executable file from the internet.

•           ComboBox populated by sorted sets of items - ComboBox is populated by all items on a sheet, or items in individual columns, with itmes sorted.

•           Script for a timed MessageBox. - A Script shell is employed as a MessageBox to force acknowlegement within a timeframe.

•           Click a CommandButton to scroll a ComboBox - A ComboBox's ListFillRange property populates items that can be scrolled with CommandButton.

•           Modify hyperlink addresses - Addresses for a range of hyperlinks are modified.

•           Embedded check boxes trigger calculations - A series of embedded ActiveX CheckBoxes serve to sum values of associated cells.

•           Labels and cells are color-shaded - ActiveX Label controls and the interior color index of cells are programmatically set.

•           RGB colors reflected in ScrollBar change - The colors of shapes change as ScrollBars are changed that manipulate Red - Green - Blue values.

•           Remove the last two (leftmost) characters of values in a column - For values in column A, keep the first three characters, and delete the last two (rightmost) characters.

•           Active row is cut and pasted - The row belonging to the active cell on Sheet1 is cut and pasted to the next available row on Sheet2.

•           Copy records appearing more than 3 times - Records in a table whose date appears more than 3 times are copied to a new workbook.

•           Rows and columns deleted past last used cell - For each sheet, rows and columns are deleted past that sheet's last non-empty cell.

•           Download and open an Excel workbook - An Excel file is to be downloaded from the internet, saved to a folder, and opened.

•           Convert Email text strings into hyperlinks - Convert Email text strings into hyperlinks

•           ListBox populated by filtered records - Records are filtered and displayed in an OLE ActiveX ListBox, triggered by a WorksheetChange event.

•           List matching criteria for records on multiple sheets. - Records on multiple worksheets are searched based on user-defined criteria, and listed on the Summary sheet when found.

•           Create 12 monthly sheets and a macro to go to today's date - Insert 12 sheets (one for each month), with dates in column A and a macro to go to today's date.

•           Show the Save as Web Page dialog using a VBA command. - Show the Save As Web Page dialog using a VBA CommandBar control command.

•           Convert a hierarchical text table into a hierarchical HTML table. - Convert a hierarchical text table into a hierarchical HTML table, and save it as an HTML document file.

•           Record entries to next available row of another sheet - As receiving entries are made, the data is entered on the Administration sheet and transferred to the next available row of the Compile sheet.

•           Delete files after 30 days of inactivity - All Excel files will be deleted which have not been activated since more than 30 days ago.

•           List and hyperlink files, and their Created date in a specified path - All Excel files for a path are listed in column A, their names hyperlinked, and Created date in column B.

•           Create new email message in Outlook - For Outlook users, show the New Message dialog, with the "To" field populated.

•           Two seemingly identical values are compared. - Compare two values (12 and '12) based on the VBA syntax of Range("A1") = Range("B1"), with that code being by itself, or specified with the Value property, or specified with the Formula property.

•           Display and change names of named ranges. - Display a list of named ranges in the workbook, and substitute some characters in those names.

•           Add new sheets and hyperlink to them from table values - Add and name a new worksheet for every value in a table. Transform those table values into hyperlinks to their respective sheets. Insert, position, caption, and assign an existing macro to a Forms button on that new sheet.

•           Evaluate a folder path for quantity of Excel files in it. - Upon opening the workbook, evaluate a folder path for quantity of Excel files in it.

•           Open a workbook with Calculation mode and Update Links options set to False - Open the workbook (if it exists) per the path and file name information in cell B1, while the Calculation mode is set to False, and while the UpdateLinks option is also set to False.

•           Transfer email messages in Outlook from one folder to another. - For users with Outlook as their email client, transfer messages from one folder to another. In this example, any messages in the folder named "Delete" are transferred to another folder named "Pending".

•           List Excel files and open those that are marked. - List all Excel files in column A that are found in the file path (if it exists) indicated in cell B1. Open any files listed in column A when there is an "x" in the corresponding row in column B.

•           Userform helps define text file creation specifications - A userform provides text boxes to enter text that shall be the lines of data in a text file, and option buttons to help define part of the text file name. A text file is then created based on that information.

•           Ping web sites - Ping, and record pinged information for, multiple web sites.

•           Limit count of occupied cells - Using a SheetChange event, a maximum quantity of cells in a range are made available for occupancy.

•           Maximum character count allowed per cell - In column A, a cell is limited to a maximum character length of 35, using the Worksheet Change event.

•           File name set as default in Save As dialog - Program for the Save As dialog to have its "File name" field populated with a desired workbook name.

•           A cell's value determines its interior color index based on conversion table - The cells in column A of Sheet1 are shaded as the color corresponding to the conversion table for these Item names on the "ColorIndex" sheet.

•           Noncontiguous range allows one instance of value - Cells B22, I22, M22, and R22 shall allow for only one instance of the letter "x" or "X" among them.

•           Worksheet Change event changes color of shapes. - Change the color of a shape based on a number in the target cell of a Worksheet Change event.

•           Import and copy another workbook's worksheet into this workbook. - In cell B1 is a full path and workbook file name. Open that workbook, copy its first (index #1) sheet to ThisWorkbook, and place that newly copied sheet as the last sheet in this workbook.

•           Export each sheet as a text file - Export each sheet in this workbook as a text file, with each file named as the sheet tab.

•           Import text from a text file, considering character delimiter - Import text file data where text lines contain a semicolon (";") in its string, such that the text preceding the semicolon is in column A, and the remainder of that line (text after the semicolon) is in column B.

•           Custom command bar with changeable button captions. - Create a custom command bar, with individual buttons inserted and captioned per cells in a range. Button captions will change with changing cell values.

•           Color cells at change in value - Shade the cells in column A in alternating colors at each change in cell value.

•           Schedule of weekdays for month in given year - Dates for Tuesdays and Thursdays shall appear in a schedule grid based on month and year.

•           Cycle through a set of sequenced macros - The maximum number of actions is determined and set as a number in a cell, and as the quantity of macros to be run. Each click of the command button calls the next macro in sequence, up to the max allowed, and then the macro cycle starts at #1 again.

•           Comparison of values between lists, for value to be amended or added - Item value compared among lists, with its name added to the second list if it does not exist, or its associated quantity amended to its existing quantity if it does exist.

•           Create and name Forms buttons based on cell values - Based on a range of values on Sheet1, create Forms buttons in the same range on Sheet2, and name each button's caption as the text of its respective cell on Sheet1.

•           AutoFilter for criteria in InputBox - An InputBox provides the interface for AutoFilter criteria. The InputBox will default its criteria to the value in cell D1, but you can enter any criteria in the InputBox that you want to filter for.

•           Subtotal by areas - In a column of numbers, place a subtotal sum amount in blank cells.

•           Simulated hyperlinks with drawing objects - Cell with blue-shaded underlined text looks like a hyperlink but really is overlayed with a drawing object that has an attached macro to go the Chart1 sheet. On the Chart1 sheet is a TextBox, with an attached macro to go to Sheet1.

•           Perform VBA action in a range until a Stop value is encountered. - Populate empty cells with the value of the cell above it, in a loop that continues doing this until the word "Stop" (case sensitive) is encountered.

•           Copy rows to another worksheet where a certain value exists in a given column - Where the value "Zelda" is found in column C of the sheet named "Source", copy that entire row to the next available row in the worksheet named "Target".

•           List Excel files from selected Browse folder - Display the Browse dialog, select a path folder, and the Excel files in that folder will be listed.

•           Copy values in one column depending on presence of value in another column - Copy the contents of cells in column G into column H when that corresponding row's cell in column A contains a certain value, in this case "11".

•           Copy values in one column based on presence of whole number value in another column. - Copy the contents of cells in column G into column H when that corresponding row's cell in column A contains a numeric value, which also must be a whole number.

•           Count of visible rows with data - Count the number of visible rows that contain at least one value.

•           Delete duplicate records by row - Unique items only are obtained by row

•           List file properties for a given path - All files that reside in the path specified in cell B1 shall have their properties and information listed.

•           List and hyperlink to all Excel files in a given path - For a given folder path, list all Excel files, hyperlink to them, and display their size and last saved date.

•           Dynamic ComboBoxes - Two ComboBoxes on one sheet will repopulate with the most recent data from another sheet. When an item is selected from either ComboBox, its corresponding element shall be displayed.

•           Filter for "Or" criteria as values from separate cells using asterisk wildcard - Cells D1 and F1 contain "Or" criteria for an AutoFilter, so that if either value is part of a record, that record will pass through the filter.

•           Display file folder properties - In column B, the properties are listed for the path specified in cell B1.

•           Row and column coordinate cell values to help select cell. - The cell matching the row and column coordinates in B1:B2 is to be selected, and then the right-click menu shall appear.

•           Hide columns based on certain cell value or cell being empty - Columns with empty cells or with cells whose value is zero ("0") shall be hidden.

•           Copy non-contiguous cells to contiguous range - Copy the last five cell values in order from where they appear in one range, to a contiguous range.

•           List hyperlink addresses in a comment - Hyperlink addresses in column A are made as text in a comment that is inserted in cell B1. Each hyperlink address is placed on its own line in the comment.

•           Determine hyperlink address and file name from anonymous caption - Obtain the address of a hyperlink whose cell's caption is an anonymous value.

•           Open file based on last saved date. - A file name is evaluated for the last time it was saved. If it had been saved as recently as today, it will be opened. If saved earlier than today, it will not open.

•           Force number in InputBox - Five variations of forcing a number into an InputBox.

•           InputBox specifies number of columns to insert - A user enters a quantity of columns in an InputBox that will be inserted into the spreadsheet.

•           Keyboard shortcut for calendar week - The current actual calendar week number will be inserted into the active cell using a shortcut key.

•           Copy data based on common values between ranges - Values in a range on one sheet are compared with values in another range on another sheet. When a match is found, common records are copied to a third sheet.

•           Values compared for mid-string sequences - Values in a range are compared with all other values in the range for commonality of two sets of mid-string character sequences. Cells housing unmatching values are shaded yellow.

•           Array formula counts sum of criteria matches in table using VBA - Using VBA, an array formula is temporarily entered into a cell to calculate the count of occurrences for a pair of criteria that exist in the same row of a two-column data table.

•           Copy rows for quantity based on cell value - The records in one sheet are each to be copied to another sheet, for as many times as the number indicates in a given field.

•           Browse Folder dialog to administrate folder management - A Browse For Folder dialog is called, which opens to the folder (if it exists) in cell B1. From there, you can add, delete, and rename folders.

•           TextBox text viewed as is with line breaks, and without line breaks. - View TextBox text, either as is with carriage return new line breaks, or without those line breaks.

•           Verify the existence of a person's name in Outlook's "Contacts" folder - For users with Outlook as their email client, verify a person's name in the "Contacts" folder.

•           Range is repeatedly sorted at timed intervals - Using the OnTime method, a range is set to sort every ten seconds.

•           OptionButton groupings are identified for which OptionButton within them is active - Two groups of OLE ActiveX OptionButtons are evaluated for which OptionButton is selected.

•           Determine the quantity of emails in a given Outlook folder - Determine the quantity of emails in a given Outlook subfolder of the Personal Folders list.

•           Navigate the web with a userform and WebBrowser control - A userform with a WebBrowser and CommandButtons help to navigate pages on a web site.

•           Generate prime numbers between one and ten million - In Sheet1, a list of prime numbers is generated that fall between 1 and 10,000,000.

•           Program version - The version of the program indicated in cell B1 is determined.

•           List subfolders of a given parent folder - A MessageBox shall display all subfolders of a specified path as indicated in cell B1. Requires an established reference in the Visual Basic Editor to Microsoft Scripting Runtime.

•           List information about a given file name - Populate the provided fields for each applicable property of the file name in cell B1.

•           Determine the computer's default email client program name - Read the computer's registry and display the name of the default email client program.

•           Read text file into a Message Box - For the text file name in cell B1, display the contents of that text file in a Message Box.

•           Import data from the first sheet of a workbook in a given path - In column A of the active sheet, import data from column A of the first worksheet in every Excel workbook that is located in the file path indicated in cell B1.

•           List and print the file names of a given folder - List the Excel workbook names in the file path indicated by the value in cell B1, and print that list.

•           Data-validated cells allow user to select Sort Key header values - Sort Keys as header values are chosen by the user in data validated cells to define the primary and secondary keys for sorting a data range.

•           Sort worksheets named by month and year - Sort worksheets in ascending order for a workbook whose tabs are named in MMMM YYYY format.

•           Numeric values in OLE TextBoxes are summed. - Numeric values in four ActiveX textBoxes are summed.

•           New workbook dialog displayed via CommandBar control call - Invoke the CommandBar control that calls the New workbook dialog.

•           Names and count of open workbooks - Display the names and quantity of workbooks that are open in this workbook's instance of Excel.

•           Unhide and activate sheet based on button caption - Navigate worksheets with one macro by clicking onto a Forms button whose caption is the name of the worksheet you want to go to.

•           Determine the number of visible rows - A Message Box shall display the quantity of visible (unhidden) rows there are on the worksheet.

•           Select and open an Excel workbook from the Open dialog. - Call the Open dialog for a specified file type (Excel Workbook in this example) and select a file to open.

•           Worksheet data emailed as HTML interactive format - For users with Outlook as their email client, a worksheet table is emailed in interactive HTML format

•           PowerPoint presentation is created using an embedded chart - A PowerPoint presentation is created using an embedded chart. This requires a reference to be established in the Visual Basic Editor to the Microsoft PowerPoint [version#] Object Library.

•           Delete OLE Forms and ActiveX CommandButtons - Delete all Forms buttons, and all ActiveX CommandButtons that are embedded on a worksheet.

•           Inventory of items in stock is changed to reflect the sales of those items. - Item models in stock on the Inventory sheet are deleted based on the Item models that were sold.

•           Clear the clipboard. - Clear the clipboard of all data formats.

•           OLE controls are selectively deleted - Embedded ActiveX controls: delete all on one sheet, and only one type on another sheet.

•           Replacement in text file of recurrent characters - For the text file indicated in a cell, look for two sets of double quotations in succession, and if found, replace that with one set of double quotations.

•           Text file converted to Unicode format - The text file name in cell B1 shall be converted into a Unicode format text file.

•           Delete the first and last characters from every line in a text file - For the text file indicated in cell B1, delete the first and last characters of each text line.

•           Open dialog with default file name - The Open dialog is called, with a hard-coded file name which shall occupy the "File name" field.

•           Toggle a cell from containing a constant value to containing a formula - The contents of cell M21 are toggled from a formula to a constant value, and back again.

•           Text files from specified path imported to new workbook - From a given folder path, all text files shall have their first lines imported into a new workbook.

•           List text file names from Browse dialog - Call the Browse dialog to select a folder from your choice of path, and list all text files in that folder.

•           Comment text added to Outlook Calendar entry - For users with Outlook as their email client, this macro will place a comment (text of cell B2) into each entry made for the Outlook Calendar day whose date is in cell B1.

•           Send email with text file attachment - For users with Outlook as their email client, send an email to the address in cell B1, with an attachment that is a text file specified in cell B2.

•           Sheet tabs are protected against change by workbook protection - Workbook protection with structure set to True disallows (among other things) the renaming or rearranging of sheet tabs.

•           Digit characters extracted from one text file to another - From a source text file, any digit characters (0 to 9) are displayed in a Message Box, and copied into a destination text file. The Source file itself remains unchanged.

•           SaveAs dialog with default file name - Call the SaveAs dialog with a SendKeys command to place a file name value into the "File name" field.

•           OLE connection established with Word document - The Word document specified in cell B1 shall be opened, with its contents embedded onto a worksheet, and with a link established from that object to the source Word document.

•           Comment text is VBA macro code - A comment's text displays a macro's code, with a time and date stamp for last execution.

•           Find and replace a word in a text file, and save as another text file - Specify a word to find and replace in one text file, then copy and save that new text into another text file.

•           Show the Find and Replace dialog using VBA - The Find and Replace dialog is called using a CommandBar Control execution in VBA.

•           Text file imported via Query Table - A text file is imported into the active worksheet as a Query Table.

•           Internationally formatted negative numbers are reformatted for standard appearance - A range of numbers is reformatted such that international characters that signify thousand separators are standardized as commas, and trailing negative signs are moved to the front of the number.

•           Open a new Word document - Example of opening a new Word document using Late Binding.

•           Evaluate clipboard for contents - Evaluate the clipboard for any data format types that may be on it.

•           Parse string value based on line breaks - A value in one cell that has carriage return line breaks shall be parsed so that each element of the string that is separated by a line break is made to occupy its own cell.

•           Import text file having more than 256 columns - A text file having more than 256 fields is imported, with fields continued onto the next worksheet.

•           Select the next visible worksheet - Select the next indexed worksheet, with consideration for bypassing a sheet that is hidden.

•           Send an email in Outlook to multiple recipients - For users with Outlook as their default email client, a macro shall send an email to multiple recipients.

•           Add text to existing text - Existing text strings in column A are appended by text you enter for that purpose in an InputBox.

•           Each value in a smaller range is checked for presence in another larger range - Using the VBA MATCH function, values in one range are evaluated for presence in another range.

•           Forms buttons with one macro format a selection depending on relative location. - One macro serves 3 Forms buttons to format a selection based on the commonality of the selection's upper left cell and the column the Forms button rests in.

•           Populate ranges identified by cell values - Ranges listed in cells on the Ranges sheet are populated after being identified as belonging to the same column as the one holding the Forms button being clicked.

•           Select a worksheet cell upon selection of item in ActiveX OLE TextBox. - Selecting an item in an ActiveX TextBox also selects the worksheet cell holding that item's value.

•           Verify internet connection - Determine and verify that an internet connection exists on your computer.

•           List names from an Outlook Address or Contacts folder - Populate a range with name(s) and address(es) from an Outlook Contacts or Address Book folder.

•           File is open, activated or determined to be nonexistent - Determine if a file exists and if so, open it if it is closed, or activate it if it is open. If the file does not exist, inform the user with a Message Box.

•           Web query with parsed URL values - A currency exchange website is to be queried, with dozens of currency acronyms evaluated.

•           Scrolling text in Status Bar - The status bar will display a scrolling text. The number of times the text will scroll is set in cell B1. The scroll speed is set in cell B2.

•           Data Validation set in a selected range via macro - A range of selected cells is to be data validated by VBA, whereby only numbers are allowed greater than zero and decimalized to not more than one decimal place.

•           Save worksheets together as another file without VBA code or button objects - Save this workbook's worksheets as a new file name, without the above Forms button or macro code.

•           Autofit selected column widths - Columns in a selection that are unhidden (visible) are made to have their widths be autofit.

•           Web query evaluates tax number status - Web query to use WDDX (Web Distributed Data Exchange) to evaluate a list of tax numbers.

•           Insert daily worksheet for a fiscal year. - Insert a fiscal year's worth of worksheets, by adding 365 new worksheets and naming their tabs with dates for the next 365 days, beginning with today's date.

•           Random number draws compared to independent draw - Lottery-type example of drawing numbers for 255 random plays, and tallying frequency of matches.

•           Hide the workbook window automatically. - When this workbook opens, its window is automatically hidden.

•           Personal workbook maintenance - How can I hide and save my Personal.xls workbook?

•           Copy active sheet into new workbook - How can I copy the active sheet without the Forms button to a new workbook, and make it be the last sheet in that new workbook?

•           Create an array programmatically - How can I set values in a range into an array using VBA?

•           Copy active sheets of files into this workbook - How can I call the Browse dialog to select a folder, and copy the active sheet's used range from each Excel workbook in that folder to a single worksheet in this workbook?

•           Yesterday's date in footer - How can I set the left footer as yesterday's date?

•           Delete link formulas - Selectively delete certain link formulas that reference a given workbook name.

•           Save file with name as cell value. - How can I save this workbook as the filename based on a cell's text value?

•           Email this workbook - What code can I use to send this workbook as an email attachment?

•           Delete rows with empty fields - How can I evaluate each record in a table and delete the records whose certain fields are all empty?

•           Dynamic ListBox population - How can I make an embedded ListBox display the changing values in a list on my worksheet ?

•           Delete macro after one execution - How can I call a macro just one time, and delete it from the workbook after it runs?

•           Create new workbook with macro and VBA module - When opening this workbook, the user can create a new workbook, along with a Forms button to which is attached a macro that is also created with that new workbook.

•           List duplicate records - How can I evaluate a table for duplicate entries across all fields, and list all the found duplicates in a new worksheet?

•           Custom command bar with 5 separate macro buttons - How can I build a workbook-specific custom command bar, and have 5 separate buttons on the bar that each shall run its own dedicated macro when clicked?

•           Search multiple instances of value - How can I scan a range for a certain term and provide a Message Box that identifies the cell's address where the term exists?

•           SelectionChange event automatically expands selection to preset range size - How can I arrange for a cell to be selected, and use the SelectionChange event to automatically expand the selected range of cells to a preset size of 1 row high by 10 columns wide?

•           Two userforms - How can I call one userform from another to confirm the entry of a new value in a range?

•           Copy cells with certain strings in their formula - For cells containing "SUBTOTAL" in their formulas, how can I copy those values into a separate sheet?

•           Custom menu item - How can I create a custom menu item and assign that item to a macro, for this workbook only?

•           Identify cell value in list with offset value - I have a list of values in column B. How can I put an "OK" value in column A of the row where a "2" value exists anywhere in my column B list?.

•           Send sheet as email at timed intervals - Is there a way to email a worksheet from this workbook as its own sheet in a new workbook attachment, and continuously email it at every time interval as specified in a worksheet cell?

•           Random redistribution of items, iterated multiple times - For a list of values from A1:A10, how can I randomly re-list those items in one hundred 10-cell ranges?

•           Numeric values are sequentially listed via InputBox method - How can I utilize an InputBox to enforce the entry of numbers only, and to register the numeric value in the next available row of a worksheet column?

•           Delete sheets based on cell values - How can I delete the sheets whose tab names are represented as values in a range of cells?

•           List AutoCorrect settings - How can I list my computer's AutoCorrect settings?

•           Keyboard shortcut on workbook activation - How can I arrange my workbook to assign a keyboard shortcut to an existing macro when this workbook is activated, and allow for that shortcut to resume its normal behavior when the workbook is deactivated?

•           Save workbook only by Command Button - How can I ensure that the workbook is only able to be saved by clicking a userform CommandButton?

•           Random sublist of master recordset - How can I randomly list a given count of records from a master recordset housed on a different sheet?

•           Match items in list and format unmatched - I have a table of items and their prices on Sheet1, and a master list of items and prices on Sheet2. How can I update my prices on Sheet1 by matching the items with the master list, and color the cells on both sheets when item values are not matched?

•           Disallow duplicate entries - How can I disallow entry of duplicate values in one column using VBA, and in another column using data validation?

•           Send email to a list of recipients - What code can send an email that uses a 3-field table of recipient address, subject, and body text?

•           Random placement of graphic objects - How can I arrange for a set of embedded picture objects to be randomly set into a range of cells each time I press a keyboard shortcut such as Ctrl+A?

•           Programming to a Forms ComboBox - I have embedded a ComboBox control from the Forms toolbar. How can I programmatically populate it with the 12 months of the year, and display its currently selected item in a Message Box?

•           One macro assigned to several Forms buttons to activate different worksheets - How can I devise one macro to assign to any number of Forms buttons that, when one of the buttons is clicked, will take me to the worksheet whose tab name is the same as the clicked button's caption?

•           Conditional distribution of records to separate workbooks - How can I set the workbook at Close to let the user choose to distribute the records in a master table into appropriate other workbooks depending on the numeric value of one of the record's fields?

•           Conditional rows in range saved as CSV - I have a range where some cells in one column are populated with values and some cells are not. How can I include only the rows where cells in that column hold values as part of the range that shall be saved as a CSV file?

•           Import text file - How can I import the text from a text file into a new worksheet in this workbook?

•           Edit Outlook contact information - How can I update the business telephone number of a person's name in my Outlook's Contact folder?

•           Delete some embedded objects - How can I limit the deletion of certain embedded objects while not deleting all of them?

•           Search worksheets for current weekday date - How can I search all worksheets for today's date, and if found, activate the sheet and cell holding the current date? If the current date is a Saturday or Sunday, I want to activate the next Monday date.

•           Copy negative numbers and paste as positive - How can I copy a list of numbers, some of which are positive and some of which are negative, into the next available column, making sure that all numbers copy over as positive?

•           Match multiple field values - I have a recordset on Sheet2 with multiple fields. On Sheet1, I have a small form to enter individual field values. How can I match all field values on my form with a particular record, and populate another field in that recordset if a match is made?

•           Clipboard data type - How can I ensure that only text-type data on the clipboard will be pasted into a destination range?

•           Copy rows when value exists in certain column - I have a recordset on Sheet1. How can I copy only those rows that contain a value in column Q into another worksheet?

•           Delete all hyperlinks - How can I automate the process of deleting all hyperlinks on a worksheet?

•           Toggle the visibility of two buttons from a third button - How can I employ one Forms button to toggle the visible property of two other Forms buttons?

•           Increment maximum numeric value in one column based on change in another column - How can I automatically insert the next highest number (incremented by 1) for numeric values in the same row in column A as a cell I change in that row for column B?

•           Web Query - Refresh a Web Query

•           ActiveWindow range address - How can I obtain the address of the active window's visible range?

•           Verify existence of substring format in larger string - How can I test for a date in a certain format that itself is a text substring in a larger string value?

•           Parent file folder path - How can I determine the parent folder path of the folder housing this workbook?

•           List records associated with minimum or maximum value. - I have a recordset with list of Items and their corresponding numeric values. In another table, how can I list only those Items that are associated with the minimum numeric value?

•           Reorganize data into table by matching row and column headers - I have several blocks of data that represent one of ten row categories, in one of three column categories. How can I organize the data into a by placing all the values into their respective intersecting cell of a table on a separate worksheet?

•           Create a new instance of Excel - How can I create and open a new instance of Excel?

•           Copy HTML text to clipboard and paste to worksheet cell - Please show me an example of how to paste a line of text onto the clipboard in HTML format, and paste that HTML text into a worksheet cell.

•           Convert special characters into HTML file - How can I store the foreign language text value into an HTML file, and convert its characters to unicode?

•           Import a graphic file - What code can I use to download a graphic file from an internet URL address?

•           Drive memory - How can I determine the total, used, and free memory status of a given drive on my computer?

•           Linked application - How can I determine the linked application associated with a path and file name?

•           Duplicate values among worksheets - How can I disallow the entry of a value that exists in the same cell address of a different worksheet?

•           Insert row with header at new 1000 increment of listed numbers - How can I identify each incremental change of 1000 in a list of numbers, insert a new row there, and place text to mark the start of which actual 1000 number set is commencing?

•           Goal Seek - Show me how to use Goal Seek in a macro to complete the population of a range of numeric values.

•           Selected ranges inserted in email body and emailed - I have a large range of data and want to select multiple individual ranges that should be separately inserted and displayed into the body of an email and emailed to specified address. How can I do this?

•           Update links - How can I open a set of files for the purpose of updating its links, and then close the files again?

•           Select printer - Before a sheet is printed, how can I devise a macro to ask the user to specify which printer to use, and then return the settings to the default printer after the printing has completed?

•           Copy rows from multiple ranges into separate worksheet - I have a large range of data. How can I copy the rows of multiple selections at once into a separate worksheet?

•           Transfer dynamic master data to worksheets - How can I call a given worksheet and have it display a dynamic data set from a master source sheet?

•           Delete duplicates and consolidate by sum - How can I consolidate a table such that duplicate Names in that field will be deleted, but each record's Quantity value will be summed and displayed in its field of the surviving unique Name's record?

•           Select every other worksheet - How can I select every other worksheet starting with the active sheet?

•           List only unique values from selection - I have a list of values in column A, many of which are duplicates and that is OK. If I select any range within column A, how can I list only unique values in column B among the values in that selection?

•           Count printable pages on each sheet - How can I determine the first and last printable page number for each sheet?

•           Graphic changes shape and color when clicked - How can I provide for a graphic object to appear to cycle through shapes and colors when clicked?

•           Hyperlink copies cell value - If I have a cell with a hyperlink to another cell on another sheet, how can I copy the value of the hyperlinked cell into the destination cell?

•           OLE ComboBox simulates AutoFilter menu - I have a recordset and want to use a ComboBox as the filter interface instead of using an AutoFilter. How can I do this, without actually ever invoking the AutoFilter method?

•           Copy last instance of value to next row - I want to look for a certain value, and whatever the last row is where that value is found shall be copied to the next available row. How can I do this?

•           Page breaks - How can I delete manual page breaks and use VBA to insert fresh page breaks at 50-row increments?

•           Random population of array elements - How can I randomly select five values from a larger list, and place them in an array?

•           Data compilation summary from multiple sheets - How can I summarize separate worksheet tables relating to customer transaction activity into one compilation table onto a third worksheet?

•           Merge cells by row across columns - How can I merge cells individually row by row in a range of selected cells when that range spans across more than one column?

•           Email individual worksheet - How can I place a given worksheet in its own workbook and email it to an address, whose name, destination address, and subject line are values in cells?

•           Dialog inquiry of name and password - Excel5 / 95 dialog inquiry of name and password at workbook open.

•           Copy sheets with matching email addresses to new workbook - How can I copy all sheets into a new workbook whose email address value in cell C5 matches the email address value specified in an InputBox?

•           Module and userform export - How can I export modules and userforms from a specified file into backup .BAS and .FRM files?

•           Ranges copied into same address on other sheet - How can I select a single range or several noncontiguous ranges on Sheet1, and copy them all to Sheet2 into the same destination addresses as the source addresses where they were copied from?

•           Print sheets based on checkboxes - How can I print (or not print) certain worksheets depending on which sheet's corresponding CheckBox from the Forms toolbar is checked or not checked?

•           Copy and paste several noncontiguous ranges - How can I select several noncontiguous ranges from one worksheet, and invoke an InputBox to specify the destination paste address on another worksheet for each selected range to be copied to in turn?

•           Random number generation displayed in ascending order - How can I simulate the selection of five non-repeating numbers between 1 and 49 such as a lottery draw, and in the adjacent column rank each number in ascending order?

•           MouseOver event for ole activex objects - How can I display a unique color for an activex CommandButton by hovering my mouse over it, while making the other activex CommandButtons return to a neutral color?

•           Custom right-click menu transfers data to clipboard - How can I add a custom item on the right click menu to display the values of various functions such as SUM, AVERAGE, and COUNT for a selected range, and send any of those values to the clipboard?

•           Delete formulas that return errors - Use the SpecialCells property to identify and clear formulas that return errors.

•           Email multiple files to each address listed - I have a list of file names in column A and a list of email recipient addresses in column B. How can I write a macro that will send each file listed in column A to each email address listed in column B?

•           List redirected URLs - For a list of URL hyperlinks, how can I list their redirected actual URL destination address?

•           Hyperlink to colored cells - How can I list the addresses of colored cells on different worksheets, and hyperlink to each address?

•           Create new workbooks with embedded controls - How can I create 3 new workbooks, each with three embedded OptionButtons, and code their Click event into the new workbook's Visual Basic Editor?

•           Toggle to show and hide the worksheet Menu command bar - How can I use one macro to toggle the Menu bar to be visible or hidden with a click of the same button?

•           Unique one-time pairings of teams - How can I take a league of 8 teams and create a schedule such that each team plays each other once?

•           Activate sheets from embedded ListBox - How can I embed an activex ListBox that will update itself with all the workbook's sheet names whenever I activate the host worksheet, and when I select a tab name item, I will be taken to that sheet?

•           Identify name and status of last activex object clicked - How can I avoid a class module while identifying the name and status of the most recently clicked CheckBox of the four embedded activex CheckBoxes on my sheet?

•           Height and width of text - How can I determine a text string's height and width, considering font size and type?

•           Hyperlink to files as cell values - For a selected range of cells, how can I convert those values into hyperlinks pointing to those files, only if those files really exist?

•           Header Footer text based on cell values - How can I ensure that the footers (left, center, and right) are set by the text based on cell values, and shall only be set that way when a certain worksheet is printed?

•           Compare dates for matching year - How can I compare lists of dates in several worksheets against a given year, and delete the rows where dates in column A do not match that given year?

•           Concatenate selected values - How can I concatenate the values of selected cells, delimit them with a comma, and place that string in a cell, all with a keyboard shortcut?

•           Distribute source records among designated sheets - How can I distribute a range of records to individual worksheets based on their Group field designation, which corresponds to a table I set up that assigns each Group field designation to a sheet tab name?

•           List files with various extensions - How can I list all files from a given path into a worksheet, and include several file extension types?

•           Select ranges based on selected checkboxes - How can I select or deselect ranges based on the selection and deselection of embedded checkboxes?

•           Fill empty cells - How can I arrange for two Application InputBoxes, one to specify a range and the other to request a value, which shall be entered into the empty cells of the specified range?

•           List and hyperlink to found files - How can I use the FileSearch method to loop through a list of paths, and for each path, list and create a hyperlink to the file names that satisfy the FileSearch criteria?

•           Import data from certain cells in external workbook - How can I call the Open dialog, select a workbook name from any path, and import values from a list of cell addresses into those same cell addresses on the Import worksheet of this workbook?

•           Hide rows within PrintTitleRows property range - How can print a sheet while I hide 2 rows that fall within the range of the PrintRows property?

•           Edit comment text - How can I delete the preceding default user name, colon and new line characters from all existing comments on the worksheet, so only the basic text is displayed in the comment shape?

•           List worksheet command bar menu attributes - How can I list the attributes of a given workheet command bar menu item?

•           Delete empty rows - How can I delete row(s) in a range when all the cells for a given row are empty?

•           Delete cells where empty in column - How can I delete empty cells and shift the cells upward in that column?

•           Delete cells containing formula errors - How can I delete cells and shift the column upward when cells are found to contain errors returned by formulas?

•           Clear cell contents of shaded cells - How can I clear the contents of cells in my used range that are shaded a certain color?

•           Delete rows when cell in column is empty - How can I delete an entire row based on the cell in a given column being empty?

•           Clear error formula cells - How can I clear the contents of cells in my used range that contain erroring formulas?

•           Delete cells containing certain value - How can I delete a cell containing a certain value, and shift the rest of the cells in that column upward?

•           Delete all empty cells in used range - How can I delete all empty cells in a used range, and shift the other cells upward?

•           Identify a pop-up menu item - How can I identify a given right click menu's pop-up item by referencing its index number?

•           Pop-up menu position on screen - How can I specify where the right click pop-up menu shall appear on my screen?

•           Hyperlink dialog constants - How can I insert hyperlinks onto each dialog name listed, and call the dialog by clicking the hyperlink?

•           InputBox examples - Twelve examples of InputBoxes; 6 for Functions and 6 for Methods.

•           Sort by custom list - How can I sort a table based on a custom order that I specify?

•           Bubble sort a list of dates - How can I employ an array-based technique to sort a list, instead of using VBA's Sort method?

•           Sort by frequency of value in list - How can I sort a list of values based on how many times the value appears in the list, with the most frequently-occurring values sorted ahead of the less-occurring values?

•           Two methods to call Sort dialog - Please show me two different ways I can call the Sort dialog while selecting the range to be sorted.

•           Sort multiple tables in one macro - How can I sort four separate tables in ascending order by their respective values in column A?

•           Sort a range with hidden rows - I have a range of data that I want sorted, but some rows are hidden. How can I ensure that the entire range is involved in the sort, and the hidden rows stay hidden?

•           Sort by special characters - I have a list of names that I want to sort, but some names have special characters. How can I devise a macro to consider the sorting order based on special characters I specify?

•           Bubble sort worksheets by their tab name - How can I employ an array "bubble sort" approach to sorting my worksheets by their tab name?

•           Bubble sort a list of files from selected folder - How can I call the Browse dialog to specify a folder, list all the files in that folder into column A, sorted in ascending order using a "bubble sort" array?

•           List files in selected folder sorted by last modified date - How can I call the Browse dialog, select a folder, and list the names of all files in column A, their last modified date in column B, and sort the two-column list by last modified date?

•           InputBox to select cells for row deletion - How can I code an InputBox to ask the user to select a cell or cells, and for the selected cell(s), delete their entire rows?

•           One macro for all buttons to clear active row - I have a series of Forms buttons on my sheet running down column A. Is there one macro I can assign to all buttons at once that will clear the contents of the row of the button that was clicked?

•           Create a new textbox and populate it with text from cells - How can I create a new TextBox on my sheet, and set its text as the values in a range of cells?

•           Make a CommandButton blink off and on - How can I make a CommandButton blink off and on?

•           CommandButton blink with different colors - How can I make my embedded CommandButton blink with different colors?

•           Show userform whose name is cell value - How can I call a userform whose name is a cell value?

•           Maximum character length in range - Of all the text values in column A, how many characters in length is the longest one?

•           Pivot Table grand total - I generated a pivot table with a grand total at the bottom. How do I access this number in VBA and set its number as a variable?

•           Add carriage return character to range - I have a list of values in column A. I want to add a "carriage return" character to the end of the value if one does not already exist. How can I do this for all cells at once?

•           List annual schedule of paydates - How can I list all paydates for the current year and create a table of frequency count of paydates for each month, and format the current month in that table?

Images and Charts

•           Copy picture in second worksheet in same position - A picture is to be copied into sheet 2 in the same position

•           Enlarge picture and bring in back. - When clicking on a graphic, it shall be enlarged, when clicking again it shall be brought back.

•           Add and delete word art elements - When activating the CheckBox, a work art element is to be added, and deleted when deactivated.

•           Change a chart series color depending on the source data - When changing the value in cell A2 to >5/<5, the series collection interior color is to be changed.

•           Save worksheet as graphic file - The selected area is to be saved as a gif graphic

•           Create a Chart, show it in a UserForm and print it - How can I create a Chart from an Excel-Worksheet, save this as a graphic file, load it in a UserForm and print it from there?

•           Change the Chart-DataSeries with the VBA - How can I change one Chart-DataSeries with a VBA-Command?

•           Call a UserForm with SpinButton for the DataSeriesSetting - How can I call a UserForm with a SpinButton for the setting of Values in a DataSeries via a Button in a Chart?

•           Move through a Worksheet with a Chart-ScrollBar - How can I move through a Worksheet with a ScrollBar that is in a Chart?

•           Unhide Graphics from hidden Sheets - How can I create an ArrowMenu in a Worksheet? When I click an arrow a Graphic from a hidden Worksheet should be shown and the arrow should change its color.

•           Set the Chart-Data area via a Button - How can I set the Data area of a Chart when I press a Button?

•           Datalabels-Source area outside the Data area - How can I set the Source Area as the Area outside the Data for the Datalabels in a Chart?

•           Load a Graphic after a DoubleClick - How can I make a Graphic appear in a cell next to the one with the specified path when I double-click on the cell?

•           Create a series of Charts and show the Print View - How can I create a series of Charts from a Worksheet and show these one after another in the Print View?

•           Fit in a Picture depending on a CellInput - How can I fit a Picture in Column B depending on a CellInput in Column A?

•           Control the Elements in a Worksheet like Pac-Man - How can I control the Drawing Elements inside a Worksheet so that the impression of a Pac-Man-Play is created?

•           Pictures in an UserForm and fit the Picture-size - How can I list the Pictures of a Directory in an UserFrom DropDown Box and view them in the UserForm after the selection? The Picture size should be fitted to the UserForm automatically.

•           Let the Chart-DataSeries flash and draw a Line slowly - How do the DataSeries appear in a Chart flash and how can I draw a Line piece by piece so that the course can be followed?

•           Show a picture for seconds - How can a picture be shown in a Worksheet for a few seconds?

•           Form a Diagram from Data of one Waveband - How can I separate Data of a definite Waveband from a Worksheet and create a Diagram from it?

•           Enter and delete Pictures in a VideoList - How can I insert and delete Pictures in a Worksheet with a list of videos?

•           Insert a graphic when a cell's value falls below a limit - When a formula returns a value below a predetermined limit, how can I make VBA automatically insert a Warning notice?

•           Move a chart from one sheet to another - How can I move a chart from its current location to a new worksheet, using VBA?

•           Arrange Graphics in a Worksheet -Excel8- - How can I arrange graphics in one Worksheet directly below the other?

•           Export of Sheets in the Graphic Format - How can I save Excel Charts as a Graphic, for example as a *.GIF File?

•           Graphic in Header - Can I view graphics in a Header?

•           Dynamic graph data - A graph's data series is made dynamic by being defined by the addition and deletion of source values.

•           Animate a text box - An animated text box is to be moved over the sheet.

•           Copy and paste photographs - The group of pictures in the range M1:O8 of Sheet1 is to be copied to the same range in Sheet2.

•           Create a dynamic chart - Clicking the button shall delete an existing chart and create a new one with the data in the current region.

•           Import a graphic file from the internet - From a URL stored in a worksheet cell, import a graphic (photograph) object from the internet.

•           Insert a picture on the sheet and center it - Place a picture file on the sheet (path in cell B1), and center that picture within a cell.

•           A picture is hidden or made visible by the Worksheet Calculation event. - A conditional formula, when recalculated, hides or makes visible a picture object.

•           Import graphic object from website - Import a Counter picture object from a web site.

•           Photos shown in comment shapes - Photo files of a given path are listed by name, with their image filling a comment shape.

•           Toggle a drawing shape's color upon selection - Toggle a drawing shape's color from white to black, then to white again, as a toggle action each time the shape is selected (clicked on) by the mouse.

•           Open photo files in HTML - Select a range of photograph text hyperlinks and open each one in its own HTML window.

Menus and Toolbars

•           Deactivate menu item "insert cell" in context menu. - The menu item "Insert cell" of the cell context menu shall be deactivated in the active workbook

•           Insert menu item to create a commentary - Inserting a new menu item "My comment" in the INSERT menu, enabling composition of a new comment without pre determined user name

•           Set up new symbol bar at the right window frame - A new symbol bar is to be set up at the right window frame

•           Set up menu item when activating a workbook - When activating a workbook with the string "KN" in the name, for instance "WKN.xls", a new menu item "KN command" shall be displayed in the worksheet menu, and deleted when the workbook is closed.

•           Display user defined menu bar in sheet 2 - When activating sheet 2, the user defined menu list is to be displayed, and disappears by deactivation

•           List opened workbooks in menu combo box - The current opened workbooks are to be listed in a CommandBar-ComboBox in the worksheet menu bar for selection

•           Custom menu macros - Custom menu with 4 options, with a macro assigned to each or UDF formula entry, value entry, and range selection.

•           Listing of option buttons in a context menu - List all option fields from sheet in cell context menu (right mouse click) and sort cell underneath selected option field.

•           Ceate a PopUp-Menu with handicaps for entries - How can I create a PopUp-Menu with inputs from a DataSheet after changing in an entry form? After selecting a MenuItem the relevant RecordSet should be entered.

•           List all Menu and Command Bars with its Buttons - How can I list all Menu and Command Bars in a Worksheet?

•           If the Window is divided, show Context menu each time in the other Window - How can I open an userdefined Context menu each time in the other Window when I press the right MouseButton in a vertical divided Window?

•           Choose and select Shortcuts through the Contextmenu - How are Shortcuts that are pre-determined in a Worksheet, read in a Context menu? After calling the Context menus, the cell with the selected Shortcut should have a red Interior color.

•           Create a CommandBar with ComboBox - How can I create a CommandBar with a CommandBar ComboBox and fill it with the Values, filenames, of Column A of a Worksheet when I open a Workbook? When I select a file in the ComboBox this file should be opened.

•           Close a Workbook only with a Button - How can I prevent a Workbook being closed via Menu- or CommandBarButtons?

•           Show the Data of the current Row in the PopUp-Menu "Cell" - How can I view the Data of the current Row in the PopUp-Menu "Cell" ?

•           Custom right click menu of current calendar year - Replace the right click menu with a custom pop-up menu that shows all 12 months of the current year, with each month having a fly-out menu of its calendar days. Allow for the selection of a date to be entered in the active cell.

•           Create a Command Bar and switch to "Fullscreen" with opening - How can I create and view my own CommandBar when I open a Workbook? It should also be switched to "FullScreen."

•           New Menu in Tool-Menu - How can I create a new Menu with 3 MenuItems in the Tool-Menu? A Code for the calculation of square metre, outlying area and cubic metre should belong to the to the MenuItems.

•           Fit a ComboBox for the Monthsheet-select in the CommandBar - How can I use a ComboBox to choose Monthsheets in the CommandBar of the Worksheet?

•           Add a new Menu with date & time to the PopUp-Menu "Cell" - How can I add a new Menu that allows me to call the date and time to the PopUp-Menu "Cell"? The Menu should only be activated in the current Workbook.

•           Summarize item numbers on a cover sheet from other sheets. - How can I summarize duplicate item numbers that are found in several worksheets, and display it on a cover sheet?

•           Call a Pop-Up Menu to select worksheets. - How can I view a PopUp-Menu with the current selection of Worksheets when I right-click, and go to that sheet?

•           Set the last character of cell value as subscript or superscript. - How can I add menu items that set the last character of a cell to format as subscript, superscript, or normal?

•           Display a sorted list by right-clicking a given cell. - How can I sort a range and display it by right clicking a particular cell?

•           Unhide and hide the Worksheet MenuBar - How can I hide the Worksheet MenuBar by opening a Workbook and unhide it again by closing the Workbook?

•           Ascertain the calling MenuBar-Button - How can I ascertain the Button of an userdefined MenuBar which has called a Macro?

•           Calculation of the selected Area in a Statusbar - When I click with the right MouseKey on the Statusbar, I can set some Calculation-Operations in a ContextMenu. In the right of Statusbar each result is shown. Can I add CalculationOperations

•           A new Symbol in the Format-CommandBar by opening a Workbook - How can I add a new Button, which is binded to a Macro, to the Format-CommandBar when I open a certain Workbook and delete it again when I close the Workbook?

•           Find the Button-Id-Number and fit in a Button - How can I find out the Id-Number of the Goal Seek-Button and integrate this Button in my own CommandBar?

•           Confirm deletion of CommandBar at Close - Ensure a CommandBar (that is created when the workbook opens) should be deleted when you close the workbook. Answering "No" would keep the workbook open and not delete the CommandBar.

•           Deactivate the MenuItem SAVE - How can I deactivate the MenuItem "Save" in the Menu FILE?

•           List the Contextmenus and their Elements - How are all Context menus and their Elements listed in a Worksheet?

•           Test if a Menu exists - How can I check if the MenuBar of a Worksheet contains a certain Menu, and if it does, where the MenuBar is?

•           Test if a CommandBar exists - How can I test via VBA if a certain CommandBar exists when I open a Workbook?

•           Change the Value in a CommandBarComboBox - How can I add a CommandBar with a CommandBarComboBox and relate the current date as StartValue to it? Another Button should be added to the CommandBar which raises

•           Menu only visible in the Workbook belonging to it - How do I make a Menu visible only when a certain Workbook is activated?

•           Command Bar Button for the EURO-Symbol - How can I fit in a Command Bar Button for the EURO-Symbol in a CommandBar?

•           Switch on/off a Menu - How can I switch on / off the WorksheetMenu Bar in XL5/7?

•           Provide a MenuItem with a tick - How can I provide a MenuItem with a click in Excel 8? I could not find the "Checked"-Properties of Excel 5/7.

•           Fit an userdefined Command in a new CommandBar - How can I fit an userdefined Command in a new CommandBar?

•           Sort the MenuItems - How can I arrange the separate MenuItems of a userdefined Menu in alphabetical order? (in Excel 8)

•           How do I add a MenuItem to the Contextmenu in the VB-Editor - How can I add a MenuItem to the Contextmenu in the VB-Editor and assign it to an Event?

•           Hide all Menus and CommandBars - How can I hide all Menu and Command Bars, including the Application and worksheetButtons in the upper right corner of the Window?

•           Test, if a menu exists - How can I test, via VBA, if a certain Menu is already existing in a Menu Bar?

•           Inserting custom Command Bar buttons - How can I add two Command Bar buttons when a workbook is opened, and delete them when the workbook is closed? closed?

•           List all Command Bars - How can I list all Command Bars on a worksheet, with their system names and their names in the local language?

•           Delete useless CommandBars - How can I delete user defined CommandBars that I don't need?

•           Add a MenuItem to the Tool-Menu -Excel8- - How can I add a MenuItem to the Tool-Menu when a Workbook is opened and delete it again after closing the Workbook in Excel8?

•           Hide and unhide CommandBars -Excel8- - How can I hide the CommandBars and unhide userdefined ones when I open a specific Workbook in Excel8, and yet when the Workbook is closed the original settings are restored.

•           Insert a BeginGroup into the Contextmenu -Excel8- - In Excel5/7 you can insert a BeginGroup into the Contextmenu with the Caption-Properties. How can I do this in Excel8?

•           Replace the Insert-MenuItems in the PopUp-Menu "Cell" -Excel5/7- - In the PopUp-Menu, how can I replace either the "Insert" or "Paste Special" with something that only replaces the Values, not the Formats?

•           Delete and set up the PopUp-Menu "Cell" -Excel8- - How can I delete all Menu Items of the installed PopUp-Menu "Cell" and then add in my own Menu Items?

•           Determine the position of the Command Bar-Excel8 - How can I determine the position of a CommandBar with a VBA-Code in Excel8 ?

•           Create an own MenuBar with the Submenus -Excel8- - How can I create my own MenuBar with Submenus and view this instead of the CommandBar in the Worksheet in Excel8?

•           Unhide / hide CommandBars - How can I hide a CommandBar and display a userdefined Bar with the loading of a specific workbook, yet ensure that the old settings are returned when the old workbook

•           Give the CommandBarButtons names of Macros - How can I assign a Button on a userdefined Command Bar with a particular macro?

•           Change the MenuBar - How can I cut out the Worksheet Menu Bar by opening a Workbook, load a user defined menubar, and then reverse the process again by closing the Workbook in Excel 97?

•           Reverse the Menus - If I changed the Excel Menus to different items, how can I revert back to the original?

•           Statusbar text in userdefined MenuItems - How can I assign a Comment in the Statusbar to my own MenuItems?

•           Add Commands to the PopUp-Menu "Cell" in Excel8(97) - How can I add my own Commands, which are linked to Macros, to the PopUp-Menu in Excel 97?

•           Tooltip for a Self-made CommandBarButtons - How can I make tooltips for self-made CommandBarButtons?

•           Add a Command Bar Button - How can I use a Macro to add a Command Bar Button for a particular Workbook and make sure that it deletes when the Workbook is closed?

•           Save Customized CommandBar - How can I ensure that Excel loads my customized CommandBar?

•           Add Menu Items - How can I add further Menus to a Submenu using the Labels from a Worksheet. The Macros of the MenuItems should also have the same name as the Labels.

•           Menus created by sheet activation - Activating a worksheet creates its own command bar of menu items.

•           Custom menu for comment - Create a new custom item in the Insert menu, named XComment. Selecting it shall insert a comment on the active cell.

•           Custom menu - When the workbook opens, a custom menu that lists filenames shall be installed, and deleted at Close.

•           Customized right-click menu added - The right-click menu shall be customized by adding an item with two fly-outs for fast data entry.

•           Menu activated and deactivated - A standard worksheet menu item shall be activated and deactivated

•           Custom menu controls - A custom menu is created, in the form of two combo boxes that respectively list the values in column A and column B of Sheet1.

•           Custom calendar menu - Create by showing, and delete by hiding, a menu bar with drop-downs that lists the dates and days of the month belonging to the current calendar year.

•           Custom menu bar - Create a custom menu bar when the workbook opens, and delete it at close.

•           Save icon enabled / disabled - Toggle the Save icon on the command bar to be On (enabled) or Off (disabled).

•           Custom Undo button added to menu bar. - Add a custom Undo button to the menu bar, attached to a macro to undo the last action.

•           Show the Customize toolbar dialog - Show the Customize toolbar dialog using a CommandBar control statement in VBA.

•           Custom menu for comment insertion - Custom comment menu item inserts a comment into the active cell without user name, ready for text.

•           Custom right-click menu - Custom right click menu item with a fly-out of all the sheet names for sheet navigation.

•           Show the Edit Links dialog - Use a VBA command to display the Edit Links dialog.

•           Menu item is hidden and unhidden - The menu is customized by hiding and unhiding an item, using "Format" in this example.

•           Add and delete a new menu - A new menu is added as two separate command bar controls, each with a drop-down list of month names. The example simulates a choice for either reviewing or printing a report for that month.

•           Add menu item with Excel icon to right-click pop-up - Add a custom menu item to the right-click pop-up menu, with an Excel workbook FaceID icon.

•           Create new menu with drop-down items to call macros. - How can I place a new menu in the worksheet menu bar with 3 drop-down items, each of which would call their own dedicated macro?

•           Custom menu with drop-down items for macros - How can I create a custom menu on my worksheet command bar when the workbook opens, and delete it at close, which has 5 individual drop-down items, each of which calls its own macro when selected?

•           Custom command bar to open files based on worksheet table - A table displays the .exe paths for the Word, Access, and PowerPoint programs, plus file names and default paths for existing files. How can I create a custom command bar to display those files, and open one if the related menu item is selected?

Other Applications

•           Proof availability of domains on the internet - Check if the domains in Column A are still available

•           Set up files with a template and send by email - From a template 14 workbooks are to be generated and sent via email to a group of recipients

•           Use of interface operator - Determination of an interface with interface operator. Alternative determination via VBA code

•           Set up hyperlinks to web pages from cell values - Excel Hyperlinks and HTML sites are created by using the Hyperlink worksheet function.

•           Upload and download file from the FTP-server - An Excel file with a given name is to be uploaded and downloaded from a www server. After downloading, the file is to be opened.

•           Divide text file with over 65,536 rows - A text file with more than 65536 rows shall be divided into two worksheets

•           Load a graphic in the Internet Explorer - How can I load a graphic with its name in cell A1 in the Internet Explorer

•           Compare text files and document differences - Two files with the same number of digits are to be compared row by row. The row in the first file that shows differences to the respective row in the second is written to a third file

•           Read all open tasks - All opened tasks are to be integrated in a table through the Word-Tasks-Command. A link to Microsoft Word Object Library is to be established in visual basic.

•           Establish a shortcut on the desktop - A link to an application is to be made on the desktop. The Windows Scripting Host is to be installed.

•           Search for quotation on the internet and save them - How can I search for a collection of quotations of a specific author on the internet and display the result in groups by 100?

•           Search for phrase in table from Excel web archive - Value in cell A determines the archive department, on which Herbers Excel server has to search. Cell A2 contains the search phrase.

•           Retrieve internet data and show in message box - Data from the web is to be retrieved in the background, integrated in Excel and shown in a message box.

•           Load and save table content in sequential text file - How can I open and save the content of columns A:B in a text file?

•           Export print area as gif file - How can I export print areas from different worksheets as gif graphics?

•           When opening, start PowerPoint and activate workbook - When loading a workbook PowerPoint is to be started and after closing PowerPoint the workbook is to be activated.

•           Dial telephone number with double click on a cell - Dial phone number in column A with a double click on the cell. Windows control settings must be prepared

•           Send an email for a VBA error - If an error occurs during a procedure, an error message is to be sent to an email address. A link to Microsoft Outlook Object Library must be established.

•           Send e-mail with opening of workbook - When opening the workbook an email to a determined email recipient should be sent via Outlook

•           Recording Data from external Sources - How can I record data that I get from video text in intervals in Excel-Cells?

•           Several Workbooks to one recipient per Outlook - How can I send several Workbooks simultaneously to one set recipient via Outlook?

•           Retrieve the current exchange rate - How can I retrieve the current exchange rate by the Internet?

•           Read in the Outlook-Addressbook in a UserForm-ListBox - How can I read the Outlook-Addressbook in a UserForm- ListBox?

•           Send a Mail with Outlook depending on a Formula Value - How can I send info-mail using Outlook when a Cell Value, set by a formula, passes a limit?

•           Email-Distribution with Outlook on the basis of Excel-Data - I have following data in Columns in an Excel-Worksheet: Email-Addresses, Filenames, Subject, Text How can I start Outlook on the basis of this Data and send the Emails with the named enclosures and data in the relevant fields?

•           Write and save a Text in NotePad and call it in Excel - How can I call NotePad in Excel, write a Text, save it, close NotePad and load the TextFile in Excel?

•           HTML-File in Internet-Explorer with a fix height of the Box - How can I select an HTML-File and view this with a fix height of the window and without the Explorer-Menu?

•           Change the currency in the System-Control / Country settings - How can I change the currency in the System-Control in the Country settings via VBA?

•           Take Linefeeds on a *.CSV-File - How can I take forced Linefeeds of a Cell in a CSV-File?

•           Play a Midi-File when a Workbook is opened - How can I play a Midi-File whose path and name is in Cell A1 in Excel when I open a Worbook?

•           Play a Midi-File - How can I play a Midi-File whose path and name is in Cell A1 in Excel?

•           Save Texts with different DataField-Width as TextFile - How can I correct the Cellcontents and then save these depending on the Columns with different DataField-Width in a *.dat-TextFile?

•           Read in names of MP3-Files and create a Hyperlink - How can I read in MP3-Files and create a Hyperlink for a direct call?

•           Send the contents of Cell A1 with Outlook - How can I send the contents of Cell A1 to a set Email-Address via Outlook?

•           Call a Worksheet-Hyperlink via an UserForm - How can I call a Hyperlink of the active Worksheet and the File that is linked to it via an UserForm-Button?

•           Open a Word-Document, enter a Value of a Worksheet and save it - How can I open a Word document with a name written in a Cell, enter a Value of a Cell in a Chart that is contained in this Document and save the Workbook as a name that is in another Cell?

•           Read Excel-Cellcontents in a Word-document to send it via an Email - How can I fit the contents of an Excel-Worksheet in a Word-document and send it automatically via Email?

•           Add the Values of a certain weekday and a time period - How can I add all values of a certain weekday and a certain time period in a worksheet?

•           Send a Worksheet by Outlook every 30 minutes - How can I send a Worksheet automatically to a certain recipient every 30 minutes? The email should be should be sent by Outlook.

•           Specific import of Word document text - How can I transfer texts of a Word-Document into specific cells?

•           Fit the first paragraph of a Word-Document in a Worksheet. - How can I fit the first paragraph of a Word document in the active Worksheet?

•           Send an Email out of Excel without attaching a Workbook. - How can I start the Email-program out of Excel and set the Email-Address, the subject, and the text?

•           Export a chart and import it into a Worksheet. - How can I export an Excel-Chart as *.GIF-Graphics, import it into a Worksheet and delete the graphics again?

•           Store contents of workbook as text file. - How can I save a Worksheet Area as TextFile with a blank column as field separator?

•           Create TextFiles with a Progress Bar - How is the text of each Column of all Worksheets of a Workbook read in TextFiles? The TextFiles should be named according to those of the Column-Headers and a Progress Bar should be shown during creation.

•           Search for a term in a Textfile and import the line of finding - How can I search for a certain term in a Textfile and import the line in which the term of search was found in an Excel-Worksheet?

•           Send a Worksheet Area as Email - How can I send a set Area of a Worksheet via Email?

•           Write Cellcontents in conjunction with Variables in a TextFile - How can I link the Cellcontents of a set Area with a String- Variable and write it into a sequential TextFile?

•           Export in *.CSV-File with the Comma as FieldSeparator - When I save a Worksheet as CSV-File manually the Semicolon is used as FieldSeparator. How can I use the Comma without going through a detour of a sequential file?

•           Set up an HTML-File from filtered Data with Hyperlinks - How can I transfer, with the Autofilter filtered Data, a HTML-File so that the Hyperlinks are also taken over?

•           Convert only Rows with certain contents into an HTML-File - How can I convert only these Rows from a Worksheet into an HTML-File, in which a Cell contains certain contents?

•           Change the Strings into numbers after the Textimport - After the import of TextFiles from a computer to Excel part of the number is only taken over as strings, although the cells have the correct formatting. How can this be changed?

•           Call a WordMacro in Excel - How can I load Word Document and then start a Macro in the Document?

•           Print a WordDocument out of Excel - How can I print a Word Document out of Excel?

•           Export to a TextFile with fixed DataField-Width - How can I export an Excel Range to a textfile with a fixed column width for all columns?

•           Exchange a Row in an *.ini File - How can I exchange a Row in an *.ini File?

•           Call a Website by clicking an UserForm-CommandButton - How can I call a Website by clicking a CommandButton in an UserForm?

•           Pack and unpack an Excel-Workbook with WinZip - How can I unpack, open, work on, and pack again a with Winzip packed Excel-Workbook via a VBA-Code without any trace of the Excel-File being upacked afterwards?

•           Start Word with a certain Document -XL8- - How can I start Microsoft Word with a set Document in XL8?

•           Add a signature to an integrated WordPad-Object - How can I add a line for the signature in the Text of a fitted WordPad-Object? The line should either be in the object or in an Excel-Cell.

•           FileNames of a Directory as HTML-File - How can I list all files in a directory in an HTML-File and create a link to it?

•           Change the English in German Values in an imported TextFile - There are Numbers in the English Script and negative Values with an added minus in an imported TextFile. How can I convert these Values into German Values?

•           Call a Graphics Program and load a Picture - How can I call a Graphics Program by double-clicking a Cell and have it load the GraphicFile into the Cell?

•           Open a Word document in predetermined file path - How can I open a Microsoft Word document whose path and file name are coded in the macro? I do not want to open a new instance of Word if that Word document is already open.

•           Start NOTEPAD and enter the contents of Cell A1 - How can I start NOTEPAD and automatically enter the contents of Cell A1?

•           Save Variables in a temporary TextFile - I want to deposit Variables beyond the closing of the Workbook for a later call. How do I do this when I don´t want to save it in the Workbook itself?

•           Load, work on and save dBase-Files - How can I load a dBase-File via VBA, calculate certain Values and save the File again as dBase-File?

•           Link TextFiles - How can I link several TextFiles that have the names "test1.txt", "test2.txt" etc. ?

•           Web-Query without *.iqy-File - How can I start a Web-Query without creating a Query- (*.iqy-)File before?

•           Link a text file - How can I link to an external Text File, using VBA?

•           Start Word with a fixed Document - How can I start Word with a Document that is in the same directory as the active Excel workbook?

•           Automatically increment a number value - How can I call upon the number from a TextFile and automatically increase it by 1, and do so again when I call it again.

•           Read data out of the Win.ini through an API call - How can I display the desktop and wallpaper values through Win.ini?

•           Replace sequential values with existing cell contents - How can I replace several rows sequential values by existing cell contents?

•           Cell contents as Internet-Term of search -Excel8- - In Excel8, how can I call a SearchMachine via an Internet-Hyperlink to search for an active Cell?

•           Take Data specifically out of TextFiles on Cells - How can I read data from a Text File and add them in a certain cell of a worksheet, making sure that the comma is the field separator?

•           Char-map on StandBy - How can I call the Char-map out of Excel every time?

•           Absorb an Error-Message and write it in a sequential File - How can I retain Error-Messages and write the Error-Number with the Messsage in a sequential TextFile?

•           Text import with the Semicolon as a Field Separator - How can I make sure that a Field Separator is defined with a semicolon when opening a *.txt file and opening a File with a Macro?

•           Import address of found data from closed workbook - How can I open a closed workbook, search for a certain value, and record the address of that value with today's date?

•           Transfer Variables into another Module - How can I start a Power Point Presentation out of Excel?

•           Excel to HTML - How can I convert an Excel-Worksheet as fast as possible to the HTML-Format?

•           Export text to a CSV File - When I save an Excel Worksheet as a CSV File, how can I make sure that the field separator is a semicolon instead of a comma?

•           Text import from a CSV File - How can I import a Text file and ensure that a Semicolon is used as a Field separator with a Macro?

•           Open Web Pages with Excel 7/95 - In later versions of Excel, hyperlinks can be used in Worksheets. Is there a way to do this in Excel 7?

•           Access database: open and run macro - Open an Access database file and run a macro within it, then close the Access file.

•           Copy from Excel into a Word doc, print and close Word doc - The range A1:C1 is to be copied into a Word document, and the Word doc shall be printed.

•           Email text from textbox. - For each email address listed in column A, an email shall be sent. The body text of the email shall be comprised of the text in the yellow text box.

•           Word custom property - Add a custom property to a Word document.

•           PowerPoint: open, run a file, and close. - Open PowerPoint, open a slide show file, run the file, and close PowerPoint when the file is completed.

•           Outlook calendar folder - How can I create a new folder in Outlook's Calendar, populate it with a list of scheduled activities, and then extract that list from the Outlook dates into a new worksheet?

Back to top

Click Here to Order!

Printing

•           Print a table with changing header - The sheets are to be printed with changing text in header

•           Print UserForm - How can I print a UserForm?

•           Print with and without a watermark - The sheet is to be printed normally and with the watermark "Duplicate"

•           Insert of rows before and after cells in bold font - Before printing, new rows in bold font are to be inserted before the first and after the last cell. Start with normal print button or with print menu

•           Open and Save page setup and page orientation - The page orientation is to be imported and exported in a UserForm-option field

•           Add up odd and even rows - How can I add up selective all odd or even rows?

•           Use addresses and data for mail merger - Based on the data in data sheet, the respective address is being searched and entered in this sheet. Relevant, respective data is also being transferred

•           Print marked area. - The yellow marked area is to be printed. It is to be positioned as if the entire sheet were being printed.

•           Print area depending on entries in a column. - Determine print area depending on the number of entries in column B

•           Set the Print pages and the number of the prints via a UserForm - How can I set the pages that have to be printed and the number of the prints via a UserForm-Dialog?

•           Rise the Print-Zoom to the maximum - How can I rise the Print-Zoom to the maximum of a Page?

•           Print a Worksheet with the current month - How can I print the Worksheet with the current month when I press a Button?

•           Print in a UserForm-ListBox selected Worksheets - How can I print the a UserForm-ListBox via multiselect selected Worksheets?

•           Current Area in the Columns A:F as Print Area - How can I set the Area from Cell A1 till the last Cell with contents in Column F to be the Print Area?

•           Print the Header only on the first Page - How can I only print the header on the first page?

•           Print the Cell in a named Area of a Worksheet - How can I print a Cell, named Print Area, of an other Worksheet via VBA?

•           Adjust the PrintPaper Entry-Shaft - How can I adjust the entry shaft for paper of the printer via VBA?

•           Enter the Path and the Worksheetname in the Footer - How can I enter the complete Path and the current Worksheet name in the Footer automatically every time I print? Changes of the Sheet- Name and movements of the workbook into another directory should be taken into account.

•           Select the Worksheet and print the Cells in succession - The name of a Worksheet should be asked via an InputBox. In the selected Sheet the contents of a set Area should be checked and printed in lines when it isn´t empty.

•           Print Text from a UserForm-TextBox - How can I print a Text that is in a UserForm-TextBox when I press a Button?

•           Query the Printstart- and endRows via an InputBox - How can I query the Printstart- and endRows via an InputBox and view the Selected Area as Print Preview?

•           Number the Printpages of a Workbook - How can I number the single Pages of a Workbook when all Pages are printed?

•           Footer with continuous Pagenumbers through all Worksheets - How are all Worksheets of a Workbook printed with continuous Pagenumbers with the total number of Sheets in the Footer?

•           Set the PrintArea until the first zero - How can I set the PrintArea so that it covers the area of the active Worksheet only till the first zero in Column A?

•           Count up the Label in Cell A1 with each print - How is a String in the form 1999-1001 counted up with each print?

•           Open a Workbook, print the first Worksheet and close the Workbook - How can I open a Workbook via VBA, print the first Worksheet and close the Workbook again without showing it?

•           Create a print range using VLOOKUP. - How can I change between different print areas by entering a number?

•           Copy the first Print Page in a new Workbook - How can I copy exactly the first Print Page of the active Worksheet into a new Workbook?

•           Change to the Fax-Printer for printing and back again - How can I change to the Fritz-Fax-Printer for printing a Worksheet and go back to the active printer from before?

•           Print every second Column - How can I limit the printing so that only every second column is printed?

•           Print only Cells with a "2" - What do I have to do to only allow Rows that contain a 2 to be printed in Column A?

•           Enter the date in the Format DDDD, DD. MMMM YYYY in the Footer - How can I enter the current date in the Format DDDD, DD. MMMM YYYY in the Footer?

•           Take over the Header- and Footer-Settings - How can I copy the Header- and Footer-Settings of one Worksheet to a second Worksheet?

•           Set the PrintArea via VBA - How can I set the PrintArea via a VBA-Code?

•           The last date of saving in the Footer of all Worksheets - How can I enter the last date saved in the footer on all worksheets automatically?

•           Print Areas depending on the CellContents - How can I change the PrintAreas depending on the contents of a Cell? When there is written "1. Area" in Cell A1 the first, when there is written "2. Area" the

•           Distribute a TextRow to several Columns with a fixed sidelength - How can I distribute a fixed number of Rows in one Column to several Columns with a sidelength that is set?

•           Data of several Sheets to one PrintSheet - How can I Print the Data from several Worksheets on one PrintSheet?

•           Hide empty Rows with printing - How can I hide all empty Rows when printing?

•           Subtotal in Footer - How can I put the totals in the Footer?

•           Print out of a Dialogue - How can a print be started out of an active Dialogue?

•           Print the Printpage on which the Cursor is set - How is only the PrintPage set to only print the page which the Cursor is set on?

•           Determine the Pagefeed and create the carry-over - How is the Pagefeed determined in a longer List and the carry-over entered in the Cell next to the ValueCell in the last Row?

•           Print Labels for videos - How can I print Labels from out of a video-list?

•           Carry-overs with MultipagePrint - How can I create carry-overs by printing several pages?

•           Print narrow Columns side by side - Columns A and B are very narrow. How can I automate the print in so that they are printed in three columns side by side?

•           Print a multiselect on one page - Excel prints each page on a separate Sheet after a Multiselect. How can I summarize the Areas so that only one Sheet is printed?

•           Print first the Sheet on the front then on the back - How do you print all Front- and then all BackPages?

•           Calculation with carry-over - How is a multipage Results List, printed on the First-Page- and several Sequential-Pages-Calculation Forms including the calculation of carry-overs?

•           Prevent vertical Pagefeed - How can I prevent vertical Pagefeeds within a lengthy multipaging Worksheet? Whenever the Value changes in the last Column a horizontal Pagefeed should be fitted

•           Take Addresses on a serial letter - How can I take the address data from an Address-Worksheet on the Letter-Worksheet when I print batches of letters?

•           Set the FileName with print in PrintFile - When I divert a print in a PrintFile I have no way to set the FileName via VBA. Can I avoid this problem?

•           Set the PaperFormat with printing - How can I set the PaperFormat with the Print-Dialogue via VBA?

•           Suppress Rows with Empty-Strings in Formulas when it is printed - When I print a Worksheet the end of the Sheet, where only Empty-String Formulas exist, are printed too. How can I go about avoiding that?

•           Pre-determine and print Numbers - How can I pre-determine a fiveplace from/to Number Field via an Inputbox, so that the respective Number is entered in a Cell and the Worksheet is printed?

•           Change the active Printer in the UserForm - How can I change the active Printer in an UserForm-Dialog?

•           Serial Print - How can I run a serial print with AddressData from an AddressFile via VBA?

•           Print out of several Worksheets on one PrintPage - How can I (in Excel 8) put Fields from several Worksheets together on one PrintPage?

•           Do not print empty rows - How can I not print empty rows that fall within a print range?

•           Page number x of Page total y - How can I place the "Page number x of Totals Pages y" in the header?

•           Different type formatting in the Header or Footer - How can the Header or Footer be set to different type sizes?

•           File name and file path in header - How are complete File Names and File Paths displayed in the header?

•           Place a date in the format MM-DD-YYYY in the footer - How can the date be formatted as MM-DD-YYYY, and automatically inserted in the footer?

•           Exclude cells from printing - How can I exclude a range of cells from printing? The excluded range should be determined through a Dialogue Box.

•           Fit graphics to one page - How can I reduce a graphic's size so it fits to one printed page?

•           Enter the UserName in the footer. - How is the UserName entered in the footer?

•           Print all Files of a Directory - How can I print all Workbooks of a Folder, using VBA?

•           Print Worksheets in reverse order - How can I print all worksheets in their reverse order?

•           Print the Multiselection in the Vertical and Landscape Format - How can I print the first Area of a multiselection in the vertical and the second in the landscape format via VBA?

•           Determine the type size of footers using VBA - How can I determine the type size of a Footer, using VBA?

•           Enter the Footers when Opening - How do I add the Path, Page number, and User Name into the Footer of each Worksheet that I open?

•           Border Setting of the Printing Header - How can I set the left border of the right Headline using Menu FILE / PAGE SETUP?

•           Delete all Header/Footer Settings - How can I delete all the Header and Footer settings of the entire Workbook using VBA?

•           Print the Header in Book Form - In Books the Headers normally are arranged left and right so they print differently on odd and even pages. How can I apply this Layout on Excel?

•           Prevent the print of the Modules - When using Menu FILE / PRINT / ENTIRE WORKBOOK, how can I ensure that the hidden Modules aren't printed?

•           Print visible Worksheets - How can I print all selected Worksheets of a Workbook using a VBA Macro?

•           Print the Multiselect on one page. - How can I ensure that all Fields print onto one page when using Multiselect?

•           Change the Printer Settings - How can I set printing instructions with the PrinterSettings?

•           Prevent "print area" lines from appearing after print preview. - How can I prevent the dashed frames from appearing around the print area after using the Preview command?

•           Insert the number of pages - How can the number of pages in an active Workbook be displayed in a cell?

•           Several lines in Header/Footer - How can I put in 3 lines in the Header and 2 lines in the Footer using a VBA-Macro?

•           Fit to one page - How can I ensure that an imported Excel 5/7 Workbook fits on one worksheet in higher versions?

•           Print page breaks and sheet numbers - Print a range and identify its page number in column B on the first row of each page break.

•           Print row on condition of cell value - Print only those rows in a range where there is not a zero or blank (empty) cell in column C.

•           Print range start and end dates - The start and end dates of a print range shall be determined by an input box.

•           Double the distance between existing rows - Two methods to double the distance between rows - - one by temporarily added a row in between existing rows, and the other way by temporarily doubling the height of the existing rows.

•           Print only the last page - Print only the last page on a worksheet.

•           SheetChange event triggers print of range - Using the WorksheetChange event, a change to the "Number of months" value in cell B2 shall print (for this example PrintPreview) the entire updated range A1:B3.

•           Print options with check boxes - Select one of the check boxes to hide, or make visible, the headers, footers, and page text.

•           Conditional print - Print a sheet only if it has the string "Sheet" in its tab name.

•           Print a series of dated certificates - A series of certificates shall be printed, each with its own incremented number.

•           File properties of Author and Title are placed in sheet header for printing - The file properties of Author and Title are placed in the top left header for printing, each on its own line in the header as by a carriage return.

•           Page breaks at change of values - Page breaks are set based on a change of values in column A.

•           Identify range of first printable page - Identify the range of cells that make up the first printed page of a worksheet, starting from cell A1 to the point where the first horizontal page break would be.

•           Border outlines for printing, based on page breaks - A temporary border outline is placed around the print range, which takes into account the page breaks, so each printed page has a border outline neatly around its data range.

•           Print only record selected by ComboBox - I have an embedded ComboBox that is populated with items whose values are listed in column A of a table. How can I print only the record (row) of that table whose value in column A matches the item selected in the ComboBox?

•           Print date values based on criteria - How can I print a set of records containing dates that are defined in a criteria cell?

User Defined Functions

•           Determine most used grade from list of grades. - Determine most used grade from list of grades.

•           Calculate surcharges according to a sheet - Surcharges are to be calculated with a given surcharge sheet.

•           Validation by proof-number - The proof-number in column a is to be proofed. Proof as formula and as VBA-macro.

•           Search for phrase and display row/column of found phrase. - A search phrase is to be searched in a multi column sheet and the index of the found place to be displayed as result.

•           Add up the ten highest values of a number sequence - The ten highest values of a number sequence are to be summed up.

•           Count number of numbers in a formula - In cell B2, the number of numbers in the formula in A1 is to be counted.

•           Determine the first value of a filtered column - The first viewable value in a filtered column is to be displayed. The column is being determined as a parameter.

•           Determination of respective shift - A shift is to be determined with various criteria.

•           Text in formula and formula in text. - A text from cell A1 is to be changed to a formula and the formula in A2 to be changed to text.

•           Filter values from digit strings and calculate - Values are to be filtered out of digit sequences and to be calculated.

•           Determine online-cost with start and end time - Online costs are to be calculated with data from row 2. The weekend rate is the half of the online rate.

•           Multiplication dependent on font color - The values from column A are to be multiplied with a factor based on the font color

•           usage of VLOOKUP with several criteria - A formula shall consider several search criteria and deliver the first found value.

•           Detecting a VANITY number - Alphanumerical telephone numbers are available through letter/number combinations on phone keyboards. How can I determine a vanity number with a sequence of digits?

•           Sum IfSum additions over several worksheets - The total of all values for column D of all following worksheets is to be displayed in D1, if the date area of the sheet is within the date area of cells B1:B2 of sheet1.

•           Calculation of maximal temperature with specific date. - A maximum temperature shall be calculated for a specific date

•           Complete sequence of digits - Number from cell A2 shall be searched in Sheet1. If a match is found, it and any other values in the cell are to be returned prefixed by "Number"

•           Determine first and last cell of a filter - A user defined function shall determine the first and the last unhidden row in a filtered table. The second parameter stands for first or last row.

•           SUMIF-function over several worksheets - Can't use function SUMIF in 3D areas. How can I solve this problem?

•           Compare prices - Compare prices by various criteria and modes.

•           Ascertain the Number of a Symbol in a Selected Area - How can I ascertain the number of a certain symbol or a string as well in a selected area?

•           Determination of the first day of a week with DIN 1355 - How can I determine the first day of any calendar-week in any year?

•           Divide Strings in numerals and letters - How can I divide a String like "12AB3C45D" in the number 12345 and the String "ABCD" ?

•           Convert 5-Length-String into time with the format mss,00 - How can I convert a String like "21307" into a time with the format m:ss,00 (2:13,07)? Further calculations with this time should be possible.

•           Sum only visible Cells - How can I only sum the visible Cells of a set Area?

•           Allocate a Formula Area in its single Elements - How can I allocate a Formula like =SUM(A1:A3) in its single Elements so =SUM(A1+A2+A3)?

•           Calculate the Timedifference in SchoolHours (45 minutes) - How can I calculate the difference between a Start- and Endtime in SchoolHours, 45-minutes?

•           Check, if it is a Integer-Value - Using a userdefined function, how can I check if the Input-Value is an Integer-Value?

•           Ascertain the Sum of all italic written Values - How can I ascertain the Sum of all italic written Values in a Selected Area?

•           Ascertain the number of a name in a certain ScriptColor - How can I ascertain all names "Meier" whose ScriptColor is red in a Worksheet?

•           VLOOKUP-Formula through several places of found - How can I summarize several places of a found String by a VLOOKUP-Function?

•           Sumproduct over several worksheets. - How can I use the SUMPRODUCT Function in a non active worksheet?

•           Test the truth of a cell value made with a formula. - How can I test a result of cell values made from a Formula that is in a Cell? There is a "3" in Cell A1, a "+" in Cell B1, a "5" in Cell C1, a "=" in Cell D1 and an "8" in E1.

•           Display the workbook title using a user defined function. - How can I view the title of the active Workbook through a userdefined Function?

•           Sum the values of different colored cells. - How can I add the values in a given colored cell by using a sum formula in a cell with the same color?

•           Count the number of Cells with a certain interior color. - How can I determine the number of cells with a certain interior color?

•           Add the Values of a day from month sheets - How can I add all values to a definite Weekday from a List of 12 month sheets?

•           Change a Text String into a Formula that can be calculated - How can I calculate a Text existing Formula through an userdefined Function?

•           Number of a Value considering the capitalization and lower case. - How can I ascertain how often a certain String is found in a set Field? Capitalization and lower case should be considered.

•           Add all Values of a Weekday from the month sheets - I have 12 month sheets in a Workbook. The date is entered in Column A, the Weekday in Column B and the Value belonging to it in Column C. How can I view the value of all Mondays of a month in an analysis sheet?

•           Compare Fields on matching - How can I ascertain if two Fields have identical Values?

•           Sum of all Costs of one Cost sort in one quarter - How can I ascertain the Sum of all costs of a certain cost sort in a set quarter?

•           Ascertain the months of a set period - How can I ascertain the number of months of a set period?

•           Background Color and Text conditioned Number - How can I calculate the number of all Cells that are formatted with a certain Interior Color and that contains a certain Text?

•           Enter the name of the Author in the Document - How is the Author name of the Workbook entered into a Worksheet of the current Workbook?

•           Enter the Name of the Worksheet in a Cell - How is the Name of the respective Worksheet entered in a Cell?

•           Round CellInputs automatically to full 1.2-parts - How can cell inputs be rounded automatically to multiple of 1.2? (i.e. 1.1 should become 1.2, 3.1 should become 3.6)

•           Sum Cells according to the ScriptColor - How can I sum a Field according to the Cell interior Colors?

•           Function for the return of a position in a Sport-Table - How can I ascertain the topical position of a team in a Sport-Table?

•           Ascertain the Header with the Function LARGE() - How can I select the Header that is order of rank ascertained from the function LARGE()?

•           Determination of distances via an userdefined Function - How can I determine the distance of 2 Places via an userdefined Function when a Distance-Table is in a second Worksheet?

•           Divide phone numbers into area dialling code and connection - How can I divide phone numbers into area code and connection? The numbers exist in the Formats (02683)949049, 02683/949049 and 02683-949049.

•           Numeral in English - How can I view a Number in words in the English language ?

•           Value from Column C when the Columns A and B meet a condition - I need a Formula that returns the contents of Column C that correspond with specified criteria for values in Column A and Column B appearing in the same row.

•           Last value in last column - How can I determine the value of the last row of the right-most column, via a User Defined Function?

•           Enter the UserName in the Worksheet - How can write a formula to return the user name in a cell?

•           Search for a Symbol in a Formula - How can I determine if a character, such as a column letter or a value integer, is included in a formula?

•           User Defined Function for VLOOKUP - How can I get a User Defined Function to perform a VLOOKUP in non-contiguous LOOKUP ranges?

•           Addition of total number values, whether positive or negative - I have a list of positive and negative numbers and I want to add the total values as if they were all positive.

•           Fit in a Blank after each 5. Symbol - How is a Blank fitted after each 5. Symbol of a string, via VBA?

•           Number of the via ParamArray determined Parameter - How can I determine the Number of the via in a user defined Function via "ParamArray" transferred Arguments?

•           Access on closed Workbooks - How can I avoid not being able to access a closed Workbook with VBA or the Excel-Function INDIRECT()?

•           Continuous Order of Rank - When there are some equal Ranks in Excel, the Excel-RANK()-Function does not continuously fill the following positions. Example: 2 first Places then follows the 3 place.

•           If "bold" then add - How can I add the Values of all of the Cells that are formatted as bold?

•           Count the number of times a character exists in a cell. - How can I determine the frequency of certain characters in a cell?

•           Working days including Saturdays - There is the Formula =NETWORKDAYS() in the AnalysisFunctions. Here holidays, Saturdays und Sundays are not calculated. I need a Function which does the same, but also includes Saturdays.

•           Reverse a String - How can I reverse a String, for example, turn "MrExcel" into "lecxErM"?

•           Difference of Dates in the form"12 Years, 3 Months, 4 Days" - How can I determine the difference of dates in the form of "12 years, 3 months, 4 days?"

•           Ascertain the Column Headings of Cells with the highest Value. - How do I ascertain the Header of the Cell with the highest Value in a matrix?

•           How many weeks are in a month? - I want to determine the number of weeks in a given month. However, if a month begins with a day later than Wednesday, I want it to count in the previous month.

•           Filter a Number out of a String - How can I filter out a number from a String?

•           Working hours in a set period. - How can I determine the Working hours in a set period, including Start, End, and Break Times?

•           Function =COUNTA() without Columns that are hidden - How can I use the Excel Function =COUNTA() without counting the Columns that are hidden?

•           Conditional Mean Value - How can I calculate the average of numbers on a worksheet within an upper and lower bound?

•           Calculate the sum of the digits - How can I add the digits of a number? As in 123 = 6.

•           Calculation of time in the pension scheme - In the pension scheme the days for a partial month are calculated till the end of a month, full months count as 30 days. The Excel Function =DAYS360() from the Analysis ToolPak doesn´t solve the problem.

•           Calender week according to ISO Regulations - The Excel-Function =CW() doesn´t give the week according to ISO regulations. How will it be calculated?

•           Counting columns that contain Sequenced numbers - Is there a way to find out how many Columns contain a certain sequence of numbers?

•           Get name of the previously active worksheet - How can I determine the name of the previously active Worksheet?

•           Change Numbers into Text - How can I change Numbers into text strings?

•           Enter the name of a Worksheet into a Cell - How can I show the name of the active Worksheet in a Cell?

•           Last Value in a Row - How do I determine the last value of a Row?

•           Subtotal as text - How can I Subtotal a list of Numbers and Strings with the help of a Function, but without including the Subtotals in the Total.

•           Average Values excluding Zeroes - How do I get the average of a list of numbers, while excluding the zeros?

•           View values and formulas - If I have a cell with a formula, how do I view the formula in another cell? (formula: "=8*9+26")

•           Identify maximum value in a list of weekends and holidays. - Return the maximum value associated with a weekend or holiday in a general column of dates.

•           UDF for NetWorkDays - Reproduce the NetWorkDays worksheet function as a UDF.

•           Separate address by street and number - The street and house number of an address are separated by individual user defined functions.

•           Alternative to the DEC2BIN function's max limit of 512. - The DEC2BIN function has a maximum limit of 512 as a value to convert to binary. This UDF by Rob Bovey shows how to exceed the 512 limitation, without a need for the Analysis ToolPak to be installed.

•           Count colored cells - All cells with a certain background colour and with contents are to be counted. See formula in cell D1 of Sheet1. The first argument is the range of interest; the second the argument is the color index number.

•           UDF returns maximum date's neighboring cell value. - A User Defined Function returns the value of the cell to the right of the one with the highest date on Sheet2.

•           Formula displayed as text - Formulas are to be displayed employing a User Defined Function.

•           Count cells within formatted border - With a User Defined Function, count the number of cells within a format-bordered area.

•           UDF returns filter criteria - The UDF in cell H1 of Sheet1 returns the numeric criteria used for filtering column A.

•           UDF with 3 criteria - A User Defined Function shall consider 3 criteria, and count the number of times those 3 criteria are simultaneously met.

•           User defined function for conditional formatting - When the Conditional formatting criteria is met in cell A1 of sheet1, the value of that cell shall be displayed in cell B1 of Sheet2, which houses a user defined function formula for that purpose.

•           Sum values across sheets - The monthly worksheets are to be summed for cell A1 according to the names of the month from the dates entered in A2 and B2.

•           UDF add to Function wizard - A userform shall provide two options for user defined functions that can appear in the Insert Functions dialog, and can be entered by the Function wizard.

•           Compare a match in cell values among two ranges - A User Defined Function examines whether all values in range A are present in range B.

•           Hyperlink properties - With a user defined function, determine text, address and subaddress of a hyperlink.

•           User-defined function as array formula - Calculate measurements in a range by a macro that enters an array formula.

•           Cost of item with or without value tax - A UDF with a Boolean argument considers the base cost of an item, with or without a value added tax.

•           Elapsed time broken down in hourly segments. - User Defined Function breaks down the quantity of elapsed hours ("Start data and time" minus "End date and time") by segments of the 24-hour day.

•           Sum values by currency - The values in column A are summed by their currencies.

•           Sum numbers based on font color - The numbers in a range are summed by their font color index.

•           Matching address fields return corresponding City name - A UDF shall determine the presence of a record on a second sheet based on two field elements. If the record exists, the third field element shall be returned.

•           Dynamic used range defined by UDFs with Conditional Formatting - UDFs with Conditional Formatting dynamically mark the bottom edge of the used range.

•           Count visible cells - Count visible cells in a range with a User Defined Function

•           Minimum time value from table for each athlete in a given event - Return the minimum time for an athlete's name in column A and event in column B, considering all the times in column C for that athlete and that event.

•           Contiguous text string parsed into set intervals separated by a space - Two UDFs each parse a contiguous text string into blocks of four characters separated by a space. The cells containing the UDFs are each linked to an embedded TextBox which show the parsed value.

•           UDF returns Contacts folder information from Outlook - For users with Outlook as their email client, a UDF returns a Contact person's Title and Body text.

•           UDF returns Windows path using Environ method - The user defined functions in cells B1 and B2 return the Windows directory and path using the 27th expression of the Environ method.

•           Determine last file saved - The user definded function compares two files listed in B1:B2 and returns the one that was saved last.

•           Search criteria for associated value - UDF searches column A and returns the criteria's corresponding value (if there is one) from column B.

•           Subtotals by currency type and date criteria - How can I devise a formula to return the individual numeric sums of various currencies from a list of numeric values, while also considering date-related criteria?

•           Sheet index of match value converted to letter - How can I determine the index sheet number of a value in a table, and convert that number into a letter reference?

•           UDF's outcomes depend on specified parameters - Please explain to me how a user defined function works, in terms of an example UDF with four parameters, and how the result that the UDF returns will depend on which parameters I specify.

•           UDF returns one of multiple field headers - How can I devise a user defined function to return one of four Zone field header values, based on which Zone a particular telephone number falls in?

•           Median of visible cell values only - How can I devise a formula that will return the median value of only the visible (unhidden) numbers?

•           Nested string returns lookup value - What user defined function can I devise that will look for a substring in a longer text string value in a given cell, and return the corresponding value from a lookup table on another sheet?

•           UDF with Conditional Formatting - How can I use a UDF in Conditional Formatting to identify cells that contain formulas?

•           Row height - Employ a User Defined Function to return the row's height.

•           Directory and path of workbook - How can I compose a formula to return the directory and path of this workbook?

•           Maximum date - I have rows of data on my sheet that contain dates, text, and numbers. What UDF can I devise to tell me the latest (maximum) date found in a given row?

VBE - VB-Editor

•           Add a new worksheet and transfer class module code - A new worksheet is to be added to the workbook, which a code in the class module from sheet 1

•           Delete a code from a class and a standard module - The code from all worksheet class modules in the active workbook and from module 2 shall be deleted.

•           Add UserForm button during running time - During run time, a button with an event code is to be added to a UserForm

•           Insert code in VBA module - The code from a worksheet is to be inserted in a specific workbook in an unknown folder location

•           New Button with the Code belonging to it in a Worksheet - How is a new Button with the Code belonging to it fitted in a new Worksheet? After pressing this Button it should be deleted including the Code.

•           Read out VBE-Components of the active Workbook - How can I read out the VBE-Components of the active Workbook and enter it into the active Worksheet?

•           Create a new Class - How can I create a new Class for an Event?

•           Take the Cellcontents on the Procedure during the running time - How can I use the Cellcontents in the Procedure during the running time so that they are used?

•           Change the Outlook-References according to the Excel-Version - How can I set the reference to the Outlook Object Library according to the Excel-Version?

•           Create a CommandBar depending on the existing Macros - How can I create a CommandBar for all Macros that exist in a certain Module automatically when I open a Workbook?

•           Move the Cursor two Cells down after an Input - How can I determine that the Cursor is moved two Cells down after a CellInput? This shouldn´t be done with the Select-Command.

•           Add factors during the running time - How can I fit set Values into an UserForm-TextBox during the running time, complete a userdefined function on the basis of these Values and add it?

•           Replace a Line in a Code-Module - How can I replace a Line in a Code-Module during the running time?

•           Delete the active Module during the running time - How can I delete the Module with the active Macro during the running time?

•           Take the name of the called Macro from the Cell during the running time - How can I link to a Macro, named as the same value in Cell A1, during the running time?

•           Read out the CursorPosition in the VB-Editor - How can I list the the current cursor position in the VB-Editor?

•           Set a Password for a VBE-Project with VBA-Code - How can I relate a password to a VBE-Project via a VBA-Code?

•           Create and delete a userdefined Function via VBA Code - How can I create, call and delete again - with the Call - a userdefined Function via a VBA-Code?

•           Set the VBA-Names of the Modules with the copying last Worksheet. - When I copy each last Worksheet of a Workbook 50 times, in the VBA-ProjectExplorer a 1 is always added to the name of the ClassModule of each copied Sheet till the

•           Delete the WorksheetCode after copying the Sheet - When I copy a Worksheet as a new Workbook the ClassModule of the Sheet is copied, too. This cannot be deleted. How can I delete the Code in this Module via VBA

•           Unhide and hide the VB-Editor - How can I unhide and hide the VB-Editor?

•           List all macro procedures and functions - How can I display all macro procedures and User Defined Functions of a Workbook?

•           Delete VBE-References -XL8- - How can I delete a VB Project reference to another workbook?

•           Make a Reference to a *.DLL via VBA -Excel8- - How can I make a Reference to mso97.dll via VBA in Excel8?

•           Print the CodePage with Margins -Excel8- - In Excel8 I can't set the Margins when I print the Module, they end up on the extreme upper left. How can avoid this?

•           Delete the Module in a second Workbook -Excel8- - How can I delete a VBA-Module of a second Workbook in Excel8 via VBA-Code?

•           Create a Workbook and write a Workbook_Open-Procedure -Excel8- - How can I create a Workbook in the ClassModule of the Workbook via VBE-Code and write a Workbook_Open-Procedure in Excel8?

•           Create a Excel5/7-Workbook and write an auto_open-Procedure -XL8- - How can I create an Excel5/7-Workbook in Excel8 with VBA-Code, write an auto_open-Macro for it then save and close the Workbook in Excel5/7 Format?

•           Transfer Variables into another Module - How can I transfer Variables out of a Worksheet-ClassModule into a general Module?

•           Change the Worksheet Names of the VBA-Projects (XL8) - When I copy a Worksheet with the Name "Worksheet1," that very name is created in the Project Explorer, How can I change this with a VB Macro?

•           Exchange Modules and UserForms (XL8) - How can I delete all Modules and UserForms of a Workbook and then load the Modules and UserForms of the topical SubDirectory?

•           Copy Modules from Workbook to Workbook - How can I copy Modules from one Workbook to another and then go on to name the new Sheet?

•           Export of Modules and UserForms in Excel97 - How can I copy all the Modules and Userforms from one Workbook to another using VBA?

•           Tab between text boxes grouped into a class module. - Tab from one text box to another on Sheet2. The text boxes are grouped into a class module.

DAO-ADO

•           Retrieving data from a CSV file by using ADO connection. - How can I retrieve/query data from a CSV file by using Data Objects.

•           Creating a new Access Database in code. - How can I create a new database file and table in this database then add data into this new table.

•           Accessing MYSQL Database on Web. - How can retrieve data from MYSQL Database resides on my web server.

•           Opening Excel Worksheet as data source by using DAO. - How can I access Excel worksheet data without opening it in Excel.