Tag Archives: Excel

Efficient project meetings and a small template

Posted on by
Reply

So here’s a new post on something I’ve been using for years. A simple actionlist that has grown to a tool I use very often. Maybe ‘tool’ sounds complicated, but it really isn’t, I guess thats part of why I like it so much. So what is it? In its essence its a way of working to get your project meetings done efficiently. As a side effect I created a spreadsheet with several tabs for listing actions, issues, risks and the like for a project. Over the years it changed to reflect my way of working, so maybe its better to elaborate on that before explaining the sheet. Continue reading →

Excel settings stack in VBA

Posted on by
2

Often if procedures are called from existing code they change these settings, which makes it hard to track the current settings when a call returns. This code provides a stack to be used for Excel Application based settings, it provides two base functions; Push and Pop. The Push function stores the provided settings (or current settings for all optionals left blank) and sets them. Upon Pop, the previous settings on the stack are restored.

Continue reading →

VBA splitter control to dynamically resize controls on a userform

Posted on by
20

Here’s another post of something I created long ago, yet never got to post. Just trying to catch up here :-)

While looking for a control myself to achieve this, I couldn’t find any. Some VB6 controls we’re available, yet when distributing spreadsheets or databases I just don’t like to create to much dependencies on external controls. Quite often the support required goes through the roof when external dependencies are used.

Continue reading →