Good morning, J-
My apologies for not responding sooner: I access newsgroups using
Google groups, and they must have changed the way they store or present
data: I couldn't locate this post (despite a fairly arduous search).
But now apparently they've changed back to the earlier format, so I was
able to find it.

Here's an idea that may work: some additional code that prompts the
user to enter his preferred decimal format, and stores that in a Named
Range in the workbook. Then allow the user to enter numbers as usual,
but provide some data validation within the code that checks to see if
he has entered a period or comma, and then makes the entry using the
preferred decimal format- irrespective of whether he has entered a
comma or a period in the input box.

This method may require you to change the data type of the previously
declared variable that handles the input, but seems workable.

Could that work for you?
Dave O