The utilities expressed here are for demonstration purposes only. They have not be created for professional purposes. They are my creations which I like to show to other people. You may view the utility but copyright is pending.
Files are listed alphabetically but in no particular order.
disclaimer
Add this site to your Favourites folder. |
| Addled.xls Increments the selected number either up or down. |
|
| addsheets.xls You can insert sheets, remove sheets or rename sheets.
|
|
| AutoChartPic.xls You can change the entries to suit. The resulting
Chart will use the embedded forklift picture as images in the chart.
|
|
| AutoChartPic97.xls The color bars are hidden behind the info label that make up
the bars for the chart.
|
|
| cellreport.xls The Message Box result displays a report of the status of any selected cell. The routine is not specific to any sheet or workbook. Details are: 1. font color, 2. fill color, 3. font name, 4. font size, 5. formula, 6. value or text.
|
|
|
colorsindex.xls The results show the fill interior color index number and the font color index number. Handy if you do not remember what color you have just used.
|
|
|
colorsRGB.xls Type in a number between 0 and 255 in each cell - A1, B1, and C1. Type in a number between 1 and 18 in D1 - this is the pattern number for the shape object. The onaction result is the shape will change pattern and color to your numbers selected.
|
|
| DateRow.xls Inserts the date you specify by typing into the input box, the month number, into row 1 starting at cell B1 to the end of that month in format dd m yyyy. Accounts for leap year as well.
|
|
| Datumator.xls Inputs the date format dd mm yyyy in bold across row 1 at B1 to the end of that month. Following this, a Userform appears allowing the user to input data into any cell specified by selecting a data row from listbox1 and a date from listbox2. The intersection of these two points is the users selection. Press "View Selected Cell" Button to Enable the "Add New Data" Button. When the new data has been added, press "View Selected Cell" Button again to ensure the new data has been added to the cell.
|
|
| InReMo.xls This is similar to addsheets.xls but has presets for naming sheets. You can insert sheets, remove sheets or rename sheets. There are some presets for sheet names: Monday to Friday, Monday to Saturday, Monday to Sunday, January To December, dd-mmm-yyy plus one day, dd-mm-yy plus 7 days, yyyy plus one. |
|
| listboxlist1.xls Userform with a listbox that will list the contents on the worksheet. |
|
listboxlist2.xls Userform with a listbox. Click on an entry then click a button to copy that selection to the edit box. Four selections can be done.
Show an image of listboxlist2 in a new window. |
|
listboxviewer.xls Click on an entry. This entry will copy all entries up to 7 columns wide on that row
into edit boxes named with the column titles. This selection can then be copied to a seperate sheet using
the " Copy Selections to OutPut Sheet " button. Click on a Label to fill the listbox with that column.
Show an image of listboxviewer1 in a new window.
Listboxviewer2.gif shows the results after you have clicked on " Stock List " button.
If there are no titles in any columns, they will not show on the labels.
If any entry on a row is empty, the textbox will read ---- Empty ----
As the textboxes are not enabled, you can change this to enabled. Doing so will enable you to add or change the input text as this text is written to the output sheet.
Show an image of listboxviewer2 in a new window. |
|
randomnumbers.xls Random numbers are generated at the insertion point, 5 rows x 5 columns. The numbers range between 0 and 999. Press the Button again to generate another set of numbers. The insertion point can be anywhere on the page.
A tool bar button applies to this utility. see disclaimer (below)on how to remove it if necessary.
|
|
RandomGenerator.xls This is a random number generator Utility. It has six preset options or the user can specify the random mix start number and end number. The user can either accept the cerrent selected cell shown in the utility or specify an insertion point.
The utility also has a "preferences to format" utility attached. The preferences are limited but worth looking at. As the selected range is not unselected when the utility closes, the user can format the range using Excels' buit-in formats.
A tool bar button applies to this utility. see disclaimer (below)on how to remove it if necessary.
|
|
rowmultiples.xlsThis utility will add any multiple entries to a single entry. It is limited to three columns wide with the first entry (or column of entries) as the source. The other two columns are the figures.
Example: the entry column A is the source of information. Numbers in columns B and C will add if there are multiple entries of the data in column A. There is sample data in the sheet to try. It has error-handling if the entries are not numbers ( is text!).
|
|
 Stamplist.xls This utility sorts multiple entries of multiple stock numbers into 8 columns wide. a new line appears when the entry appears more than 8 times.
|
|
| secretsamples.htm This page contains my secret codes for
special vba tricks. |
© Mark E. Philpot of Windsor Victoria Australia August 2002
Disclaimer:
No responsibility will be taken.
. If a file is going to make changes that affects your workbook setup, it will be noted here and in the file. Some files may include a Toolbar Button. This can be removed by deleting it from the Tool Box: right-click on any tool bar then highlight the tool name, then press the delete button. You cannot delete built-in tools by mistake, only the ones you create or an outside source creates...
modified: Friday, 1st August 2003
modified: Monday, 23rd August 2004
Counter at 1684 - 12 Nov 2004
Counter at 2197 - 12 April 2005