The information in this article applies to:
SYMPTOMSIn Microsoft Excel 97, when you call a Microsoft Visual Basic for Applications custom function in a cell, you may receive the #VALUE! error value. CAUSEThis problem may occur when the following conditions are true:
WORKAROUNDTo work around this problem, rearrange the order of the comparisons in the Select Case statements, so that all alphanumeric text or string comparisons to the test expression occur first, and then all numeric value comparisons to the test expression occur. STATUSMicrosoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. MORE INFORMATIONMicrosoft provides programming examples for illustration only, without warranty
either expressed or implied, including, but not limited to, the implied warranties of
merchantability and/or fitness for a particular purpose. This article assumes that you
are familiar with the programming language being demonstrated and the tools used to
create and debug procedures. Microsoft support professionals can help explain the functionality
of a particular procedure, but they will not modify these examples to provide added
functionality or construct procedures to meet your specific needs. If you have limited
programming experience, you may want to contact a Microsoft Certified Solution Provider
or the Microsoft fee-based consulting line at (800) 936-5200. For more information about
Microsoft Certified Solution Providers, please see the following page on the World Wide Web:
http://www.microsoft.com/mcsp/For more information about the support options available from Microsoft, please see the following page on the World Wide Web: http://www.microsoft.com/support/supportnet/overview/overview.aspFor example, the user-defined function UnitPrice requires an argument Model. The Select Case statement compares the value of Model with 60 and then 100. If it finds no match, the Select Case statement continues and compares Model with the text strings. The first text string is "200S". If you type =UNITPRICE("200S") in a cell, you would expect to see the value 243 returned, but the result of UnitPrice is #VALUE!.
To resolve this error, change the order of all the comparisons of the Select Case statement so that it compares the text strings first. See the following correction to the UnitPrice function:
Additional query words: XL2000 XL97 vba
Keywords : kbdta kbdtacode OffVBA KbVBA |
Last Reviewed: September 22, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |