Wayne, I have not read the thread, but I give Thomas an additional like on your behalf.

Don't like too soon

I'm wondering why the first formula assignment doesn't fail on my system...?

Sub Test()
    Dim shp As Shape
    Set shp = ActiveWindow.Selection.PrimaryItem
   
    shp.Cells("Width").Formula = "HEIGHT*1.5" ' Works, but why?
    shp.Cells("Width").Formula = "HEIGHT*2,5" ' Works as expected
    shp.Cells("Width").FormulaU = "HEIGHT*3.5" ' Works as expected
    'shp.Cells("Width").FormulaU = "HEIGHT*4,5" ' Fails as expected
   
    Debug.Print "Formula: " & shp.Cells("Width").Formula ' -> Formula: Height*3,5
    Debug.Print "FormulaU: " & shp.Cells("Width").FormulaU ' -> FormulaU: Height*3.5
End Sub


Oh yes that localisation issue. I so often stumble in it.
I used to use replace formulas to replace commas by dots and vice versa.

I wonder if a generic approach - no I don't wonder, it is needed - would overcome the issue

There could either be some prior test and store the right method in some global variable.

Or one would write an assignement function with error handling, à la assign Value, if fail try other method.

If aluminum can be transparent, then I suppose mud can be clear...or not.

Here's M$ explanation of local vs universal:  https://learn.microsoft.com/en-us/office/vba/api/visio.cell.formulau.

Pretty long.

Rrrright, why anyone would want the metric system, when you can measure stuff in inches and pounds

There are exactly three countries out of 200 that did not adopt metric ISO - Liberia, Myanmar, and the United States 

Quote from: Nikolay on August 08, 2024, 08:32:28 AMThere are exactly three countries out of 200 that did not adopt metric ISO

WOW!!! 
Even the UK and Australia have accepted?

Here's interesting article re history of imperial vs metric...focusing on the historical development in the US.  It makes interesting reading, but I have not verified its correctness.  https://science.howstuffworks.com/why-us-not-on-metric-system.htm#:~:text=Only%20three%20countries%20in%20the,contexts%20%5BSource%3A%20McQuillan%5D.

I do recall that the more recent debate between adopting imperial vs metric had key elements of:  cost of conversion, ingrained common knowledge of how much something is, e.g., mile vs kmeter, quart vs liter, etc.  Also, some, uh, arrogant pride. 

Personally, Imperial is "reflex", default.  I can visualize a 1/16" vs 1/32" vs 1/8" as opposed to 4mm vs 3mm vs 5mm.  Why???  Fundamentally, things are ratio of 2's.  Quite easy to say something is 1/2 or 2x larger.  But, metric is 10's based.  So, is it 30% or 40% or 50%.  But, that's me.

As this is a Visio centric site, then perhaps a visual presentation is in order...World Map