Geek Answers Handbook

Excel VBA Macro Documentation

I have an outdated excel spreadsheet that performs many functions with excel macros written in VBA.

Where can I find documentation on what these objects, methods, etc. do?

Something like Microsoft documentation on T-SQL or C # .

For example, I have this code:

With DialogSheets("string") .EditBoxes("otherstring").property End With

Where can I find documentation for the DialogSheet object or the .EditBoxes method?

The object browser inside Microsoft Visual Basic does not even display the returned method types. In this case, it shows

Function EditBoxes ([Index]) as an object. Excel.DialogSheet Member

and the MSDN documentation for the Excel Object Model Reference Does not have a DialogSheet or Excel object.

So where can I find useful documentation?

+6
vba excel-vba excel documentation msdn
source share
1 answer

MSDN has some information about these deprecated objects and their associated properties and methods in the interel interp section. I'm not sure that you will get much more information than you received from the object browser, but it's worth it.

http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.dialogsheet.editboxes%28v=office.11%29.aspx

+2
source share

More articles:


All Articles