Here's our Microsoft Office Tip for.. May 5, 2003
Click Here to see a complete list of all of our previously released Tips!
Adding Control Tips When the Form Loads
You can use a userform's Load event to add or modify a control's tip text. Depending on the circumstances, you may want to modify all of the form's controls or just one. To do so, simply add a statement in the form

Me!controlname.ControlTipText = "new control tip text"

to the form's Load event. For instance, if you want a control named cboNames to display as its control tip "Choose a name," you'd use the following statement:

Me!cboNames.ControlTipText = "Choose a name"