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

Hope I'm getting this right. Sounds like you are look for Enums?

http://www.cpearson.com/excel/Enums.htm


HTH,
JP

On Nov 13, 4:12 pm, "Ronald Dodge" <ronald.do...@sonoco.com> wrote:
> 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

That did it. Thank you.

--

Sincerely,

Ronald R. Dodge, Jr.
Master MOUS 2000

"JP" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hope I'm getting this right. Sounds like you are look for Enums?
>
> http://www.cpearson.com/excel/Enums.htm
>
>
> HTH,
> JP
>
> On Nov 13, 4:12 pm, "Ronald Dodge" <ronald.do...@sonoco.com> wrote:
>> 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
>
>

Glad to help!

--JP

On Nov 13, 4:49 pm, "Ronald Dodge" <ronald.do...@sonoco.com> wrote:
> That did it. Thank you.
>
> --
>
> Sincerely,
>
> Ronald R. Dodge, Jr.
> Master MOUS 2000
>
> "JP" <jp...@sterlingtesting.com> wrote in message
>
> news:(E-Mail Removed)...
>
>
>
> > Hope I'm getting this right. Sounds like you are look for Enums?
>
> >http://www.cpearson.com/excel/Enums.htm
>
> > HTH,
> > JP
>
> > On Nov 13, 4:12 pm, "Ronald Dodge" <ronald.do...@sonoco.com> wrote:
> >> 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- Hide quoted text -
>
> - Show quoted text -