ExcelBanter - Number format TextBox?

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Number format TextBox? (https://www.excelbanter.com/excel-discussion-misc-queries/247865-number-format-textbox.html)

Hoyos

Number format TextBox?

How do I number format this code to read ("###0")

..Range("J188") = .Range("J187").Value

Jacob Skaria

Number format TextBox?

..Range("J188") = .Range("J187").Value
..RANGE("J188").NumberFormat = "###0"

'if you want to change the value then
..Range("J188") = Round(.Range("J187").Value)

If this post helps click Yes
---------------
Jacob Skaria

"hoyos" wrote:

How do I number format this code to read ("###0")

.Range("J188") = .Range("J187").Value

Hoyos

Number format TextBox?

Thank you Jacob that will do nicely!!

"Jacob Skaria" wrote:

.Range("J188") = .Range("J187").Value
.RANGE("J188").NumberFormat = "###0"

'if you want to change the value then
.Range("J188") = Round(.Range("J187").Value)

If this post helps click Yes
---------------
Jacob Skaria

"hoyos" wrote:

How do I number format this code to read ("###0")

.Range("J188") = .Range("J187").Value

All times are GMT +1. The time now is 10:27 PM.