+ Reply to Thread
Results 1 to 2 of 2

Transfer variable from userform to sub

  1. #1
    Registered User
    Join Date
    06-24-2015
    Location
    United States
    MS-Off Ver
    2010
    Posts
    21

    Transfer variable from userform to sub

    Hello!

    I am having trouble transferring a variable from my userform Entry (), that I want to define by the user's input, to my sub Sort1().

    It has to be simple, because when I change the input values to simple numbers in the code, it runs.

    You will know when the code runs because things will highlight on the sheet.

    Attached is the code.

    Thanks!!!
    Attached Files Attached Files
    Last edited by beric7; 06-13-2016 at 10:46 AM.

  2. #2
    Registered User
    Join Date
    06-24-2015
    Location
    United States
    MS-Off Ver
    2010
    Posts
    21

    Re: Transfer variable from userform to sub

    I figured it out!

    You have to use the "Hide" function on the userform. It may be a clunky way of doing things, but it works.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA transfer of a variable value to another variable value if first value is greater
    By markjohnconley in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-23-2016, 03:21 AM
  2. [SOLVED] Run-time error '91': Object variable or With block variable not set when closing userform
    By bishoposiris in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-10-2016, 08:59 AM
  3. combining chart userform and data transfer userform into 1 userform
    By H_Kennedy in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-04-2014, 07:11 AM
  4. combining chart userform and data transfer userform into 1 userform
    By H_Kennedy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-03-2014, 12:28 PM
  5. [SOLVED] Transfer Text from one userform to another userform
    By Orestees in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-31-2012, 06:16 PM
  6. [SOLVED] Userform to transfer data to another userform
    By Oeysbrei in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-19-2012, 04:46 PM
  7. Transfer a variable
    By Josh_123456 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-22-2006, 12:37 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1