January 31, 2001

Use Early Binding to Speed Up Procedure Calls

Use early binding by declaring variables as the correct object/interface. This will speed up procedure calls. Example: * Create a new Standard EXE Project * Add a list box to Form1 * Add two command buttons to Form1 * Add the following lines of code to Form1: Public Sub Test()

Encapsulate GetSettings() and SaveSettings into Property Procedures

Encapsulating settings and registry calls into property procedures is a good way to ensure valid entries. This method manages errors while including them in IntelliSense. Example: ‘mdlSettings Option Explicit Public Property Get TipAtStartUp() As Boolean TipAtStartUp = GetSetting(App.Title,

Show the List Box of a Combo Box Using SendMessage API

Sending the window message CB_SHOWDROPDOWN to the combo boxl shows the list box of a combo box. Example: * Create a new Standard EXE Project * Add a combo box to Form1 * Add a command button to Form1 * Add the following lines of code to Form1: Private Declare