Starting with Excel-VBA

[anuktac]

Hi,
I have never worked in VBA (though I know VB). But recently I have been given the responsibility of maintaining an Excel application which has been written in VBA. I am having trouble understanding the code, because only way I can see the code is when the application encounters an error, and I press the debug button. Do I need to have Visual Basic installed on my PC?
How does one debug the code?
I am probably asking silly questions....still, if anyone would like to help, would only be too glad.

-Anukta

 

[JustinEzequiel]

from Excel, press Alt-F11
this should open the Visual Basic Editor

Alt-F8 should open the macros dialog box

Alternatives would be Tools-->Macro from the menu bar

I only have Excel 97 here however so YMMV

 

[SQLScholar]

just out of complete curiousity what does "YMMV" mean?

it is an acronym i havent come accross ----------------------------------------
There are 2 types of computer, the prototype and the obsolete!!

 

[JustinEzequiel]

your milage may vary

 

[anuktac]

The problem with this application is, it pops up a lot of msgboxes one after the other, and as long as the msgboxes keep appearing, Alt+F11 does not work.

Also I am getting this error:
Date-format="dd-mmm-yy"
With ActiveSheet.PivotTables("PivotTable1&quot.PivotFields(Column_Field)
.NumberFormat = Date_Format
End With

run time error 1004: Unable to set the numberformat property of the pivot field class.


Any ideas?
-Anukta