Difference between .text and .value property

K

kedarkulkarni

Hi
recently I was trying to create a userform where I was giving the valu
of text box to a cell. The textbox value was more that 255 chars and
used following method.

range("A25").value = txtUpdate.value
which then I tested I got a result as #Value error in the cell...

I changed the code to
range("A25").value = txtUpdate.text
and it worked....
can somebody tell me the difference between the above 2..
Thanx in advance
Keda
 

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

Difference between .text and .value of a textbox 0
Finding the proper style field and the numbered paragraph value within the style 0
Finding a Value Between Two Numbers and Returning Corresponding Value 12
Difficulty with the property .Value of a Range 13
How calculate a difference btwn 2 TextBox and insert the result inthe appropriate cell 4
VLOOKUP bug? Different answer for values vs calculated table. 2
Show value from one cell in another cell if today falls between a date range 5
Excel Countif Function - Calculating Between Two Sets of Values 3

Top