How to reset the values in a Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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...
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Form Refresh 1
How to make a txtbox not visible 7
dynamic size of label, and depending on size label position of tex 3
Copy cell change to other workbook 5
Frontpage 2000 - Going to a new page from a value in a drop-down box 0
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Changing the text of a label on a Userform 1
Formatting values in a form control. Is it possible? 2

Back
Top