VBA Essentials

[mdmackillop]

Some essential documentation. Should this be a KB entry?
MD

[Jacob Hilderbrand]

LMFAO

:rotlaugh::rofl2:

:banghead::banghead::banghead:

[Ken Puls]

:think:

ROTFL! :rotlaugh:

[Zack Barresse]

Is that a joke guys? Like you haven't done it? </sarcasm>

[Anne Troy]

Gee. Should've had MD convert that to Excel and submit to the book, huh? :)

[Ken Puls]

Is that a joke guys? Like you haven't done it? </sarcasm>

:giggle Isn't a joke always funnier to those who have lived the experience? And Zack... it looks like you screwed up the sarcasm tags again. Don't know how many times we have to tell you that it's the SQUARE brackets! :p

And for the record... I think that would make great cover art for a book one day! :rotlaugh:

[XL-Dennis]

First of all, this is the best written paper on VBA I ever have seen, including all printed books on the subject.

Yes, I believe this paper qualify for being the #1 KB Entry that everyone should be forced to read before enter the KB-part :thumb

My hat off for this well-written paper and for the insight on the subject the author show :bow:

:beerchug:

KR,
Dennis

[Zack Barresse]

Dennis: AMEN brother! :)

Ken: Not for HTML !! :p

Anne: Hind sight is .. .. better than our fore-sight. ;)

[Ken Puls]

Not for HTML !! :p

True but we don't allow HTML in our posts, only BB code! :devil:

[Zack Barresse]

Ah! Ya got me!! :bow:

[shades]

Some essential documentation. Should this be a KB entry?
MD

I passed this one with flying colors! Is there MOUS (or VBAX) certification for Head-banging? ;)

[Anne Troy]

Shades: You of all people should know how Jesus paid for our sins. Well, here at VBAX, DRJ and Zack pay for all our sins. They do all the head-banging for us. ROFLMFAO!!!!

[Ken Puls]

:what:

That wasn't in my VBAX user manual!!! I'd better go start sinning to catch up! :rotlaugh:

[Zack Barresse]

:what:

That wasn't in my VBAX user manual!!! I'd better go start sinning to catch up! :rotlaugh:

:banghead: please :banghead: forgive :banghead: ken :banghead:

[shades]

Shades: You of all people should know how Jesus paid for our sins. Well, here at VBAX, DRJ and Zack pay for all our sins. They do all the head-banging for us. ROFLMFAO!!!!

You mean my flattened head is for nothing?

[shades]

:what:

That wasn't in my VBAX user manual!!! I'd better go start sinning to catch up! :rotlaugh:

Shall we sin more that grace might increase even more? (Romans 6:1)

:rofl

:help

[Anne Troy]

Did Grace gain weight?
(sorry. couldn't help meself!)

[mdmackillop]

No! That's why she's known as Amazing Grace.

[shades]

Did Grace gain weight?
(sorry. couldn't help meself!)

Why is horizontal increase assumed? perhaps grace grew taller. ;)

[cmpgeek]

Why is horizontal increase assumed? perhaps grace grew taller. ;)

hehe i wish i could do that... grow taller that is... right now i am too short for my weight LOL :D

[Brandtrock]

I've lived by the, "I'm not overwieght, just undertall" paradigm for years. :rotlaugh:

I think I'm finally to the stage where I can wobble but not fall down. :rofl

[shades]

I'm the perfect weight for someone 9'6". ;)

Or, the perfect weight for two 35 year olds.

[Anne Troy]

ROFLMFAO!!!
Shades: You are tooo funny!
I love it!!
Please note that I am the perfect weight for 1.5 35-year-olds.

[cmpgeek]

ROFLMFAO!!!
Shades: You are tooo funny!
I love it!!
Please note that I am the perfect weight for 1.5 35-year-olds.

out of sheer curiosity - what is the perfect weight for a 35 yr old? LOL

[Anne Troy]

Well, what's 110/1.5? LOL!!

[Ken Puls]

Well, what's 110/1.5? LOL!!

:eek: Anorexic (sp?), I think...

[cmpgeek]

:eek: Anorexic (sp?), I think...

110 / 1.5 = 73.33333

yea - i think anorexic would cover it LOL

[mdmackillop]

Nothing wrong with 110, (unless it's kilos of course)

[cmpgeek]

Nothing wrong with 110, (unless it's kilos of course)


:reading: (trying to find a conversion table... LOL)

[Zack Barresse]

Kb = Lbs / 2.2



or as I have to do (for drug administration amounts) in my head ...


Kg = (Lbs. / 2) - ((Lbs. / 2) * %10)

[shades]

Well, what's 110/1.5? LOL!!

No, no, no. Even an over-the-hill mathematician like me knows it is:

= 110 * 1.5



:clap:

[mdmackillop]

Hi Zack,
I heard on the news tonight that they're thinking of scrapping the lump of platinum they use as the Kilogramme standard, and redefining it in terms of electrical current through a coil or some such. I hope the inclusion of amps, ohms and the rest don't complicate your formula too much!:stars:

[shades]

Hi Zack,
I heard on the news tonight that they're thinking of scrapping the lump of platinum they use as the Kilogramme standard, and redefining it in terms of electrical current through a coil or some such. I hope the inclusion of amps, ohms and the rest don't complicate your formula too much!:stars:


Sub WeightDetermination()
Dim Dreamboat As Object
' Ohms measures resistance in amps
' Dreamboat is equivalent to 12 volt battery
Const Resistance = 8.33
' Power output
Const Power = 100
Dim Wt As Double
Dim NewWt As Double
Wt = Dreamboat.Range.Value
NewWt = Wt * Resistance * Power
MsgBox NewWt
End Sub

[Ken Puls]

Kb = Lbs / 2.2

:think: I thought that Kb = Mb / 1024 :devil:

[mdmackillop]

Hi Shades, If you add in the error handling, it works!


On Error GoTo err:
Wt = Dreamboat.Range.Value
NewWt = Wt * Resistance * Power
err:
MsgBox err

[shades]

I didn't think there was ever any error associated with Dreamboat?! ;) Guess I will have to code in light of Romans 3:10.

[Anne Troy]

I had to look that up! LOL!

Actually, ALL errors are associated with Dreamboat!

[Zack Barresse]

So am I out of the dog house now? :D

And Kb = Kg Doh! :omg2: