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
--
thank you so much for your help

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


On Apr 30, 2:16 pm, clara <c...@discussions.microsoft.com> wrote:
> 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
> --
> thank you so much for your help