ExcelBanter - VBA syntax

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

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

- - VBA syntax (https://www.excelbanter.com/excel-discussion-misc-queries/46403-vba-syntax.html)

Sunantoro

VBA syntax

If I define Cell B5's Value to be $2000
what is the VB syntax that Cell B5 will now shows "$2000"?
Sorry, this is very basic
Thanks,
SUNAN

Rowan

with cells(5,2)
.value = 2000
.numberformat = "$#,##0"
end with

Hope this helps
Rowan

Sunantoro wrote:
If I define Cell B5's Value to be $2000
what is the VB syntax that Cell B5 will now shows "$2000"?
Sorry, this is very basic
Thanks,
SUNAN

All times are GMT +1. The time now is 09:52 AM.