VBA Difference between .text .value .value2

Posted on | Edited on | In

description: difference between .text .value .value2 in Excel

.text

get the screen displayed text

1
2
cells(1,1).text 
'get ##### if the cell width too short

.value

can get formatted Currency and date

1
2
cells(1,1).value 
'get 13/02/2016 12:52 if it is a date

.value2

get underlying value (include empty, string, error, number and boolean)

1
2
cells(1,1).value2 
'get 2342432.12 if it is a date