-
Search RAD Excel
-
Recent Posts
- Workbook_Open vs. Auto_Open
- My First Custom Ribbon Using Excel-DNA And Visual Studio
- Get Property Syntax Bug [VBA]
- My First C#.Net UDF Using Excel-DNA And Visual Studio
- Who Has My Workbook Open? [VBA]
- Excel Development Roadmap – Where Next?
- UK Has Its Pie And Eats It
- Getting A Handle On Userforms [VBA]
- Unwanted Worksheet Events? Maybe SpecialCells() Is To Blame!
- #REF! Means Your INDIRECT() Formula May Be Slow As A Dog
- VBA: Understanding ByVal In An ActiveX Textbox KeyPress Event Handler
- Minimize And Maximize Userform Across 32-bit and 64-bit Environments
- Stop MSForms.Frame Scrollbars From Resetting On Focus
- Deceptive Appearances: MSForms Textboxes And Comboboxes
- Error Accessing The System Registry
Recent Comments
- #Excel Super Links #75 – shared by David Hager | Excel For You on Getting A Handle On Userforms [VBA]
- מיקי אבידן on Count Distinct, Unique And Successive Values Using FREQUENCY()
- Flavio Henrique da Silva on Getting A Handle On Userforms [VBA]
- #Excel Super Links #12 – shared by David Hager | Excel For You on My First Custom Ribbon Using Excel-DNA And Visual Studio
- Hidden Treasures – Best of Excel on the Web (Sep 2012) – Launch Excel on Clearing Excel tables
- Hal on Count Distinct, Unique And Successive Values Using FREQUENCY()
- Christos Rbs on Count Distinct Or Unique Values – VBA UDF
- Guzman on Making Sense of Cells Intellisense – Part 1
- Colin Legg on Workbook_Open vs. Auto_Open
- Patrick Matthews on Workbook_Open vs. Auto_Open
- CJ on Excel Macro to Find and Calculate Precedents
- Hans Hallebeek on My First Custom Ribbon Using Excel-DNA And Visual Studio
- David Reddy on My First Custom Ribbon Using Excel-DNA And Visual Studio
- My First Custom Ribbon Using Excel-DNA And Visual Studio | RAD Excel on My First C#.Net UDF Using Excel-DNA And Visual Studio
- Colin Legg on Enforcing Mutex On A SQL Server Database
Categories
- .Net (8)
- General (5)
- Microsoft Office (80)
- Microsoft Excel (80)
- Microsoft SQL Server (4)
- Off Topic (1)
- Windows (1)
Archives
- December 2016 (1)
- November 2016 (1)
- October 2016 (1)
- September 2016 (1)
- July 2016 (2)
- June 2016 (1)
- May 2016 (1)
- March 2016 (1)
- February 2016 (1)
- December 2015 (1)
- October 2015 (1)
- September 2015 (1)
- August 2015 (2)
- July 2015 (1)
- May 2015 (1)
- April 2015 (2)
- March 2015 (1)
- February 2015 (1)
- January 2015 (1)
- December 2014 (2)
- October 2014 (1)
- September 2014 (1)
- August 2014 (2)
- July 2014 (1)
- June 2014 (2)
- May 2014 (3)
- April 2014 (1)
- March 2014 (1)
- February 2014 (3)
- January 2014 (2)
- December 2013 (1)
- November 2013 (1)
- October 2013 (1)
- September 2013 (2)
- July 2013 (1)
- June 2013 (4)
- May 2013 (1)
- April 2013 (1)
- March 2013 (2)
- February 2013 (2)
- January 2013 (2)
- December 2012 (2)
- November 2012 (2)
- October 2012 (3)
- September 2012 (1)
- August 2012 (4)
- July 2012 (3)
- June 2012 (1)
- May 2012 (3)
- April 2012 (3)
- March 2012 (6)
- February 2012 (2)
- January 2012 (1)
- December 2011 (2)
Tag Archives: VBA
Get Property Syntax Bug [VBA]
I just saw this posted by @RubberduckVBA on Twitter and couldn’t resist sharing it on here. Did you know that this VBA code will compile and run correctly? And, perhaps even scarier, so will these (and variations thereof):
Excel Development Roadmap – Where Next?
The developer tool suite offered by Microsoft for Excel is currently a set of three complimentary technologies: Visual Studio Tools for Office (Dot Net) Apps for Office (Javascript) Visual Basic For Applications The VBA language is an interesting one. Often referred to … Continue reading
Unwanted Worksheet Events? Maybe SpecialCells() Is To Blame!
I’ve written a lot on this blog about Range.SpecialCells() and how careful you have to be when using it. Here’s yet another caveat which I didn’t know about until another developer brought it to my attention. Put some data in a worksheet … Continue reading
Is Your Cell Blank Or Empty?
Two pet peeves of mine are the way the terms [unique and distinct] and [empty and blank] are interchangeably used in Excel. They have different meanings so it’s really confusing when the name of a function or utility suggests it … Continue reading
Posted in Microsoft Excel, Microsoft Office
Tagged blank, CountBlanks, empty, Empty String, IsBlank, IsEmpty, Null String, PrefixCharacter, VBA
3 Comments
Excel Macro to Find and Calculate Precedents
Today’s Guest Author Kintaar is the editor of Math for Mere Mortals, a blog about numerical calculations and programming for those of us who are not godlike experts. He writes about a variety of topics in the areas of financial … Continue reading
Posted in Microsoft Excel, Microsoft Office
Tagged Calculation, Kintaar, Math For Mere Mortals, NavigateArrow, Precedents, VBA
6 Comments
VBA: Four Ways To Change Variable Values In Break Mode
Zack’s recent post over at Excel & Access Experts got me thinking: how many ways are there to change a variable’s value in break mode? Needing no further excuses to give Cropper a try, here’s what I came up with. … Continue reading
Posted in Microsoft Excel, Microsoft Office
Tagged Break Mode, Cropper, Immediate Window, Locals window, VBA, Watch Window
2 Comments
A Guided Tour Through The VBA IDE’s Options
The VBA Integrated Development Environment provides a limited set of options under Tools > Options which will let you customise the environment for your own personal needs. Microsoft hasn’t added anything new to this part of MS Office for many years … Continue reading
Posted in Microsoft Excel, Microsoft Office
Tagged Auto Data Tips, auto indent, auto list members, auto quick info, auto syntax check, compile on demand, Default To Full Module View, IDE, Intellisense, keyword, Notify Before State Loss, Option Explicit, require variable declaration, Show ToolTips, VBA
7 Comments
