Searching

[nollaig]

Ok so I've got this code:

If txtsearch.Value = Range("B2").Value Then
Range("B2").Select
Sheet1.Activate
frmuser1.Hide
frmuser.Hide
End If

If txtsearch was not in the same case as Range("B2"), is there anyway for them to be made equal?

[Leith Ross]

Hello Nollaig,

To make a case insensitive comparison you can convert both strings to either upper case or lower case by using UCase(String) or LCase(String) operators.

Example:

If LCase(txtsearch.Value) = LCase(Range("B2").Value) Then

Hope this answers your question,
Leith Ross