I'm revising and consolidating a number of business letters. Most just use
form fields and drop-down menus, but for some of the more complex letters I
have been writing simple macros that run upon selection from a drop-down, ask
the user for a few bits of data, and spit out the relevant sentence or
paragraph.

The problem is that while the form field text can be set up to autoformat, I
haven't been able to figure out how to do the same for the dialog box input.
I just need to convert dialog box inputs in the same manner as form fields,
e.g., 010107 into January 1, 2007, 1234567 into 1-2345-67. These letters will
be used by novice users that are going to get confused if the data formatting
works in one place but doesn't in another.

I am a newbie to VBA but not to coding, and I just can't find any info on
how to forcibly format the dialog box variables so that they "print" in the
correct format. Please help!
Thanks,
J