Tab/space alignment/organization with Arial font

Hi all,

I've been stumped with this issue all day. I previously have a set of data separated by tabs that aligned up perfectly when using the font Lucida Console.

However, I need to create the same effect for the font Arial. Because Lucida Console's characters have equal width, it was simple to make them all align perfectly regardless of their length. Arial's characters have different widths and depending on their position in a line, a tab may show up differently.

In the end, I want it to look like this:

1234 (TAB) Item 1 HEHEHAHAHA (TAB) TEEHEE (TAB) HAHA
1334 (TAB) Item 34 (TAB) T (TAB) HAHA
(despite what it looks, it appears to be aligned in the message box)

and so forth.

Anyone have any ideas? I've tried using different amount of tabs based on the length of the string, tried filling in spaces to match the longest string, but because of Arial's non-fixed widths, the tab/spacing is still screwed up.

The tool I'm currently making is in VBA, but I have no issues if a solution can be obtained through Excel.

Thank you for your time!

-Paloopi