I would like to know how can I type constants to a particular argument in
methods similar to like how the constants below are tied to the last
argument of the InStr function:

vbBinaryCompare
vbDatabaseCompare
vbTextCompare

I have a method within VBA that I would love to be able to do the same thing
with, rather than having to put constants in a separate location or having
to hard code the values.

--

Sincerely,

Ronald R. Dodge, Jr.
Master MOUS 2000