Text vs Value

[NorthbyNorthwest]

Hi, everyone. I created a workbook that mostly transfers information from a data entry form to rows in a worksheet. The workbook also performs a two or three vlookups. I referenced cell ranges with “.value.” Is this OK? I noticed that the “.value” does not capitalizes to “.Value.” But when I use “.text” it capitalizes to “.Text.” Does this mean I should be using “.text.” I ask because the workbook seems to perform OK with “.value.” I would like to understand what is correct. I never noticed this earlier coding. Wondering if I’m overthinking.

 

[Michael M]

If it's working OK, you might be overthinking it....but if you post the code someone will have a look to see if there any issues

 

[JoeMo]

Range.Text is a read-only property. It cannot be used to change the value of a cell. It returns what you see in the cell whereas for non-formulaic cells, .Value returns what you see in the formula bar and can be used to change the value in a cell. For example, if you enter 10000 in a cell and format it as currency with two decimal places, when you look at the cell it shows $10,000.00 (the .Text property), while the formula bar shows 10000 (the .Value property). For VLookups I would use .Value.

EDIT: Actually for the example I used (currency) I would choose the Value2 property.

 

[NorthbyNorthwest]

If it's working OK, you might be overthinking it....but if you post the code someone will have a look to see if there any issues

Thanks for responding so quickly. I think I just needed reassurance. Sometimes a little thing can rattle me.

 

[NorthbyNorthwest]

Range.Text is a read-only property. It cannot be used to change the value of a cell. It returns what you see in the cell whereas for non-formulaic cells, .Value returns what you see in the formula bar and can be used to change the value in a cell. For example, if you enter 10000 in a cell and format it as currency with two decimal places, when you look at the cell it shows $10,000.00 (the .Text property), while the formula bar shows 10000 (the .Value property). For VLookups I would use .Value.

EDIT: Actually for the example I used (currency) I would choose the Value2 property.

Thanks JoeMo for explaining the difference between the properties. In reviewing my code I found two textboxes in which I was in some instances referencing them as .text and other instances .value. Your explanation helped know which to use. My thanks again to both you and Michael.

 

[Michael M]

Glad we could help.
I think @JoeMo provided sufficient insight into your issue..

 

[Fluff]

I noticed that the “.value” does not capitalizes to “.Value.” But when I use “.text” it capitalizes to “.Text.”

That is probably because you have (at some point) created a variable or procedure called value, which will affect the capitalisation.