View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Pierre via OfficeKB.com[_2_] Pierre via OfficeKB.com[_2_] is offline
external usenet poster
 
Posts: 122
Default filling userform textboxes

Thanks Tom,

you're the greatest !!!!
option 2 works perfectly for me !!!
I had forgotten to fully mention the path !
thanks again !
Pierre

Tom Ogilvy wrote:
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.

Hi expert,

[quoted text clipped - 17 lines]
Thanks for looking at my problem.
Pierre



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