VBS EXCEL PLUGIN SEARCH TEXT BOX TO WORK WITHOUT CASE SENSITIVITY
Summary: Dont want search text box to be case sensitive
Content (please ensure you mask any confidential information):
We have a requirement where the search text box is to be configured because that supports All operators but LOV supports only equal and not equal, since LOV supports equal and not equal the bulk search becomes difficult, the requirement is to have text box behave like non case sensitive, for eg: Upper(claimAssignedTo)=Upper(SearchTerm.Value) but how to actually implement this please suggest.
someway so that if I enter ClaimAssignedTo = Mj or mj, it should work.
Version (include the version you are using, if applicable):
0