LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel
external usenet poster
 
Posts: 3,986
Default displaying input data on user form as currency

I might have been a little hasty in the example I gave you. At any rate, you
will need to use the Format function to convert your value to the currency
format prior to entering it into the TextBox. I don't believe Excel supports
formatting the TextBox itself to display values as currency.

"mantrid" wrote:

Hello
Im trying to find a property or a way to format a text box on a user form to
show as currency when input. Can't seem to find how to do this anywhere.
Can anyone help
Thanks
Ian



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Displaying data in user form from active worksheet Barb Reinhardt Excel Programming 3 October 16th 06 04:20 PM
How do I create a User form to input Data into an Ecel spreadsheet JohannM Excel Programming 1 September 7th 06 05:25 PM
displaying the user form data cyzax7 via OfficeKB.com Excel Programming 3 June 12th 06 01:49 AM
Currency format for combo box in a user form Jennifer Excel Programming 4 April 16th 05 06:16 AM
Data Input - User Form Drop-Down Box meflorence[_3_] Excel Programming 2 May 18th 04 02:43 PM


All times are GMT +1. The time now is 04:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"