The information in this article applies to:
SYMPTOMSIn Microsoft Visual Basic Programming System, Applications Edition, if you pass an argument to a subroutine and the argument data type does not match the parameter data type defined in the subroutine, you receive the following error message:
MORE INFORMATION
Variant is a special data type that can contain any kind of data. You can
determine how the data in a Variant is treated using the VarType or
TypeName function. When you declare a variable as Variant data type, you
can change the data type of the variable within a procedure. If the
contents of a Variant variable are digits, they may be either the string
representation of the digits or their actual value, depending on the
context.
Visual Basic ExampleWhen you run the procedure Run_Test below in a Visual Basic module in Microsoft Excel version 5.0, you receive the error message described above:
WORKAROUND
To avoid receiving this error message when you pass a variable to a
subroutine, you must define the variable you are passing to the subroutine
to be the same data type as the subroutine parameter.
Example 1
Example 2
Microsoft provides examples of Visual Basic procedures 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 Visual Basic procedure is provided 'as is' and
Microsoft does not guarantee that it can be used in all situations.
Microsoft does not support modifications of this procedure to suit customer
requirements for a particular purpose. Note that a line that is preceded by
an apostrophe introduces a comment in the code--comments are provided to
explain what the code is doing at a particular point in the procedure. Note
also that an underscore character (_) indicates that code continues from
one line to the next. You can type lines that contain this character as one
logical line or you can divide the lines of code and include the line
continuation character. For more information about Visual Basic for
Applications programming style, see the "Programming Style in This Manual"
section in the "Document Conventions" section of the "Visual Basic User's
Guide."
REFERENCESFor more information about the Dim statement, choose the Search button in the Visual Basic Reference and type: Dim Additional query words: err msg
Keywords : |
Last Reviewed: October 21, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |