+ Reply to Thread
Results 1 to 4 of 4

Passing values to a second user form.

  1. #1
    Registered User
    Join Date
    08-27-2014
    Location
    Albany, NY
    MS-Off Ver
    Office 2010
    Posts
    91

    Angry Passing values to a second user form.

    I can't even comprehend how to attack this so I wanted to put it out there and see if something sparks.

    I have a user form that dynamically pulls row values based on a users comboBox selection. and I have set a section for user notes based on the dynamic row value and places it in column L. Of course it works awesome and the variables all sync well...however my boss now wants the notes to pop up on a second user form when the user click "Update" (ok no problem, 2nd user form piece of cake), but the row is dynamically named in userform one, how can I pass that to the note's text box in Userform two and keep the variables true...am I a block head?

    Userform 1
    Please Login or Register  to view this content.
    Master List v2.63.xls

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Passing values to a second user form.

    You will need to publicly declare the variables and then in the UserFrom2_Initialize populate your textbox using said variable.

    Example:
    Please Login or Register  to view this content.

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,281

    Re: Passing values to a second user form.

    Hi Coleman,

    I'm pretty lazy and always try to use a non vba solution first. Have you ever heard of or seen the Excel (built in) Form tool? You can add the icon for it on the Quick Access Toolbar and use it instead of your form. See:
    http://office.microsoft.com/en-us/ex...010236698.aspx

    Now - if you really need the dropdown to select a certain record, I'd grab the Enhanced Forms Tool off the site:
    http://spreadsheetpage.com/index.php/dataform/home - pay to see the code and see if you can modify it for your non-commercial use.

    Then I'd have a small talk with your boss on how to use standard tools instead of having you create unique ones.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  4. #4
    Registered User
    Join Date
    08-27-2014
    Location
    Albany, NY
    MS-Off Ver
    Office 2010
    Posts
    91

    Re: Passing values to a second user form.

    Simplicity in work is always overlooked. I will see what I can talk my boss in to/out of.

+ 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. [SOLVED] User Form to execute search and return all values to the user form for editing
    By allwrighty in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-11-2013, 10:40 PM
  2. Passing Values from User Form
    By srinivassurapareddi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-28-2012, 01:49 PM
  3. Passing inputs from one user form to another
    By daymaker in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-18-2011, 11:02 AM
  4. Passing variables from sub to user form
    By boc_est1986 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-18-2009, 09:09 AM
  5. User Form value passing problem
    By brusk2@uiuc.edu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-09-2006, 12:24 PM

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