Results 1 to 3 of 3

Thread: Sharing Variables Between User Forms

  1. #1

    Thread Starter
    Member
    Join Date
    Mar 2005
    Location
    SoCal
    Posts
    54

    Sharing Variables Between User Forms

    I have been informed that if I want to use the same variable in 2 different forms (so that I can set the value with one form but include it in a string created by a different form, that I can do so by declaring the variable in a module. How do I get at that variable then from within the userform? Do I need to reference the module some how?

  2. #2
    PowerPoster kfcSmitty's Avatar
    Join Date
    May 2005
    Posts
    2,248

    Re: Sharing Variables Between User Forms

    declare the variable as public in the module, then just treat it as a normal variable. It will pass the variable from form to form itself, I believe.

  3. #3

    Thread Starter
    Member
    Join Date
    Mar 2005
    Location
    SoCal
    Posts
    54

    Resolved Re: Sharing Variables Between User Forms

    Much obliged.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width