Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 333
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 638
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Selecting "Save As" adds "Copy of" to file name- MS Excel 2007 ronhansen Excel Discussion (Misc queries) 1 November 15th 09 09:33 PM
"CELL("FILENAME") NOT UPDATE AFTER "SAVE AS" ACTION yossie6 Excel Discussion (Misc queries) 1 June 16th 08 12:16 PM
"Save" and "Save As" options greyed out - "Save as Webpage" option Bill Excel Discussion (Misc queries) 0 January 16th 07 04:47 PM
"Subscript out of range" error for: Workbooks("Test1.xls").Save Just12341234 Excel Programming 2 June 17th 05 03:16 PM
save and restore "Workbook Menu Bar" & "Cell" menus Jeff Higgins Excel Programming 2 February 14th 05 01:33 AM


All times are GMT +1. The time now is 04:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"