Results 1 to 2 of 2

Thread: Using data from different userforms

  1. #1

    Using data from different userforms



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi, I have a main userform which consists of one multipage. In the page 1, i have 14 diff command button which links to 14 diff userforms that requires user to input in the textbox. Then, i made summation for each of the 14 userforms (i.e. Userform1total= Val(input1.text)+Val(input2.text) The same goes for the rest of the 14 userforms.

    My question is this. If i were to made a grand summation for the "Total value" of these 14 userforms. How could i do it? Any help would really appreciated,thanks in advance

  2. #2
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    718
    Articles
    0
    Excel Version
    Excel 2010 64bit
    Maybe the use of Public variables to hold each userform total.

    http://support.microsoft.com/kb/141693

Tags for this Thread

Posting Permissions

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