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