I am using the module provided by Chip on his site for colour
functions.
See http://www.cpearson.com/Excel/colors.aspx
Its really helpfull for biginners like us.

Recently while going thru the code, I noticed "Option Compare Text"
on the top of the mudule.

Can somebody please explain what it signifies and when or in what
situation it can be used/can not be used.

Regards,
Madiya.

There is a very useful facility in the VBIDE called help. Try it.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Madiya" <(E-Mail Removed)> wrote in message
news:99231868-452e-4924-a822-(E-Mail Removed)...
>I am using the module provided by Chip on his site for colour
> functions.
> See http://www.cpearson.com/Excel/colors.aspx
> Its really helpfull for biginners like us.
>
> Recently while going thru the code, I noticed "Option Compare Text"
> on the top of the mudule.
>
> Can somebody please explain what it signifies and when or in what
> situation it can be used/can not be used.
>
> Regards,
> Madiya.

hi
in vb help, type "Option compare text". look at the option compare statement.

Regards
FSt1

"Madiya" wrote:

> I am using the module provided by Chip on his site for colour
> functions.
> See http://www.cpearson.com/Excel/colors.aspx
> Its really helpfull for biginners like us.
>
> Recently while going thru the code, I noticed "Option Compare Text"
> on the top of the mudule.
>
> Can somebody please explain what it signifies and when or in what
> situation it can be used/can not be used.
>
> Regards,
> Madiya.
>

On Jun 10, 6:22*pm, FSt1 <F...@discussions.microsoft.com> wrote:
> hi
> in vb help, type "Option compare text". look at the option compare statement.
>
> Regards
> FSt1
>
>
>
> "Madiya" wrote:
> > I am using the module provided by Chip on his site for colour
> > functions.
> > Seehttp://www.cpearson.com/Excel/colors.aspx
> > Its really helpfull for biginners like us.
>
> > Recently while going thru the code, I noticed "Option Compare Text"
> > on the top of the mudule.
>
> > Can *somebody please explain what it signifies and when or in what
> > situation it can be used/can not be used.
>
> > Regards,
> > Madiya.- Hide quoted text -
>
> - Show quoted text -

Yes. Got it.
Thanks.
I should have looked at IDE help before posting.
Sorry to bother you all.

Regards,
Madiya