How to reset the values in a Form
 

Hello,

I got a form and have some textboxes, labels etc.

After some actions, the values on the form (values from labels or textboxes)
are sent to related cells.

And when i do this, the values must be the same as "UserForm_Initialize"

But i couldn't find something for it..

I want the form to be "refreshed" as it opened for the first time...

If i can not do this, i will write for every box for the value that i want :)

Thanks...

How to reset the values in a Form
 

You could call that Userform_initialize procedure at the end of your Ok button.

But if that _Initialize event does lots of things, you may want to create
another procedure that just loads the textboxes/checkboxes/etc.

Then both the _Initialize and your "ok" procedure could call the same procedure.



SupperDuck wrote:

Hello,

I got a form and have some textboxes, labels etc.

After some actions, the values on the form (values from labels or textboxes)
are sent to related cells.

And when i do this, the values must be the same as "UserForm_Initialize"

But i couldn't find something for it..

I want the form to be "refreshed" as it opened for the first time...

If i can not do this, i will write for every box for the value that i want :)

Thanks...

--

Dave Peterson