View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jennifer Jennifer is offline
external usenet poster
 
Posts: 385
Default 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