Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Long with value zero - IGNORE
Please ignore this posting - I was being thick - now worked it out (and
wasn't it easy!) "Risky Dave" wrote: Hi, I have a form that captures user inputted values to text boxes and formats them as numbers ("#,###,###"). These values are converted to numbers (using CLng) and added in a Long variable. This bit works. What I can't figure out is how to handle boxes that are not filled out - which is an acceptable option for my users. I have tried using an If statement to manually enter the value 0 (zero) if the text box is empty (""), but the formatting just ignores it and keeps the content blank (I have checked this by using a message box to display the value held). Can anyone suggest how I can convert a blank to a zero (this information is stored elsewhere in the workbook as well so I would like to be able to manipulate these as zero) in these circumstances? Many thanks. Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
http://CannotDeleteFile.net - Cannot Delete File? Try Long Path ToolFilename is too long? Computer Complaining Your Filename Is Too Long? TheLong Path Tool Can Help While most people can go about their businessblissfully unaware of the Windo | Excel Discussion (Misc queries) | |||
Long Long Long Nested If Function | Excel Discussion (Misc queries) | |||
Interrupting long calculations in Excel? Hi all, I am having a verylong calculation in Excel using VBA. Of course I know I can hit ESC orCTRL+BREAK to interrupt the VBA program. But I found due to too long runningprocess, the Excel window stop to | Excel Programming | |||
Clearing cells takes long, long time | Excel Discussion (Misc queries) | |||
Clearcontents takes long, long, time | Excel Programming |