Делаю это так:
>
> .Cells(lngNewLastRow, 6) = Me.TextBox1.Value
> 'Summ
> .Cells(lngNewLastRow, 6).NumberFormat = "#,##0.00"
> 'Formating Summ
> А тут в чем беда?

Не правильный порядок строк :)

Posted via ActualForum NNTP Server 1.4

> НО тут проблема заключается в проверке значения тексбокса на число,
> так например, при дробном разделителе "." функция IsNumeric(me.textbox1)
> выдает ошибку.
> Как с этим бороться?

Использовать Val и наконец-то воспользоватся кнопкой F1 ;)

МСДНFor example, you cannot perform any arithmetic operations on the
value U2 even though it contains a numeric character, because the entire
value is not a valid number. Likewise, you cannot perform any calculations
on the value 1040EZ; however, you can perform calculations on the values +10
or -1.7E6 because they are valid numbers. For this reason, you often want to
determine if a Variant variable contains a value that can be used as a
number. The IsNumeric function performs this task:

Do
anyNumber = InputBox("Enter a number")
Loop Until IsNumeric(anyNumber)
MsgBox "The square root is: " & Sqr(anyNumber)

When Visual Basic converts a representation that is not numeric (such as a
string containing a number) to a numeric value, it uses the Regional
settings (specified in the Windows Control Panel) to interpret the thousands
separator, decimal separator, and currency symbol.

Thus, if the country setting in the Windows Control Panel is set to United
States, Canada, or Australia, these two statements would return true:

IsNumeric("$100")
IsNumeric("1,560.50")

While these two statements would return false:

IsNumeric("DM100")
IsNumeric("1.560,50")

However, the reverse would be the case — the first two would return false
and the second two true — if the country setting in the Windows Control
Panel was set to Germany.

If you assign a Variant containing a number to a string variable or
property, Visual Basic converts the representation of the number to a string
automatically. If you want to explicitly convert a number to a string, use
the CStr function. You can also use the Format function to convert a number
to a string that includes formatting such as currency, thousands separator,
and decimal separator symbols. The Format function automatically uses the
appropriate symbols according to the Regional Settings Properties dialog box
in the Windows Control Panel.

For More Information See "Format Function" and topics about the conversion
functions in the Language Reference. For information on writing code for
applications that will be distributed in foreign markets, see "International
Issues."

МСДНNote The Val function recognizes only the period (.) as a valid
decimal separator. When different decimal separators are used, as in
international applications, use CDbl instead to convert a string to a
number.

Posted via ActualForum NNTP Server 1.4