Solved
June 14, 2009
Difference between Visual Basic 6.0 and VBA
What is the difference between the two. I always thought VBA is somewhat 'crippled' version of VB, but when a friend asked me the…
thumb_up 122
trending_up 154
VBA Core
<p>General-purpose VBA techniques spanning the Office suite.</p>
Solved
June 1, 2009
Environ Function code samples for VBA
I am looking for some information or code samples for the Environ Function in VBA to grab the username on the current system.
thumb_up 30
trending_up 15
Solved
February 19, 2009
Assign on-click VBA function to a dynamically created button on Excel Userform
I'm creating buttons dynamically on an Excel userform with the following code: With Me.CurrentFrame.Controls.Add("Forms.CommandButton.1") .Caption = "XYZ" .name = "AButton"…
thumb_up 7
trending_up 5
Solved
November 4, 2008
Overflow when calculating a const in VBA
This declaration causes an overflow in VBA: Const OVERFLOWS As Long = 10 * 60 * 60 whereas setting the value directly is fine:…
thumb_up 13
trending_up 10
Solved
September 6, 2008
Best way to test a MS Access application?
With the code, forms and data inside the same database I am wondering what are the best practices to design a suite of tests…
thumb_up 17
trending_up 32