Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting "Save As" adds "Copy of" to file name- MS Excel 2007 | Excel Discussion (Misc queries) | |||
"CELL("FILENAME") NOT UPDATE AFTER "SAVE AS" ACTION | Excel Discussion (Misc queries) | |||
"Save" and "Save As" options greyed out - "Save as Webpage" option | Excel Discussion (Misc queries) | |||
"Subscript out of range" error for: Workbooks("Test1.xls").Save | Excel Programming | |||
save and restore "Workbook Menu Bar" & "Cell" menus | Excel Programming |