i want to create a custom controltiptext to do something similar to this

Private Sub Workbook_Open()
UserForm1.Show
End Sub

Private Sub UserForm_Activate()
Application.OnTime Now + TimeValue("00:00:05"), "KillTheForm"
End Sub

Private Sub KillTheForm()
Unload UserForm1
End Sub

to last for a few seconds then end

"Tom Ogilvy" wrote:

for a control on a userform look at the controltiptext property of the
control.






--
Regards,
Tom Ogilvy

"ernie" wrote in message
...
how do i create a little help balloon (the ones in yellow that popup for a
few seconds after clicking on a text or combo box or when you put the
mouse
over a control)?