Av8tordude
Well-known Member
- Joined
- Oct 13, 2007
- Messages
- 1,074
- Office Version
- 2019
- Platform
- Windows
I have 9 columns that I want in accounting format in vba. Is there an efficient way to format numbers in accounting without writing another line of code like below? Or maybe reference the accounting format and apply the reference to the one line?
I tried this but doesn't work.
VBA Code:
Range("H" & LRow) = tbOPrice.Value
Range("H" & LRow).NumberFormat = "_($*#,##0.00_);_($*(#,##0.00);_($*""_""??_);_(@_)"
I tried this but doesn't work.
VBA Code:
Format(Range("H" & LRow) = tbOPrice.Value, "_($*#,##0.00_);_($*(#,##0.00);_($*""_""??_);_(@_)")