Excel VBA Duplicate a Userform

Here’s another one of those features I’ve always been amazed that in over 30+ years Microsoft never saw fit to add to the Excel VBE, the ability to copy/paste, or if you prefer, duplicate a UserForm. Seems like the type of thing that developers could find useful, no?!

Manually Duplicating an Excel UserForm

Sure, you can duplicate an Excel UserForm manually:

  • Rename the UserForm to the desired new UserForm name
  • Export the UserForm
  • Rename the UserForm back to its original name
  • Import the exported UserFrom
  • Activate the imported UserForm and start development

but after a while, if you do a lot of this type of work, it can become a time suck.

Duplicating an Excel Userform Using VBA

Today, I thought I’d share a small snippet of code I created long ago to automate this task.

Continue reading →

Excel Export Chart As An Image Add-in

For some time I have needed to export various Excel Charts to an image for consumption in other programs. I’ve always been amazed that Microsoft never directly added the option to do so in the right-click context menu.

Thus, I created a small utility to make this process painless, save me some time and frustrations and decided to convert it into a proper add-in and offer it here in the hopes it might serve others.

The Add-In Ribbon

The add-in adds a simple tab named CARDA Tools to the existing ribbon with 3 buttons as shown in the image below.

Continue reading →

VBA – List Fonts

Back in 2015 I posted my article VBA – Enumerate Fonts which extracted a list of system fonts by automating Word. However, when I worked on my MS Access – Improved HTML demo I decided I didn’t want any such dependencies and developed some code to do without Word as an intermediary and I thought I’d share it.

The Code

Simply copy/paste the following code into a Standard Module and call the GetListFonts() function (which will return an array of all the available system fonts).

Continue reading →

Access – Copy/Paste Into a Table

I thought I’d quickly post a little performance tip for copying and pasting data to populate tables.

A Quick Note About This Tips
The following tips doesn’t truly apply when copying and pasting small datasets, but is aimed at copying and pasting large amounts of data.
Continue reading →

WordPress Open Link in New Window Plugin

Many of the sites I create are done in WordPress, it simply works! That said, one of my peeves over the years has been the need to manually edit each link to open in a new window so users don’t loose the page they are on. This week I finally decided to use this as an excuse to learn about developing WordPress PlugIns and created my own for this purpose. Things went very well and I plan on continuing development and adding other features that I feel can help me as a developer and author.

As such, I thought I’d share it here. (Yes, I will be looking into publishing it through the WordPress.org portal)

Continue reading →

VBA – Make Skype Call

Have you ever wanted to be able to initiate a Skype phone call at the click of a button? Well, the reality is that it is actually very simple to achieve.

The Basic Concept

The basic idea is that Skype follows a URI format which is used in HTML links and allows for interactivity between webpages and itself. The basic format being

[protocol]:[username]?[action]

So in the case of a phone call, it becomes

skype:[username]?call

Knowing the above, for making a call, we need to use a URI similar to: 

skype:5555555555?call

Now that we understand what we want to do, there are a couple of ways we can go about using this URI functionality within our application. Mainly:

  • FollowHyperlink Method (Access specific)
  • Shell Function

Let’s briefly explore each of these approaches.

Continue reading →

Access – Usage Breakdown

I recently added a poll to my site to see what version, bitness, … people were using and thought I’d break down the results, as of 2021-07-26 with 252 votes (I will try to update this page as the results evolve).

The Results

Access Usage Breakdown

Continue reading →

Read Data From An Access Database

As with most things in life, there are many ways to tackle such a need as reading data from an Access database from other applications (Excel, Word, …), but today I thought I’d demonstrate just how easy it is to do with some simple VBA.

Continue reading →

The End of Windows 10

There have been rumors abound of Microsoft teasing people with their next OS Windows 11 and there might be truth to this as they have now announced the end of Windows 10 support in 2025.

If you check their product lifecycle page at Windows 10 Home and Pro – Microsoft Lifecycle, you will see an “Important” statement that reads:

Microsoft will continue to support at least one Windows 10 Semi-Annual Channel until October 14, 2025.

Continue reading →