Tag Archives: Static

Custom Images With Static RibbonX Dropdowns

In the last post I introduced a template which adds a custom tab on the ribbon. The focus of that post was on the plumbing required to handle state loss so, to reduce background noise, the custom tab just had a couple of simple … Continue reading

Posted in Microsoft Excel | Tagged , , , , , , , | 1 Comment

Count Distinct Or Unique Values – VBA UDF

A handful of posts ago I looked at some FREQUENCY() formulae which could give a count of distinct or unique values in a given column. The formulae became quite complicated and slow – particularly when dealing with mixed data types – … Continue reading

Posted in Microsoft Excel, Microsoft Office | Tagged , , , , , , , , , , , , , , , , , , , | 6 Comments

VBA Auto Data Tips

Auto data tips are a very handy feature when you’re debugging VBA code. You may have noticed that when you’re stepping through code, if you hover your mouse over, for example, a property, then you get a pop-up window showing its value. … Continue reading

Advertisement

Posted in Microsoft Excel, Microsoft Office | Tagged , , | 5 Comments