Results 1 to 21 of 21

Match function is malfunctining if variable is used as arg1

Threaded View

  1. #9
    Forum Contributor
    Join Date
    01-18-2013
    Location
    Prague, Czech rep.
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    138

    Re: Match function is malfunctining if variable is used as arg1

    :-D yeah i can imagine, should have posted a little manual with it, sorry guys:

    here is the thing, if you click the first button which is copied there i believe twice, it triggers the first menu, where you select desired fields for the headers, than send it, you get another userform where there is only the list you´ve chosen, you can click through all of it to select proper formating and order of the fields (if you click lets say "tituly" another userform pops up - this one populates the global variables; here you select at what place the header should be and with what format and click "OK" this sets the variables and paste the value in cells - that paste is just for now since im not able to execute the code I´d love to as mentioned above) and that´s it.....just when you have set all the fields dont send the remaining userform or you get another error cause it goes to word app and does some more tricks there.....the thing is in the last sheet ("krit") there is the outcome of the users choice

    EDIT: if you´re looking at the end of the code of setting those variables there are few if´s those are there first to copy the values at proper cell and the match function is there to prevent repetition (when for example you´ve set the format and then decide to change it, so that was my try on correcting the outcome in the field) but since the match is not working i´m unable to decide if there is already an entry with defined value or not.

    EDIT2: just to say where my issue pops up, its at the part where you try to set first set of variables (frm_order - userform; when you try to send it with OK it fails on the match function which is checking the repetition as explained above) - that´s for the sample i´ve provided

    also another thing i wanted to say: at first fill up its empty (the columns to search within) so i thought it fails on null and therefore i made a errhandling routine to get over it and to be able to record outcomes in debut.print and so even after i had some values to go through for the match function it still didnt work and only 0 were recorded (which signinfies "no match" result)
    Last edited by SoulPrisoner; 09-03-2013 at 09:11 AM. Reason: Additional info

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] MATCH function with a variable as lookup_value?
    By mccalle in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-23-2013, 07:37 AM
  2. Adding a variable to index & match function using VBA
    By prestopr in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-07-2013, 05:48 PM
  3. Replies: 2
    Last Post: 11-05-2011, 03:26 PM
  4. Specifying Arguments in Run ([Macro], [arg1],[arg2]...)
    By Kaigi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-09-2010, 06:35 PM
  5. Using Match function output as a variable
    By iii in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-28-2009, 06:01 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