Results 1 to 9 of 9

Application Worksheet Function Error

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-11-2009
    Location
    NYC,USA
    MS-Off Ver
    Excel 2007
    Posts
    135

    Thumbs up Application Worksheet Function Error

    HI folks,

    I’ve created a small user form to convert food measurements.
    My problem is the code is bugging out at the Function I made to do the calculations

    I receive :
    “Runtime Error 1004”
    Unable to get the Match Property of the Worksheet Function Class”

    This is the function code.
    You may want to explore the file to see if I ‘ve it set up incorrectly.

    Function ConvertCalc1()
      If OptionButton2.Value = True Then
    TextBox2.Value = TextBox1.Value * Application.WorksheetFunction.Index("VOLUMN_Table", Application.WorksheetFunction.Match(ComboBox1.Value, "VOLUMN_ROWS", 0), _
    Application.WorksheetFunction.Match(ComboBox2.Value, "VOLUMN_COLUMNS", 0))
      Else
    TextBox2.Value = TextBox1.Value * Application.WorksheetFunction.Index("WEIGHT_Table", Application.WorksheetFunction.Match(ComboBox1.Value, "WEIGHT_ROWS", 0), _
    Application.WorksheetFunction.Match(ComboBox2.Value, "WEIGHT_COLUMNS", 0))
    
    End If
    End Function

    I’ve included the workbook to more clearly illustrate the problem.

    Thanks !

    Mark
    Attached Files Attached Files
    Last edited by max57; 02-22-2010 at 09:26 AM.

Thread Information

Users Browsing this Thread

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

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