What exactly is 'MrExcel MVP' and 'Board Regular'?

[MorganO]

Darn, didn't work. How in the world did this board know I wasn't an Excel God?

Owen

 

[Asala42]

Hmmm... from all the misdirection I am assuming that a "MrExcel MVP" is in reality a secret club that you have to gain access to through some secret handshake, sign, or... wait! Maybe its a bit of Excel code posted to this forum! Here goes!

I think it's: back, back, uppercut, forward, kick+triangle, forward, down, forward+punch

(I never get it right - that's why I'm a regular)

 

[Jon von der Heyden]

You also get awarded the MrExcel MVP for being particularly handsome. Greg got it 'cos he's helpful though...

You handsome?????????? Waaaaaaaaaaaaaaa ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha!

 

[Jon von der Heyden]

Now that I've recovered from that laughing ordeal!

Having a look at the profile of MVP there are few with sub 3000 posts so if that's your goal I think you're gonna have to be patient.

Now, normal folk (like me) are Board Regulars. The particularly helpful bunch are MVP's.... but if you really good you become a ".". Yup, Like Juan Pablo González, XL-Dennis and of course, Aladin!

. ??????????????????

 

[Domski]

Hmmm... from all the misdirection I am assuming that a "MrExcel MVP" is in reality a secret club that you have to gain access to through some secret handshake, sign, or... wait! Maybe its a bit of Excel code posted to this forum! Here goes!

If Intersect("MrExcel Message Board Forum","Handsome Excel God") = True then MrExcelBoardRank = "MrExcel MVP"

If that worked my MVP badge would have been in the post ages ago! Must check my unopened mail just in case I've missed something.

 

[Jon von der Heyden]

Maybe your badge got lost in the post and somehow ended up in Richards mail box

It's the only logical explanation about how the BFG has assumed the MVP title!

 

[Joe4]

Owen,

To answer your question regarding MVPs, check Starl/Tracy's first response in this link:
http://www.mrexcel.com/board2/viewtopic.php?t=226209&highlight=mvp

 

[MorganO]

JM,

Thanks for your excellent response. That was exactly what I was looking for. Didn't find that thread when I did my initial search on this subject, or else I would have never started us down this route!

Owen

 

[Richard Schollar]

JM,

Thanks for your excellent response. That was exactly what I was looking for. Didn't find that thread when I did my initial search on this subject, or else I would have never started us down this route!

Owen

And miss out on an opportunity to justify why I got the MrExcel MVP? No way! Glad you brought it up!

 

[Greg Truby]

If Intersect("MrExcel Message Board Forum","Handsome Excel God") = True then MrExcelBoardRank = "MrExcel MVP"

Darn, didn't work. How in the world did this board know I wasn't an Excel God?

-Owen

Here's how this board knew you weren't an Excel god...

• The intersect() function works on range objects, not on string variables.
• The strings you used would not even make it as valid range names since they contain spaces and spaces are the intersect operator, making these names not only illegal; but the call to intersect() redundant.
• The intersect() function returns a range object not a boolean value
• The appropriate comparison operator would therefore be IS and you need to test against the NOTHING object.
• Your test only evaluated good-lookingness, i.e. Erik and Richard would be patently rejected. Hence you need an OR + a comparison for helpfulness
• A board rank would not be a string, but most likely an enumerated constant.
• The group of MVP's would obviously be a collection and you failed to add yourself to such.

So, the correct code should go about like so:

Enum mrxlHelpLevels
    xlNewbie
    xlBoardRegular
    xlNotInept
    xlGettingThere
    xlOneGoldStar
    xlCanTellButtFromHoleInGround
    xlTwoWeeStars
    xlActuallyHelpful
    xlQuiteHelpful
    xlVeryHelpful
    xlAladin = 99
End Enum

...
    If Not Intersect(Range("MrExcelMessageBoard"), Range("HandsomeExcelGods")) Is Nothing _
    Or Me.Helpfulness >= mrxlHelpLevels.xlVeryHelpful Then
       Me.BoardRanking = mrxlRankings.xlMVP
       
       collMrExcelMVPs.Add Item:=Me.Name, Key:=Me.BoardID
    
    End If

And, per Pook's recent thread -- please see #8 -- this works, but it has not been tested.