Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Nancy Thomas   on Dec 21 In MS Office Category.

  
Question Answered By: Bodhi Smith   on Dec 21

As long as your userform is loaded you can retrieve information from any module.
You just have to specifically identify the userform and the control.
from module1 you will call for example
sub myProcedure
msgbox userform1.textbox1.text
end sub

from the userform you can call procedure in any module  for example:
call module1.myProcedure

If you unload the userform, the information it contained will be lost.
Hope this helps

Share: 

 

This Question has 2 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on user forms Or get search suggestion and latest updates.


Tagged: