Macro that will open the VB Editor in 2010

Why not just use [ALT]+[F11]?

Or of course just use Alt+F11 since there's no mouse required.

Thanks, Martin. The reason I wanted a macro is so that I could assign the shortcut alt-b, which is very ergonomic, especially if you have to look at the keys when you type as i do. Plus what William Butler Yeats referred to as "the fascination of what's difficult." Not that this is particularly difficult. Maybe it's just the fascination of what's cool."

For what it's worth, here's the rest of that verse in Yeats' poem, which i haven't read since i was an English major, lo those many years ago:

"The fascination of what's difficult / Has dried the sap out of my veins, and rent / Spontaneous joy and natural content / Out of my heart."

Let it be a warning to us all :-)

I guess he was an obsessive compulsive:)

Anyhow I can understand where your coming from as I type this with the index finger of my left hand and the middle finger of my right, but I'd assign it to Alt+v (For Visual basic).

Alt+v is Great idea. So I tried it but apparently it's already a proprietary Excel shortcut because it wouldn't allow it, at least in 2010. Who knew. Do you get the same result?

Re: Yeats: I think you're right about him. As further evidenced by the only other line of his I remember: "Yet if it does not seem a moment's thought, our stitching and unstitching has been naught."

"We sat together at one summer's end,
That beautiful mild woman, your close friend,
And you and I, and talked of poetry.
I said, 'A line will take us hours maybe;
Yet if it does not seem a moment's thought,
Our stitching and unstitching has been naught.

Speaking for myself, I guess poets are as OCD as coders!

English Lit 101 is adjourned :-)

Yes Alt+V is taken so then Alt+b (for Basic of course) it is.

Clothes fall whispering
Silken breasts and thighs revealed
Love in her brown eyes

A haiku I wrote a while back.

That's awesome Martin, especially the opening line. It reminds me of another great Japanese  mood setter, "Snow Falling on Cedars," but even more evocative since clothes don't actually whisper. Very nice.

While we're on cool things to do with words, at one period in my life I obviously had a lot of time on my hands because I got into writing palindromes. One of my favorites was "Slate men in denim mined nine metals."

Not as sublime as your haiku, but fun.

Now I'm distracted... but hats off to the palindrome and the haiku :-)

I hope I don't get in trouble for this but my wife gave me a portfolio of boudoir pictures as a wedding gift and this was my response.

For Love of Me

I see you standing there
      Draped in a parted robe;
            So very small,
            So vulnerable,
                  Perhaps afraid.

About to bare yourself
      Unto another man;
            In camera lights,
            Exposed to him,
                  For love of me.

My Miracle

From when I first awake at morning’s light
And find you softly breathing next to me,
Until the time I hold you late at night
I wonder just how lucky I can be.

That I could find someone as wonderful      
And beautiful as you to be my wife
Just seems to me to be a miracle
I never thought would happen in my life.

And while I don’t believe in Gods who make
Such simply wondrous miracles come true
I must (and do) believe at each daybreak
Because I see a miracle in you.

And finally one I didn't write but that I've always liked.


I sailed up a river with a pleasant wind,
New lands, new people, and new thoughts to find;
Many fair reaches and headlands appeared,
And many dangers were there to be feared;
But when I remember where I have been,
And the fair landscapes that I have seen,
Thou seemest the only permanent shore,
The cape never rounded, nor wandered o'er.
                  —Henry Thoreau

From A Week on the Concord and Merrimack Rivers

my miracle...  nice.

If you get in trouble for the first one I hope that makes up for it :-/