Save Textbox "" value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a textbox which if the user does not make a change, saves the empty
textbox back to the worksheet. What I am finding is even though the cell is
emply my code is picking it up as having something in it. Does this process
add some kind of invisible character?

Thanks,
 
Though I have never encountered a problem, I suppose it could be
adding some type of invisible character. To get around that, you
could check the length of the textbox and use a If statement to check
and proceed accordingly.
If Len(Me.textBox1.Text)=0 Then Range("I5").ClearContents
 
Thanks, JW.

That is what it is doing. The value comes back as 0 yet the length is 4.


Thanks
--

Karen


JW said:
Though I have never encountered a problem, I suppose it could be
adding some type of invisible character. To get around that, you
could check the length of the textbox and use a If statement to check
and proceed accordingly.
If Len(Me.textBox1.Text)=0 Then Range("I5").ClearContents
Click to expand...
 
Back
Top