Currency format for combo box in a user form
I tried this and I am getting a yellow error line:
1st: I miss spoke it is a text box
2nd: I put the following in the UserForm Initialize syntax, is this correct?
Me.txtPrice.Value = FormatCurrency(Me.txtPrice, 0)
"Kro" wrote:
Try this:
comboboxname.value=FormatCurrency(conboboxname,0)
"Jennifer" wrote:
Hi,
I have a combo box on a user form and when someone types the price, say 60 I
want it to be displayed as $60.00 not 60. Can anyone help? Thank you in
advance.
--
Though daily learning, I LOVE EXCEL!
Jennifer
|