default value of a control

[Guest]

Hi all,

How can I set a default value for a control such as textbox just using its
property.Could Control Source help here?

Clara

 

[Susan]

is it in a userform or on a worksheet?
if it's in the userform, set the default property in the
initialization sub.
if it's on a worksheet, set it BACK to the default @ the end of the
code for the control.
hth!
susan