-
As some of you may know, I’m Dutch and live in “The Kingdom Of The Netherlands”. Well, tomorrow is an important day for the Dutch people: Queen’s Day. More so, tomorrow is an extra special day. Not because our Queen abdicates to make room for King Willem-Alexander, but because...
-
Date functions in Excel make it is possible to perform date calculations, like addition or subtraction, resulting in automated or semi-automated worksheets. When you mix date functions with conditional formatting, you can create spreadsheets that display date alerts automatically when a deadline is near...
Posted to
The Excel Team Blog
by
Excel Blog
on
Thu, Apr 4 2013
Filed under:
Filed under: Conditional Formatting, MVP, Excel, Excel 2013, Excel Web App, COUNTIF, formula, calendar, schedule, tutorial, date
-
Hi all, Some of you will be aware of my “killer” product called RefTreeAnalyser. It is a tool which makes it easier to navigate the precedents and dependents of a cell. Let me tell you the tale of how this tool has gone full circle. The original tool was written in VBA. I decided I [...]...
-
Hi everyone, Some time ago I announced I was working on “An MSForms Treeview” replacing the Common Controls Treeview with an all-VBA counterpart. This home-made treeview control will work on any Office version as of Office 2000, including 32 and 64 bit Office. I expect it will even work on...
Posted to
Daily Dose of Excel
by
Daily Dose of Excel
on
Fri, Feb 22 2013
Filed under:
Filed under: Classes, VBA Advanced, Collections, VBA, MVP, Events, Downloads, User Interface, ActiveX Controls, UI Design, Excel Advanced
-
If you have ever used the Treeview control from the “Additional controls” section, then you know what a versatile control this is to show hierarchically organized data. There are a couple of problems with this Treeview control: Compile errors due to a difference in how the control libraries...
Posted to
Daily Dose of Excel
by
Daily Dose of Excel
on
Thu, Jan 31 2013
Filed under:
Filed under: Classes, VBA Advanced, Collections, VBA, MVP, Events, Visual Basic Editor, Windows API, Userforms and Controls, ActiveX Controls, Controls, UI Design, Excel Advanced
-
Hi Everyone, With Excel 2013 we also got new document windowing in Excel; Microsoft decided to make Excel behave the same as Word: from MDI: to SDI: This causes havoc when one shows a modeless userform which should stay on top of all Excel windows: I’ve devised a way to prevent this problem and...
-
Have you ever experienced the dreaded “Circular reference warning” popping up when you opened an Excel file or entered a formula? Excel detects a circular reference when a chain of calculations visits the same cell more than once. Many users … Continue reading → Read More...
-
If you need a way to create invoices in Excel, feel free to use one of the many invoice templates on Office.com. While these templates are a great starting point, they won't automatically generate unique invoice numbers for you—you need a macro for that. Fortunately, Excel MVP Bill Jelen created...
-
Suppose you want to send someone a demo workbook, but you don’t want that workbook to be used more than a certain number of times, perhaps because you want to be paid for your work. In today's VBA tip, Excel MVP Bob Umlas shows you how to limit the number of times a file can be used by using...
-
This week, the Excel team here at Microsoft received the tragic news that Excel MVP Nathan Oliver passed away unexpectedly. Nate was a vital member of the MVP community who loved sharing his vast knowledge of Excel with customers and fellow Excel enthusiasts. We’ll always be grateful to Nate for...
-
Hi everyone!
Yesterday I experienced the tedious task of figuring out what the differences are between the VBA projects of two different versions of a customer project I built a long time ago. Luckily there are tools to compare differences in text files, such as ExamDiff.
But the VB editor doesn’t...
-
Unlike Word, Excel doesn't have a Change Case button or keyboard shortcut for magically switching between uppercase, lowercase, and proper case. Now, that doesn't mean that you have to manually retype all your text. (In fact, the very thought of you doing that makes me weep.) Instead, you can...
-
Hi All,
I’ve just updated Charles Williams and my Name Manager utility.
New in this version is that when you delete a range name, you will be asked whether you want to unapply the range name in your formulas. This should effectively prevent any #NAME! errors from surfacing when you remove a range...
-
Hi all,
I had a bit of time to spare the other day (got snowed in during travel by train) and wrote a couple of pages about a new Excel 2010 feature: Pivot table slicers
I show how to customise them and also included some VBA examples on how to work with them. Enjoy the read!
Regards,
Jan Karel Pieterse...
-
Today’s author is Mike Alexander, a Microsoft Excel MVP who shows us how to add a rank to a PivotTable in Excel 2003, 2007, and 2010. For more information, visit www.datapigtechnologies.com . Adding Rank in Excel 2003/2007 Step 1: Sort your pivot table on the data measure you are trying to rank...