dynamic userforms
 

I have several userforms that I would like to update each time an
change is made in another embedded userform. Any suggestions.

Specifically, I have created a projection model with the relate
financial statements summarized in a userform and on the same for
there is a userform for changing assumptions.

I would like the summarized statements to update each time a
assumption is changed.

Thanks for any help

--
Message posted from http://www.ExcelForum.com

dynamic userforms
 

No linking between userforms that I am aware of. You would just write event
code to make the appropriate changes.

If you want a specific answer, then ask a specific question.

--
Regards,
Tom Ogilvy

"bforster1 " wrote in message
...
I have several userforms that I would like to update each time any
change is made in another embedded userform. Any suggestions.

Specifically, I have created a projection model with the related
financial statements summarized in a userform and on the same form
there is a userform for changing assumptions.

I would like the summarized statements to update each time an
assumption is changed.

Thanks for any help.


---
Message posted from http://www.ExcelForum.com/

dynamic userforms
 

you could have some controls share
controlsource and rowsource ranges ...

that way I can run multiple (modeless) userforms
updating automatically.



--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Tom Ogilvy wrote :

No linking between userforms that I am aware of. You would just
write event code to make the appropriate changes.

If you want a specific answer, then ask a specific question.