| new topic post reply | Tech Patterns Forum Index ==> Consumer Software :: Graphics, Utilities, Office, Media |
| Back to top |
I am working on a MS Word form.
I have several lines in a table that are calculations (column1 * column2 = column3). The value fields (column1 and column2) will remain blank unless there are values entered into them. But the calculation field (column3) will always show "0.00" if there are no values in the two value fields (column1 and column2). What I want is for the calculation field (column3) to show blank if there is no value in it. There is no option for a default 'blank' value in a calculation field. I am thinking about writing a macro that would delete or otherwise 'blank' out this field if there is no value to be displayed in it. Unfortunately, although I program in 8 different high level languages I am a novice in VBA (which I believe is the word macro language). How can I go about 'blanking these fields? Any help would be greatly appreciated. Thanks. |
|
All times are GMT - 8 Hours |
|
Contact Us
Hosting: Pair Networks: 0.045
Forum Software © 2001–2009 phpBB
techForum Style © 2003–2009 techpatterns.com
info
Hosting: Pair Networks: 0.045
Forum Software © 2001–2009 phpBB
techForum Style © 2003–2009 techpatterns.com
info