Link to home
Start Free TrialLog in
Avatar of Issa S.
Issa S.

asked on

Seeking help in a VBA Function code.

Seeking help in a VBA Function code.

I got the attached code from some where on the net but giving compiler error when I put it in a Module to create a Public Function.

I am not expert in VBA, but I can mange with some help.

A related question :
             Why non-English characters became "??????"  when loaded into the Module   ?!

Thanks a lot
Number-Wording.txt
SOLUTION
Avatar of Rgonzo1971
Rgonzo1971

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Issa S.
Issa S.

ASKER

Dears,,,

Syntax wise it is working.
Now I only see garbled text in the Worded box as in the attached:
It seems that am missing something in between related to the Language set up although I checked it to my best.
User generated image
The question marks are not garbled text, they exist in the code as question marks.
As I mentioned previously, if the keyboard language is set to English, when you copy the code it will change the characters not existent in English to question marks.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Issa S.

ASKER

Dear MacroShadow,,,

Believe me I followed your instructions literally before.
I found the problem was that I did not have UNCODE supported on my Win.
So, modified it and redone.
Perfectly.
Many Thanks for your patience  and help.
User generated image
Avatar of Issa S.

ASKER

Great good job.
Many Thanks.
Avatar of Issa S.

ASKER

*   UNICODE
Welcome, glad you got it sorted out.


»bp
Avatar of Issa S.

ASKER

Dear Bill,,,

Pls take note that :

Using NoToTxt2(...) is more general.
It enables you to specify any kind of  Foreign Language, as long as that Language is added in your Windows.
So it is more general and very strong. This was made by some Egyptians who work is the Gulf Countries. 
Try It .

But I must admit that I wouldn't be able to do it without your help.
Thanks a Lot.