Using (xl97) I have a userform that opens after a user event to display some
data extracted from a worksheet. On this form is another control button
that is enabled (or not) depending on the state of the extracted data
displayed on the form.

If the control button on the first form is enabled and clicked a second form
opens allowing the user to change some data, which in turn affects the
values on the sheet being the same data used on the first form. Closing the
second form reveals the first form again but of course the data and the
state of the enabling button has not changed.

Is there anyway that the first form can dynamically change in response to
the users action on the second form?

I had thought about closing and re-opening following the second form close
event, but that seems a bit drastic and heavy handed.

TIA

Nigel





----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---