Flowchart Programming
This has to be one of the weirdest little programs I've ever worked with... Back in 2003 I built a database to track our liquor inventories at work. It's fairly simple in that it has a table of product details
This has to be one of the weirdest little programs I've ever worked with... Back in 2003 I built a database to track our liquor inventories at work. It's fairly simple in that it has a table of product details
I was really happy to see an email from Microsoft this morning to let me know I've been awarded as an MVP for my 4th consecutive year. 🙂 I've been pretty quiet since a couple of days into my vacation…
Dave writes: I found your excellent code to run a procedure on a target spreadsheet from an originating spreadsheet on VB Express Forum. Â It works fine if both files are on the same jump drive but fails on our work
A friend just asked for some help with making a getSize callback work with some buttons. I figured this should be an easy one, and dove into the RibbonX book to check the table on page 172. Aha! There it
Is it just me, or if the Find and Replace tool in Excel (actually in Office) really limited? The first deficiency is that I want to be able to select "Within Selection", not within "Sheet". I know that it defaults
If you filter data out of large data sets, you may have run into an issue where you can hit 8192 non-contiguous ranges, which Excel couldn't handle. While this issue has been in Excel for many versions, I can honestly
Cherisse asks: Is there a way to set a conditional format for a cell or row to look at the date and format if that date falls on a specific day of the week. I.e. a date input as 7/21/09,
As I mentioned in this post, I started working my way through the .NET Hello World example in PED 2nd Edition. I ran into a funny issue though, where it kept opening up my application in Excel 2003 instead of
After playing around in Visual Studio, and taking my first foray into the VB.NET world, I thought it might be kind of interesting to try and see just how portable .NET code really is. So I decided to port the
I don't know how often this happens to you but it drives me crazy… Assume that I've got a formula set up in a conditional format, named range or some other place that has a "RefEdit" control on it. I
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
