VBA Search Functionality Issue with Arabic Supplier Names in Excel
I have a VBA coding in Excel that searches for a supplier or invoice number in a sheet. It returns results when the supplier name is entered in English, but it shows "no match found" when the name is in Arabic.
following is the Code
Please Login or Register to view this content.
Last edited by AliGW; 12-15-2024 at 04:31 AM. Reason: Code tags added - please review the forum guidelines.
Post some sample excel file (with dummy data) to test your code.
Thank you so much
Last edited by malikusmanlai.awan; 12-19-2024 at 05:16 AM.
If you have any confidential and/or personal data in your data file, break the link to this file as soon as possible and insert it again with fictitious/false/dummy data, but corresponding to their true arrangement in the spreadsheet - there is no need to include a file as large as 1 MB, a few dozen lines of data will be enough ...... so please use the forum's attachment option (yellow banner above).
hi please now find the attchemnt as per your reply.
Last edited by malikusmanlai.awan; 12-19-2024 at 05:17 AM.
When you fetch the value you are looking for into a variable, try using the Application.InputBox method instead of the VBA.InputBox function.
Artik
The newest version of Excel has a function 'TRANSLATE' maybe that can be of help.
Last edited by popipipo; 12-16-2024 at 11:33 AM.
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
Artik thank you so much. your sugesstion works. i amended the code and giving best results.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks