Ana has attended:
Excel VBA Intro Intermediate course
Currency display after running a macro
I have been running the VBA training file (sales macro file) created in 2003 in another pc with 2010 software. The dealer price, sales price and mark up have the £ symbol dissapear and the commision is in $. Is there any currency compatabilities between 2003 and 2010 or is it the macro written wrongly?
thanks
RE: currency display after running a macro
Hello Ana,
There is no issue between the versions, on the file you are using I don't think we wrote the format of currency in the code. To ensure correct display you need to code the format, and not expect it to pick up the format from the current cells.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Mark
Microsoft Office Specialist Trainer