I am interested in knowing if there is a way in VBa to switch the Decimal
Symbol from the "." to the "," on the fly. For example if the text in B2
was "English" then I would want the Decimal Symbol to be recognized as the
period, but if the text was "French" then the decimal symbol would be the
comma.

Any advice? My goal is to avoid having to switch the regional settings.

Thanks in advance for thinking about it.