topic Calculate Field VBA Statement If...Then...Else Error in Geoprocessing Questions https://community.esri.com/t5/geoprocessing-questions/calculate-field-vba-statement-if-then-else-error/m-p/752097#M24624 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I am not able to use an If Then Else function in my field calculator.</SPAN><BR /><SPAN>I've looked up loads of discussions on this forum and tried several options.</SPAN><BR /><SPAN>Even a basic function will not work.</SPAN><BR /><SPAN>Am I doing something wrong, do I have a version of AG that doesn't support this anymore or is there something else?</SPAN><BR /><BR /><SPAN>I'm using Arcmap 10 service pack 2 and trying the next function in my field calculator:</SPAN><BR /><BR /><SPAN style="font-style:italic;">Pre logic script code:</SPAN><BR /><SPAN>Dim output as Double</SPAN><BR /><BR /><SPAN>If [OBJECTID]=2 Then</SPAN><BR /><SPAN>output = 565 </SPAN><BR /><SPAN>Else</SPAN><BR /><SPAN>output = 6</SPAN><BR /><SPAN>End If</SPAN><BR /><BR /><SPAN style="font-style:italic;">Field value:</SPAN><BR /><SPAN>output</SPAN><BR /><BR /><BR /><SPAN>Error code 999999 -&gt; so that's not very helpfull...</SPAN><BR /><BR /><SPAN>Anyone an idea?</SPAN><BR /><SPAN>Thanks!</SPAN><BR /><SPAN>Roy</SPAN></BODY></HTML> Wed, 16 Nov 2011 10:39:09 GMT RoyMol 2011-11-16T10:39:09Z Calculate Field VBA Statement If...Then...Else Error https://community.esri.com/t5/geoprocessing-questions/calculate-field-vba-statement-if-then-else-error/m-p/752097#M24624 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I am not able to use an If Then Else function in my field calculator.</SPAN><BR /><SPAN>I've looked up loads of discussions on this forum and tried several options.</SPAN><BR /><SPAN>Even a basic function will not work.</SPAN><BR /><SPAN>Am I doing something wrong, do I have a version of AG that doesn't support this anymore or is there something else?</SPAN><BR /><BR /><SPAN>I'm using Arcmap 10 service pack 2 and trying the next function in my field calculator:</SPAN><BR /><BR /><SPAN style="font-style:italic;">Pre logic script code:</SPAN><BR /><SPAN>Dim output as Double</SPAN><BR /><BR /><SPAN>If [OBJECTID]=2 Then</SPAN><BR /><SPAN>output = 565 </SPAN><BR /><SPAN>Else</SPAN><BR /><SPAN>output = 6</SPAN><BR /><SPAN>End If</SPAN><BR /><BR /><SPAN style="font-style:italic;">Field value:</SPAN><BR /><SPAN>output</SPAN><BR /><BR /><BR /><SPAN>Error code 999999 -&gt; so that's not very helpfull...</SPAN><BR /><BR /><SPAN>Anyone an idea?</SPAN><BR /><SPAN>Thanks!</SPAN><BR /><SPAN>Roy</SPAN></BODY></HTML> Wed, 16 Nov 2011 10:39:09 GMT https://community.esri.com/t5/geoprocessing-questions/calculate-field-vba-statement-if-then-else-error/m-p/752097#M24624 RoyMol 2011-11-16T10:39:09Z Re: Calculate Field VBA Statement If...Then...Else Error https://community.esri.com/t5/geoprocessing-questions/calculate-field-vba-statement-if-then-else-error/m-p/752098#M24625 <HTML><HEAD></HEAD><BODY><SPAN>Remove the "as Double" from the dim statement.</SPAN></BODY></HTML> Wed, 16 Nov 2011 13:00:16 GMT https://community.esri.com/t5/geoprocessing-questions/calculate-field-vba-statement-if-then-else-error/m-p/752098#M24625 KenBuja 2011-11-16T13:00:16Z