View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike[_60_] Mike[_60_] is offline
external usenet poster
 
Posts: 6
Default Textbox number formatting

Hello all,

I'm working on a VB UI in Excel and I'm wondering if
there is some VB code that I can use on exit of textbox
fields to change the user-entered numbers into currency
format (for example: the user enters 1000000 and tabbing
out of the field the number is replaced with
$1,000,000.00). I can't seem to remember any of the code
to convert the numbers...

Thanks in advance and have a great day,

Mike