Explanation for Option Compare Text .. etc

[omarswan]

could someone please explain what are these and what is there main purpose. And also is there anymore like these.

Option Explicit
Option Compare Text



------------------
OmarSwan

omarswan@yahoo.com

http://omarswan.cjb.net (http://www.omarswan.cjb.net)

"Jesus is Lord"

[Mark Sreeves]

Option Compare statement sets the default string comparison method.

Set the string comparison method to Binary.
Option compare Binary That is, "AAA" is less than "aaa".
' Set the string comparison method to Text.
Option compare Text That is, "AAA" is equal to "aaa".


Option Explicit forces you to declare variables and in my opintion this should ALWAYS be used

this id put in automativcaly if you check
"Force Variable Declaration" from Tool -> Options menu


Option private Module Indicates that module is private.

Option base 1 Set default array subscripts to 1.


take a look in the vb help files for more info!

------------------
Mark Sreeves
Analyst Programmer

Mark.Sreeves@Softlab.co.uk
A BMW Group Company