Application Worksheet Function Error

Hi Mark

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

HI Huron,

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

Thanks
Mark

Hi Mark,

Maybe this could be another option...

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

Huron,

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

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

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 :

Sub ConvertCalc1()

    If OptionButton2.Value = True Then
        TextBox2.Value = TextBox1.Value * _
        (Application.WorksheetFunction.Index([VOLUMN_Table], Application.WorksheetFunction.Match(ComboBox1, [VOLUMN_ROWS], 0), _
        Application.WorksheetFunction.Match(ComboBox2, [VOLUMN_COLUMNS], 0)))

    Else
        TextBox2.Value = TextBox1.Value * _
        (Application.WorksheetFunction.Index([WEIGHT_Table], Application.WorksheetFunction.Match(ComboBox1, [WEIGHT_ROWS], 0), _
        Application.WorksheetFunction.Match(ComboBox2, [WEIGHT_COLUMNS], 0)))
 
   End If


End Sub

Thanks for all the suggestions

Mark