useforms and modules

[kamjo01]

hi all,

this must be a nobrainer, but after spending 6 hours of reviewing code i'm at the end of my rope.

here is the question:
I have a excel application in this app i have a userform with a textbox. I want to write to this textbox object out of a routine that sits in a module. Everything i have tried sofar results in a 424 object required.

I'm office 2K and win98

any thoughts on this s-)

 

[kamjo01]

it turns out to be the case that the form and code behind the form are required to run from the form itself. The module can be used to call the form or to init the applications. Common subroutines are stored in modules.

Simple, but after digging code for hours and hours i was lost

 

[SkipVought]

Hi,
In you module code...

UserForm1.TextBox1.Text = MyTextValue

Hope this helps Skip,
metzgsk@voughtaircraft.com