The Problem You're writing an Excel VBA Front end to some sort of system, it could be an Access, Sql Server or Oracle database, or some text files you're consolidating from third party data sources. You want to incorporate a Grid into your vba form so that it behaves similar to a Microsoft Access form and sub form relationship or any other slick third … [Read more...] about How To Make An Excel VBA Listbox Act Like A Grid
Most Popular
Mac Smart Folders Can Help Keep You Sane
The step by step tutorial to get you up and running and super productive with mac smart folders real fast. The Problem Maybe you have come across this issue before. You are building up notes or are creating articles for future blog posts and you want to categorise them. … [Read more...] about Mac Smart Folders Can Help Keep You Sane
Excel Advanced Filter – Criteria to Show Blank Cells
Today I had a problem in Excel that crops up quite often, namely how to filter to find blank cells or how to filter to exclude blank cells. … [Read more...] about Excel Advanced Filter – Criteria to Show Blank Cells
Excel 2010 Advanced Filter Tutorial
The Excel 2010 Advanced Filter adds database functionality to Excel, you can query by example and style custom reports with this feature. … [Read more...] about Excel 2010 Advanced Filter Tutorial
Power Excel vba secret, avoid using select
I see it all the time, code that selects one thing, then another, then selects something else in order to navigate and write data in an Excel spreadsheet. Instead understand that the Microsoft Excel object model and your vba code will be more professional, robust and maintainable if you don't select anything but instead interact with the Excel objects … [Read more...] about Power Excel vba secret, avoid using select