Save Textbox "" value
 

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

Karen

Save Textbox "" value
 

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
Karen53 wrote:
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,
--

Karen