The answer to all three question is yes.

1. exactly

2. but why would you want to; you can do the same with the code in the
userform module. If you choose that path, you would call code in this
module from the code in the Userform module.
You would need to fully qualify your references like
Userform1.Txt_Myname.txt = . . .

3. As long as userform1 is loaded (doesn't necessarily have to be visible),
then any code can set the value of a control in userform1 including code in
userform2. You just have to use the fully qualified reference as shown
above.

--
Regards,
Tom Ogilvy


"Pierre via OfficeKB.com" <u13950@uwe wrote in message
news:55d452d4e06d4@uwe...
Hi expert,

i user userform1 to retreive data from an excel sheet . The data should
then
be visible in textboxes on userform1 that have no sourcecontrol.
My questions:

1. is it possible to write vba code to fill the textbox from the datasheet
?
I think yes, something like: txt_myname.text = sheets("datasheet").
range("A3").value
is this the correct way ?

2. is it possible to make a seperate module with vba code to fill
textboxes
on userform1
I think yes but don't know how...can you help

3. is it possible to use vba code in a different userform2 to fill
textboxes
in userform1 ?
I think no, but can you help if it is possible ?

Thanks for looking at my problem.
Pierre


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200510/1