Help with Currency Format in Userform

[eddyrcabrera79]

Hi,

I have 2 listboxes, when I click on the serviceslistbox it will transfer as many services required to the Requiredserviceslistbox, and at the same time it will calculate the Total of the services in the Totaltextbox.

I'm having problem with the currency format, if for example the total amount is $80.00 it will display $00.80 or if the total amount is $100.00 it will display $01.00. How can this be fix in order to see the right amount in the Totaltextbox.

Please see attachment

 

[Stevie]

Hi eddy,
change this line:

TotalTextBox = Format(myVal2 / 100, "$00.00")

to:

TotalTextBox = Format(myVal2, "$00.00")

in
Private Sub ServicesListBox_Click()
within the code of your userform.
---
If this was helpful, please click like!

 

[eddyrcabrera79]

thx Stevie it worked perfect. Thz so much