ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Formatting textbox in forms control (https://www.excelbanter.com/excel-programming/351981-formatting-textbox-forms-control.html)

Ken Valenti

Formatting textbox in forms control
 
I've created a form (Excel 2003) and have textboxes to collect data.

Some data are numeric. Are there any controls that I can use that will
format numbers, percent, etc?

I've already written code to format, but it is cumbersome.


JWM6[_16_]

Formatting textbox in forms control
 

Dealing with the same thing - seems that a textbox is just a textbox.
Looks like we'll need to format as desired to achieve out format
results for "$" and "%"....


--
JWM6
------------------------------------------------------------------------
JWM6's Profile: http://www.excelforum.com/member.php...o&userid=33413
View this thread: http://www.excelforum.com/showthread...hreadid=506920



All times are GMT +1. The time now is 05:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com