+ Reply to Thread
Results 1 to 2 of 2

Use of commonvariables if you have 2 exact the same userforms data

  1. #1
    Forum Contributor
    Join Date
    10-18-2018
    Location
    Amsterdam, Holland
    MS-Off Ver
    2013
    Posts
    104

    Use of commonvariables if you have 2 exact the same userforms data

    Hi all,

    See attachement.

    When you add an "x" in column E a userform (production returns) opens.
    On this userform there is a code and productname. If you press on Info a new userform opens with on that the same code and productname.

    When you add an "x" in column F a userform (QA returns) opens.
    On this userform there is a code and productname. If you press on Info a new userform opens with on that the same code and productname. Only on this userform it doesn't work. It doesn't display the same code and productname as on the QA returns userform.

    I guess it's because of this;

    Please Login or Register  to view this content.
    Cause the caption gets data from two commonvariables.
    How can i tell that it should look to where it comes from (QA returns or production returns) and then use the right commonVariable and ignore the other?
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    10-18-2018
    Location
    Amsterdam, Holland
    MS-Off Ver
    2013
    Posts
    104

    Re: Use of commonvariables if you have 2 exact the same userforms data

    It's fixed.

    Skipped the use of Variables and assigned the values directly.

+ 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] Find exact text in exact cell but on any sheet?
    By nobodyukno in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-12-2017, 02:59 PM
  2. Replies: 4
    Last Post: 01-06-2015, 09:15 PM
  3. To Sort exact and partial exact match for a single column.
    By Jagdev in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-22-2014, 05:08 AM
  4. Formula to work out an exact average over an exact number
    By Sandyshirl in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-11-2013, 01:35 AM
  5. Replies: 4
    Last Post: 11-12-2010, 01:01 AM
  6. Data Validation in Userforms
    By alexa in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-29-2006, 08:12 AM
  7. Data Validation on UserForms
    By SailFL in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-19-2005, 05:05 AM

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