Custom Function display error in Excel 365

Kmeid
NewLounger
Posts: 1
Joined: 22 Jul 2024, 09:52

Custom Function display error in Excel 365

Post by Kmeid »

Hi

In Excel 365, I created a custom Function to convert numbers to Arabic letters, the function is working fine in the VBA debug window, but when I use the function inside the worksheet it displays strange characters. I tried to change many fonts, repaired office installation, change windows regional settings all trials are in vain
Any Clue?!
This is the result in Excel sheet
Screenshot 2024-07-22 123403.png
and this in VBA debug window
Screenshot 2024-07-22 123508.png
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 79321
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Custom Function display error in Excel 365

Post by HansV »

Welcome to Eileen's Lounge!

Could you attach a small sample workbook with the code?
I'm not sure that I can help you, but we have some active members who use Arabic.
Best wishes,
Hans