Let the user know to enter time in hh:mm:ss

[aman1234]

Hi guys

I am looking for a property of textbox in excel , so that when the control goes to textbox then it should display ..:..:..: ,something like this to let the users know they have to enter time in the textbox.

As we use input mask property in access to enter date or time in particulare format.

I hope you understand my problem

Regards
AMan

[shg]

You could use hh:mm:ss as the default text in the box, and/or use the ControlTipText property.