MsgBox Centred Over a Userform

calendar date August 20, 2009 by · Leave a Comment comment link

I have recently developed an Excel-based analytical tool that is designed to share the desktop.  The tool provides the functionality to position the Excel window either on the left or right side of the desktop, occupying about 1/2 of the screen.

For this tool, there are several userforms used that are positioned within the Excel window, respecting the left / right orientation when used, with the potential for several userforms to be open at the same time.  I felt that the aesthetics for userform presentation was just not right initially because when the standard Msgbox prompts were issued, these would appear in the centre of the screen, rather than the userform to which the prompt referred.

Continue Reading: MsgBox Centred Over a Userform »

categories Filed Under: VBA · tags Tagged With: , ,

Zip and Unzip Using Shell32

calendar date May 12, 2009 by · Leave a Comment comment link

Zip files are pretty common.   We receive them as email attachments, download from the Internet, create them to conserve space, email out to others…

Winzip is used by many – including me – to zip or unzip typically because it works well and integrates into Windows explorer becoming available within the context menu for files and folders.

Continue Reading: Zip and Unzip Using Shell32 »

categories Filed Under: VBA · tags Tagged With: , ,

MS Access UDFs

calendar date April 16, 2009 by · Leave a Comment comment link

Recently I was presented with situation from a business user that could not be dealt with using any of the supplied intrinsic SQL functions – at least to my knowledge anyway.

I started doing some research and before long came upon something that was completely new – to me anyway.  Some of you more experienced Access folks are probably up on this, but for the rest of us, I thought it was worth this commentary.

Continue Reading: MS Access UDFs »

categories Filed Under: Access · tags Tagged With: , , ,

A VBA Calendar

calendar date February 13, 2009 by · 2 Comments comment link

Just about every application needs a calendar of some sort. There are calendar controls available that feed back a date, but these are typcially from some version of VB or another third party. I have been using my own VBA calendar for my applications, because I needed some features that the "other" controls did not provide. 

Many of my application requirements have needed start and end dates and different periods – typically weekly or monthly- to set up reporting criteria.  I needed the capability to restrict date selections to ensure their accuracy.

Continue Reading: A VBA Calendar »

categories Filed Under: VBA · tags Tagged With: , ,