Save Textbox "" value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Karen53 - 25 Sep 2007 21:22 GMT

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,

Signature

Karen

Reply to this Message

JW - 25 Sep 2007 21:34 GMT

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

> Hi,
>
[quoted text clipped - 7 lines]
>
> Karen

Reply to this Message

Karen53 - 25 Sep 2007 22:32 GMT

Thanks, JW.

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

Thanks

Signature

Karen

> Though I have never encountered a problem, I suppose it could be
> adding some type of invisible character. To get around that, you
[quoted text clipped - 12 lines]
> >
> > Karen

Reply to this Message