Number format TextBox?

  • Thread starter Thread starter hoyos
  • Start date Start date
H

hoyos

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

..Range("J188") = .Range("J187").Value
 
..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
 
Thank you Jacob that will do nicely!!

Jacob Skaria said:
.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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can I simplify a VB code?????? 3
TextBox linked to cell????? 4
Substraction formula 4
I need help with this program written in Visual Basic for Excel 2007. 4
Excel VBA 1
TextBox format? 5
Time format for text box 4
Excel Macro to automatically go to the right of the last colored cell 0

Back
Top