Subcategoreis
Excel 2003 Functions and Formula General Formatting Getting Started
The rest of this tutorial takes you through the three most common control types supported by the Ribbon interface: buttons, menus, and split buttons. You'll learn the RibbonX XML code required to add and configure each control. Read more...
This tutorial presents some techniques for making your macros more accessible. Learn how to enable your users to use familiar tools-namely, the Office 2007 Ribbon and its tabs, groups, and various buttons to run your macros. Read more...
By default, Excel VBA code is case sensitive and uses what is known as binary comparisons. This means that it sees Cat and cat as two different words. Read more...
Use a custom function to display the criteria used for any column in a table with an AutoFilter applied. Excel's AutoFilter is one of its most useful features, but one small drawback is... Read more...
Restrict all future entries in a spreadsheet or range of cells to uppercase or proper case only. Read more...
When using a built-in Excel function is impractical, you can use a custom macro to change any existing text to uppercase or proper case. Read more...
Attach a custom toolbar to your spreadsheet that doesn't get in the way of the end user's settings for other spreadsheets when yours is closed. Read more...
Change absolute formula references to relative references, vice versa, or a mix of absolute and relative columns and rows. Read more...
To overcome the limitations of the Track Changes feature, you can employ some help from Excel VBA and Excel's Change Events feature. Read more...
Keep prying eyes from viewing a worksheet, unless they have the password. Read more...
One of the most commonly used functions in Excel, sorting is usually performed on a list, table, or range of cells, but you can take things a step further and sort your worksheets as well. Read more...
It's quite common for Excel users to want to save an Excel file with a filename that corresponds to the text in a worksheet cell. This can be done with the help of a small amount of code inserted into a module. Read more...
Enhance Excel's Find feature to search for the first occurrence of a number that falls between two specified numbers. Read more...
Use a bit of Excel VBA macro code to create a list of hyperlinked Excel workbook names on any Excel worksheet. Read more...
Enter a static date, or date and time, into a corresponding cell after data is entered into other cells. Read more...
