Daily posts of Excel tips…and other stuff
Archive for the ‘User Interface’ Category.
Sometime in the mid-1990s, a man named Lyle Lanley walked into Microsoft with an idea. Probably the greatest.... Oh, it's more of an Apple idea. "Just tell us the idea and we'll implement it", said Bill Gates.
I'm on a quest to rid my life of wizards. The wizards that Microsoft seems [...]
This is one of two approaches inspired by Dick Kusleika's post on opening in Excel the newest CSV file in a given folder (http://www.dailydoseofexcel.com/archives/2009/05/01/opening-the-newest-file-in-a-folder-with-vba/).
I explain the development of the Excel 2007 add-in at http://www.tushar-mehta.com/publish_train/xl_vba_cases/LINQ_newest_file.htm. The key issues addressed are the use of LINQ to query the file directory to find the newest file and [...]
To account for freight on incoming inventory, I allocate the freight charges proportionately over the inventory items by total value. Quickbooks doesn't have a way to handle that, so I use a simple Excel spreadsheet to do the calculation.
The last entry is always the freight (or handling or whatever I want to distribute). [...]
Hi everyone,
With all these Euler posts I thought, why not post my own?
Suppose the following:
I have a products table set up like this:
Code ProdName Price
0001 Product1 556.68
0002 Product2 977.41
0003 Product3 350.62
0004 Product4 509.16
0005 Product5 748.4
0006 Product6 802.96
(list goes on to as much as 5000 products)
And I want to show this table in a userform and give the user some filtering possibilities (lets say on the first two [...]
Hi all,
I've just published a new article on my website. Here is the introduction:
"This article explains how you can use styles to ease maintenance of your spreadsheet models.
Microsoft has made it very easy to dress up your worksheets with all sorts of fill patterns, borders and other frills. Because formatting of cells is often done [...]
I don't use user defined functions in add-ins all that often, but I happen to have a particular add-in with one UDF. And I happened to have recently moved that add-in. And all my links happen to be broken.
Fortunately, Jan Karel has an exhaustive write-up on how to fix and prevent this problem. [...]
It's college football bowl season once again. I have a spreadsheet I use to help me identify winners and losers (for entertainment purposes only).
The four yardage columns are yards per game for rushing offense, rushing defense, passing offense, and passing defense, respectively. I'm trying to identify teams that have better defenses (because defense [...]
I need a quick way to create a filter by month on an autofiltered range. Right now I'm manually entering this:
That's tedious. One option is to create another column with just the month and year in it and filter on that, but I don't like my data cluttered. So I wrote this [...]
