09-01-2014, 04:44 PM
The code is fine..You need to do typecasting before using the if block.
You can take reference of below
You can take reference of below
Code:
RoProDesc=FormatCurrency(RoProDesc,0)
msgbox RoProDesc