#1   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Userform Formating

How about:
TextBoxFV_BOY.value = format(Sheets("Input").Range("I7").Value, "$#,##0")
or
TextBoxFV_BOY.value = Sheets("Input").Range("I7").text
(if the cell is nicely formatted)

Jeff wrote:

Hi,

I want an Input Box to output the value of other inputs in the form, and the
output is in dollars so I tried

in the Click event
TextBoxFV_BOY = Sheets("Input").Range("I7").Value
TextBoxFV_BOY.NumberFormat = "$#,##0"

But this did not work,
Does anyone know how to do this?

Thanks for your help


--

Dave Peterson
Reply
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
userform that add data in all w/sheets tkraju via OfficeKB.com Excel Discussion (Misc queries) 0 March 24th 06 04:29 AM
Conditional formating using formulas arifnj Excel Worksheet Functions 4 October 27th 05 01:56 PM
Data Validation Cell - Move to UserForm thom hoyle Excel Worksheet Functions 0 April 28th 05 12:23 AM
Cell Content from UserForm Not Retained D.Parker Excel Discussion (Misc queries) 3 April 27th 05 04:56 PM
How can I run a macro in the background whilst a UserForm is visib cdb Excel Discussion (Misc queries) 3 February 10th 05 06:58 PM


All times are GMT +1. The time now is 04:29 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"