MrExcel #1 on Top 10 List...

[zorvek]

Anyone want to place bets on how long the current Excel MVP lead will last?

 

[NateO]

Let's not do that bet, I feel bad for my friends at Microsoft right now, tough times...

Just to repro, you can tie this to any Forms Text Box (Shapes), in any version of Excel, 2007, XP, etc...

Sub foo()
MsgBox "Name: " & _
    ActiveSheet.TextBoxes(Application.Caller).Name
End Sub

I admit, I leveraged this off the master, Monsieur Laurent Longre.

 

[Richard Schollar]

To be fair didn't I only say I didn't *think* it was possible? I provided a reasonable alternative too And if said person was using an ActiveX control, I'd have been right

But it is a cool way to do it Nate

 

[NateO]

I'm just teasing you, Richard - because it's fun.

Your response was a good one, mine was irresponsible, guessing they might be using Shapes, it happened to be the case.

I'm not all bad, I did drag you down for a round when you got into Seattle...

 

[zorvek]

...Let's not do that bet...

Good advice...the one layoff aside, we have still had three leads in as many years...that is more to what I was referring.

 

[matthewspatrick]

Patrick gets around? Where is he?

Here, finally. I'm not sure why I put it off. I guess maybe I was channeling Groucho Marx, not wanting to register at a board that would have me as a member

 

[Jaafar Tribak]

The excel site that inspires me the most is definitely http://www.xcelfiles.com/ by Ivan F Moala. Strange that noone mentioned it on this thread

Among other nice things, It has some really amazing Win32 programming stuff elegantly adapted to Excel - I've never found anything similar on the net or otherwise and i certainly have learnt a lot from it.

Regards.

 

[Richard Schollar]

Here, finally. I'm not sure why I put it off. I guess maybe I was channeling Groucho Marx, not wanting to register at a board that would have me as a member

Howdy Patrick

Good to see you here!

 

[barry houdini]

Howdy Patrick

Good to see you here!

Seconded...

 

[Greg Truby]

The excel site that inspires me the most is definitely http://www.xcelfiles.com/ by Ivan F Moala. Strange that noone mentioned it on this thread
Among other nice things, It has some really amazing Win32 programming stuff elegantly adapted to Excel - I've never found anything similar on the net or otherwise and i certainly have learnt a lot from it.
Regards.

LOL. Jaarar, it would have surprised me had you said anything else! You and Ivan sort of feed off of each other anyway. As far as the Win API stuff, there's only a handful of members like the Toms (Urtis & Schreiner), Haluk and maybe Nate that can keep up with you lads on that particular branch of wizardry. But yes, Ivan's site has some really amazing stuff.

Oh and "howdy!" to our friend, Patrick!