Application Worksheet Function Error

**max57** · 02-21-2010, 05:48 PM

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.

Please Login or Register  to view this content.

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

Thanks !

Mark

**tony h** · 02-21-2010, 07:42 PM

The second parameter of the Match function is either a range or an array. You have a string

**Huron** · 02-21-2010, 08:06 PM

Hi Mark

As an alternative to your approach, you could look at the Excel CONVERT function. See the attached file for an example.

**max57** · 02-21-2010, 08:25 PM

Hi tony h,

I had a feeling it had to do with that also.

My question is how do I correct this?

I dimmed variables as ranges and tried to set "WEIGHT_Table"( and the rest) to the Worksheet ("Sheet2") range.
But no go.

I'm kind of burnt out on where to go with this.
Any suggestions?

Thanks

Mark

**max57** · 02-21-2010, 08:31 PM

HI Huron,

That's a nice alternative, but I was looking to correct the user form code to do the converting.

Thanks
Mark

**jeffreybrown** · 02-21-2010, 08:36 PM

Hi Mark,

Maybe this could be another option...

http://www.mediafire.com/?mzmzou2ezug

**max57** · 02-21-2010, 08:38 PM

Huron,

The CONVERT function, is this something I can use in VBA Code?

**max57** · 02-21-2010, 08:43 PM

Rocky1,

Thanks for the suggestion. I've seen this utility before and have used it on many occasions.

What I need is just a simple little form to insert into a larger project I'm working on.

This form will pop up when needed to allow a student to make conversions to the recipe ingredients that they will be costing out. I'm almost there but I've just got to work around the code problem.

Mark

**max57** · 02-22-2010, 09:24 AM

Hi,
Uisng tony h's advice, I went back and corrected the problem.

I rewrote the Function code as a Sub and fixed the range references.
Here is the code :

Please Login or Register  to view this content.

Thanks for all the suggestions

Mark

Application Worksheet Function Error

LinkBack

Thread Tools

Rate This Thread

Display

Application Worksheet Function Error

Re: Application Worksheet Function Error

Re: Application Worksheet Function Error

Re: Application Worksheet Function Error

Re: Application Worksheet Function Error

Re: Application Worksheet Function Error

Re: Application Worksheet Function Error

Re: Application Worksheet Function Error

Re: Application Worksheet Function Error

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions