Difference between .text and .value of a textbox

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..


How to make sure a user is entering a plain text value instead o
formula in a textbox...

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

copy text from textbox to another application 3
format label text 5
Finding a Value Between Two Numbers and Returning Corresponding Value 10
centering text on textbox 4
TextBox change issue 1
TextBox Change/Exit problem 3
Date showing as numbers in Textbox on Userform 2
Pasted text will not spell check 5

Top