I have designed some Microsoft Excel solutions that have helped other people and have posted them here. This is not a tutorial but many of the following Excel links are helpful hints. A ReadMe is provided in each worksheet. I have written a brief description below, next to each Excel link. Please enable Macros as there are no V.B.A macros that will change your settings. Click the link and the file will download into a blank window. To view the VBA you will have to "save target as" onto your hard drive or a floppy disk.

If you have a problem that needs solving, write to me and I will try to solve it. Go back to the Main Index for address details - scroll down a page or two.

Secrets Page For some helpful hints.

Multi-Tasking Text Utility Size= kb

Text Box makerSize= kb This routine will create a text box around the cell or selection.

invites.xls Size= kb An invite using a textbox overlaying a picture. Not crash hot but it was interesting to do.

horoscope.xls Size= kb This program is the Zodiac and Chinese Horoscope. All the answers are based on the date you input. The program is complete; it's just all the information is not there yet. It takes a lot of info...maybe I have to many criterials...hmmm.

benefits.xls Select your health plan - Gold, Silver, Bronze. There are 12 plans to choose from.

AddForm.xls Size= kb Dialog box for Name/address/details.

logbook.xls This routine is useful if you loan or book out products or property or files. On return, you can select from any of the five list box selections as to how you want to find the property. The date & time sent/received is logged. Also how long the item was out.

Find_Len.xls Size= kb This macro will look for matches with the date as first priority then the initials (name of teacher),secondly. The idea being that a teacher may be required to teach at two locations on the same day either at different times or at the same time. This routine will search for a match from "START HERE" sheet column B, with Sheet1, column D. Then it will check for a match in the row below, and if true, copy it to "Match_Report" sheet. There are options first to sort the sheet. This routine is quite impressive in respect that some names are mixed with others. The names are initials eg: FP, Don. When mixed, they look like this: FP/Don, GP/Don/FP. The routine will find FP regardless of it placement.

Bookings.xls Size= kb This one is hard to explain and the readme will not help much. It is a matter of try and see. Basically, press the BoxMe button. Scroll through the names (use your own names) and select one. In the edit boxes, type in how many tickets are wanted, what table you want to sit at (if preferred) OR if you want to sit with someone else. You must press Update sheet button. If you enter the details directly onto the sheet, you do not need to update sheet. For more instructions, see file or contact me direct. See the Table Sheet sheet for the end results.

Auto_Tracker A README is provided in the worksheet. Briefly, this macro auto tracks given information entered into a cell. On entry of criterium, all relevant info is copied from one sheet to current sheet.

List Box Select from the list box then enter a quantity into the inputbox.

Utility Size= kb A utility where you can select both row and column from the given data. You can then increment the selected cel, either up one or down one, from the utility. When you exit, you are at that cell.

Validation The cell will only accept a number between 1 and 10.

AutoChart Size= kb Creates a chart with any given data.

TimeClock Size= kb Clock in, clock out. The result is xx Hours and xx Minutes.

Computer Docket Size= kb This program is basically self-explanatory when viewed. Basically, it is like a computerised docket. You select the product the customer has chosen, then pres ok. It transfers the data to a sales docket.