Integrating Userform and Excel in ArcGIS

Discussion created by amitmhalas on Nov 23, 2011
Latest reply on Jul 29, 2014 by Esox

I am a novice to ArcGIS and VBA. I want to develop a userform in ArcGIS. Using this userform, I want to undertake some energy related calculations. Currently I have an excel sheet which has the necessary formulas.

Now, I want the userform to pass on the values to this excel sheet, do the calculations and return the final results back to ArcGIS.

Can anyone please tell me how to pass values from ArcGIS to excel sheet, undertake calculations?

Many thanks in advance,