• Skip to main content
  • Skip to primary sidebar
  • Home
  • Blog
  • VBA Programming
  • Open-Libre Office
  • Web Stuff
  • Videos
    • VBA Articles
    • LibreOffice And Open Office
  • Excel VBA Glossary
  • About
  • Contact

Most Popular

How To Make An Excel VBA Listbox Act Like A Grid

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

Mac Smart Folders Can Help Keep You Sane

View of sample smart folder criteria

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

Excel Vba Advanced Filter Source Data

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 directly. Check out … [Read more...] about Power Excel vba secret, avoid using select

Primary Sidebar

Free Training Videos

Make VBA Listbox Work as Database Grid

Image

Ulitmate Excel VBA Advanced Filter Tutorial

Click video and press f for full screen or watch on YouTube

Dynamically Link Images to LibreOffice Base Form

Click video and press f for full screen or watch on YouTube

Create Database with LibreOffice Base

Click video and press f for full screen or watch on YouTube

Create VBA Form In Excel

Click video and press f for full screen or watch on YouTube

Affiliate Disclamer

We hope you love the products we recommend! Just so you know, we may collect a share of sales or other compensation from the links on this page.
Thank you if you use our links, we really appreciate it!

Terms Of Service | Privacy Statement | Copyright © 2024 BusinessProgrammer.com.