Is there a way in VBA for Excel to make uppercase letters equivalent to lowercase ones
Otherwise, comparing strings of the same letters but different capitalization results in no match
Thanks,
Antonio
uppercase and lowercase letters made equivalent
Hot Topic
- print out to .pdf or calling a macro with parameter
- enabling controls at runtime
- Subform Problem
- How to read directory information into a combobox.
- Problems with DAO and SQL Server
- Closeing shared files
- AutoResize Merged Cells
- Import CSV Files into SQL Server 2000 Table from VB Net
- S
- getting web pages from VBA?
Microsoft ISV
- what SRTP crypto algorithm used?
- Someone mind helping me with Error 426
- Go-Live for alpha/beta programs as well?
- Output property to save as
- Using VBA to download a file using FTP
- Simple question on FrontPage / Internet Explorer
- Problem with Microsoft CRM 3.0 Outlook Client
- Hyper link Macro
- "Building Custom Report Views Webpart"
- MSDN Subscription special $375.00 ?????
uppercase and lowercase letters made equivalent
aLee89
Hi Derek, thank you for your clarification. I suspected that.
To apply your suggestion I guess that the UCase function is probably the best way to go.
Regards,
Antonio
Support
sohman
no, character's A and a have completely different ASCII code/Unicode values. The compare method generally has a parameter to ignore case but VBA doesn't have that option. All I can suggest is create uppercase or lowercase copies of the string and compare the copies rather than the originals.