Populating a Textbox in a Userform

[jeff_kaufman]

2007 Excel

I have created a userform that has a series of textbox's. When I activate the userform with the userform.show property I will either populate the textboxes with template data or, if data has been saved previously it will populate the textbox's with the saved data.

I have set up code to run if the user then changes any of the textbox's - I call a sub with "afterupdate" code written into each textbox.

Here is the problem - When I initially show the userform and populate the textbox's with template data or saved data it thinks it needs to run the "afterupdate" code at that time - I don't want it to. Is there a way to populate the textbox's during the Userform Activate sub without it running the code written into the text box?

I hope that this is no too confusing. Thanks for your help.

[Norie]

Jeff

What code are you using to populate the textboxes?

Also, why the AfterUpdates for each textbox? Are you validating something?

[mehmetcik]

hi

I declare a change flag and use that to control updates. The Changeflag must be public so declare it at the top of your module.

Example.

Please Login or Register  to view this content.

[jeff_kaufman]

Norie -

I use code like this:

Please Login or Register  to view this content.

WHen I activate the userform I run this code to populate the textbox's - I dont want it to run the code attributed to the textbox unless the user makes a change.

mehmetcik -

I will give it a try - that should do the trick.