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

--
Message posted from http://www.ExcelForum.com