Periods versus comma's in VBA conditional formatting formulas

Hi,
My Windows country settings use a comma for decimal separation and a period for thousand separation.

When I use this code in VBA:

Please Login or Register  to view this content.

I use a period in VBA. In excel translates it as =0,9

However, when I use this code:

Please Login or Register  to view this content.

I have to use a comma, or I will get a run-time error '5' : "Invalid procedure, call or argument"

How can I make my workbook work in European AND US settings in Windows?

Thanks for helping me out here...

Just yesterday I came across this:

Please Login or Register  to view this content.

Would that work? I have not looked into it any further though.

Thanks AlphaFrog,

Your solution works perfectly!

Thanks for your reply Jolivanes,
FormulaLocal seems to work with normal formula's, but not with conditional formatting formulas.
They seem to be quite unique...

ArnolddG
Thanks for the update.
Like I mentioned, I had not used it but for me it is something to keep in mind for future use.
Good luck.
John