Convert TextBox value to Currency

Hi All

I have the following snippet of code I need assistance with. I am trying to get ws.Range("F9") to display R652000.00
and have the availability of calculating commissions from this value without faulting as it reads value as string.

Please Login or Register  to view this content.

This formula renders an incorrect answer after the sheet is populated

Formula:

Please Login or Register  to view this content.

Any help please.

I had a cross post which I marked as solved in Formula section thinking it was the formula....
https://www.excelforum.com/excel-for...ml#post4665855

Hi Sintek

Please Login or Register  to view this content.

Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee

Hi leelnich

thanks for your response...
tried but no avail....Still converts to custom and errors formula

Decided just to go numbers throughout....No currency...

I'm surprised, that Cell number format displayed the NUMBER 652000.00 as R652,000.00 perfectly. Sorry we couldn't find a solution. Take care-Lee