Can I know how to use If, Then, Else command

[Guest_imported]

For eg, I want to
If WoodType="mahogany" then
....
is this the correct way to compare string

 

[JohnYingling]

you can StrComp for strings. Watch out for case e.g.
"mahogany" not = "Mahogany"
if LCase$(strWoodType) = "mahogany"
if 0 = Strcomp(strWoodType,"mahogany",vbTectCompare) ' case insensitive

Yes, Lcase$, Left$, Right$ etc are faster rhan LCase, Left, Right etc.

http://WWW.VBCompare.Com

 

[JohnYingling]

Forgot this was a VBScript question so forget the $. All variables are sub-type of Variants.

http://WWW.VBCompare.Com

 

[avivit]

In general:

If WoodType="mahogany" then
msgBox("good match&quot
else
msgBox("no match&quot
end if