Thread: Currency format for combo box in a user form
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Kro Kro is offline
external usenet poster
  
Posts: 7
Default Currency format for combo box in a user form
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
Reply With QuoteReply With Quote