ExcelBanter - text box 1000's Separators

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - text box 1000's Separators (https://www.excelbanter.com/excel-programming/446633-text-box-1000s-separators.html)

sam99

text box 1000's Separators

Hi,
I have this code I just want to put 1000’s spectators to it how to do that?

TextBox138.Value = Format(CDbl(TextBox135.Value) / CDbl(TextBox86.Value), "0.0000")

Thanx

Claus Busch

text box 1000's Separators

Hi Sam,

Am Sat, 21 Jul 2012 09:39:40 +0000 schrieb sam99:

TextBox138.Value = Format(CDbl(TextBox135.Value) /
CDbl(TextBox86.Value), "0.0000")

try:
With Sheets("Sheet1")
.TextBox138 = Format(CDbl(.TextBox135) / CDbl(.TextBox86), _
"0,00#.00")
End With

Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

All times are GMT +1. The time now is 08:30 PM.