tricks of gurus

[xld]

do not wonder, but try to see the things from the point of view of "lower-skilled" people
You have a large experience and are (close to or real) professional programmer: I'm not at all, just quite interested in this stuff. As you have seen perhaps, I just like to "play" (a search for bleeding_nose would be helpful )

I am glad that you re-joined the thread. Richard asked the questions, but my original query related to code that you posted, so it is good that I now understand.

On this webpage I found you a good teacher. So thanks for the explanation.

Good, I am glad you enjoyed it and found it useful. Passing knowledge on is one of the most enjoyable aspects of the support forums.

As you have probably gathered, like Richard I enjoy a drop of the hard stuff. I do not know if you do also, but as you are from Belgium, you could thank me by sending me a 'virtual' Duvel.

PS: now nbrcrunch, are you happy your thread is alive again

Indeed, there are many interesting topics that could be covered.

 

[erik.van.geit]

thank you for the reply, xld
it's good to start the year on this board reading our last replies

As you have probably gathered, like Richard I enjoy a drop of the hard stuff. I do not know if you do also, but as you are from Belgium, you could thank me by sending me a 'virtual' Duvel.

I do not have any beer in my house and "devil" would be the last one to import here
5 or 6 Kriek (I love "Lindemans" Kriek) each year is my average
I enjoy others things in life :wink:

 

[xld]

I do not have any beer in my house and "devil" would be the last one to import here

Never occurred to me that Duvel meant Devil. It's a good beer though, see http://www.thebackpacker.net/worldbeers/duvel_1368_worldbeers.htm

5 or 6 Kriek (I love "Lindemans" Kriek) each year is my average
I enjoy others things in life :wink:

Am I hearing this right, you average 5-6 beers a YEAR! I average that many (and more) on a night out. But I guess I am English, and we are famous throughout Europe as over-indulging.

 

[Richard Schollar]

I average that many (and more) on a night out.

You heard the man: self-confessed alcoholic! I'm sure I have the number for AA somewhere around here - I'll pass it on when I find it

As for great beers - I love Ringwood Best - I truly believe it is the ultimate quaffing ale. I presume, given your neck of the woods, that you're well acquainted with it Bob?

 

[xld]

Alcoholic, I'm considered a woos by real drinkers!

But I am familiar with Ringwood beers, 12 miles down the road. I have a (small) penchant for their Old Thumper and FortyNiner beers. Haven't gotten round to Bold Forrester, BoonDoggle, Huffkin or Porter beers (I love Porter beers) as pubs just don't seem to stock them, even the brewery doesn't sell two of them (?).

I also have a taste for Tanglefoot, and Waddies 6X, so we are well served (and Palmers down in Bridport).

Anything of note up your way?

 

[Richard Schollar]

Nothing to compare to 6X or Ringwood Best. I used to audit Palmers Brewery many years ago when I was an auditor. They had some great tied pubs - the Marquis of Lorne at Nettlecombe was where we were put up by the brewery for a couple of weeks each year. **** fine place! I must admit I was never taken with the brewery's home-brewed ales though. Really nice staff at the Brewery - the owners were very nice too. One audit job I do miss (but not the rest - I hated being an auditor).

Despite my location in my profile, I actually hail from Winchester (well, mid-way between Southampton and Winchester, but I sound classier if I say Winchester!), and the family's originally from Portsmouth way. I just work in the miserable grey town that is Basingstoke.

Having said that, the Loddon Brewery's Hoppit ain't at all bad. From nearer to home, the Cheriton Flower Pots' Cheriton Pots Ale is a good 'un, and the pub itself is a great summer pub. My personal preference for pubbing has to be the Wykeham Arms in Winchester though.

My, my - I'm doing a grand impression of Mr Truby in topic mis-direction here!

 

[Jon von der Heyden]

Hang on there BFG! I see tonight on BBC that Winchester was voted Britains no. 1 town to live / buy...!

But then unless I'm very much mistaken you're from Eastleigh! Isn't that the borough where all of Winchesters riff-raff was exiled to?

 

[Greg Truby]

xld,

Nice info on conditional compiling. Your knowledge of the subject quite outstrips mine. I do wish you would have been around when I was first trying to sort out conditional compiling.

To anyone else reading this; conditional compiling is something that can come in quite handy when building complex applications. As xld has already shown, it can come in quite useful when trying to write for multiple versions of Excel, especially knowing about the VBA6 built-in constant.

Another place I've used it when building an app is that I like to use a userform as a class module for progress indicators. But when building the app and testing, things get tangled and stepping through code difficult if I'm launching the main routine from a userform. So I'll put the progress indicator-using code inside conditional compiling directives and set a constant in the VB project properties dialog. So I can slip the progress indicator code into the project but it doesn't get compiled until I flip the conditional compiling constant's value, making testing and stepping through code much simpler.


And in case anyone needs to know, while you can set a conditional compiling constant to TRUE in code (#const ccTesting = True); if you try to set to TRUE in the project properties dialog you will get an invalid syntax error. You have to use 1 or -1 for TRUE and 0 for FALSE.

 

[Richard Schollar]

OH MY GOD!!!

xld,

Nice info on conditional compiling. Your knowledge of the subject quite outstrips mine. I do wish you would have been around when I was first trying to sort out conditional compiling.

To anyone else reading this; conditional compiling is something that can come in quite handy when building complex applications. As xld has already shown, it can come in quite useful when trying to write for multiple versions of Excel, especially knowing about the VBA6 built-in constant.

Another place I've used it when building an app is that I like to use a userform as a class module for progress indicators. But when building the app and testing, things get tangled and stepping through code difficult if I'm launching the main routine from a userform. So I'll put the progress indicator-using code inside conditional compiling directives and set a constant in the VB project properties dialog. So I can slip the progress indicator code into the project but it doesn't get compiled until I flip the conditional compiling constant's value, making testing and stepping through code much simpler.


And in case anyone needs to know, while you can set a conditional compiling constant to TRUE in code (#const ccTesting = True); if you try to set to TRUE in the project properties dialog you will get an invalid syntax error. You have to use 1 or -1 for TRUE and 0 for FALSE.

I can see the headlines now:

TRUBY GUIDES THREAD BACK ON TOPIC!!!! SHOCK KILLS HALF OF MREXCEL FORUM MEMBERS...

 

[xld]

Another place I've used it when building an app is that I like to use a userform as a class module for progress indicators. But when building the app and testing, things get tangled and stepping through code difficult if I'm launching the main routine from a userform. So I'll put the progress indicator-using code inside conditional compiling directives and set a constant in the VB project properties dialog. So I can slip the progress indicator code into the project but it doesn't get compiled until I flip the conditional compiling constant's value, making testing and stepping through code much simpler.

I use that case also. Stepping through is bad enough, but it also interferes badly with checking the worksheet, so best switched off (as long as you remember to test again with it switched back on at the end, many times my progress controller hasn't been the best <G>.

if you try to set to TRUE in the project properties dialog you will get an invalid syntax error. You have to use 1 or -1 for TRUE and 0 for FALSE.

I must admit, I rarely use the properties to set CC, find it far easier (and more intuitive) using the constant, it is very easy to just set it up as a global constant (even though I abhor global variables in principle). You cane even set it as module scope variables, have different values in different modules, thereby focussing on particular code.

As I mentioned earlier to Richard, I tend to have the testing conditional constant in every module, and I have code to go through every module and set/reset.