royUK based on post#3 it shows $ not LYD . despite of that you use function native cuurency .
what's the problem ?
What is the your native currency?
I selected it this when search my native currency from cell format > cuurency
Also, as I said this is the format your code is set for - #,##0.00.
That works very inefficiently and it causes an error in the userform
I thought it's possible by vba !