vba help - option compare text vs dictionary compare text

[Mallesh23]

Hi Team,

Can we use option compare text at top of module, instead writing dictionary compare text

Option Compare Text
Sub Dictionary_Compare()

    Dim dict As New Scripting.Dictionary
    
    With dict
       ' .CompareMode = 1 ' Macro gives output if I add this line
        'Option Compare Text .. doesn't working for converting Compare mode, where it is used.
        .Add Range("a2").Value, Range("b2").Value
        Range("E2").Value = .Item(Range("D2").Value)
    End With
End Sub

Below is sample data.

Book11
	A	B	C	D	E
1	Fruit	Cost		Key	Items
2	Apple	5000		APPLE	5000
3
4	Lower Case Key here			Upper case Key here
Sheet1

Thanks
mg

 

[Fluff]

Yes you can, however putting Option Compare Text at the top of the module will affect all code in that module, rather than just the dictionary.

 

[Mallesh23]

Hi Fluff,

Thanks for confirmation, as I was not sure on this. ?

Thanks
mg

 

[Fluff]

You're welcome.