Need a reference

[Chad]

Hey, I am new to Excel programming but I need to use VBA via VB editor for
work. I have looked everywere for a free reference and can't find one. What I
need is a reference containing all the functions/subs that can be used
pretaining directly to excel. For example, what is used to reference a cell
or a row. I know how to code in VB but I am only 23 so I don;t have every
piece of code memorized yet. I hope my question is clear.

Thanks for any help,
Chad

 

[cht13er]

Hey, I am new to Excel programming but I need to use VBA via VB editor for
work. I have looked everywere for a free reference and can't find one. What I
need is a reference containing all the functions/subs that can be used
pretaining directly to excel. For example, what is used to reference a cell
or a row. I know how to code in VB but I am only 23 so I don;t have every
piece of code memorized yet. I hope my question is clear.

Thanks for any help,
Chad

In the Visual Basic Editor (VBE) - hit Alt F11 - use the Library (F2).

You can search, select something, right click it and hit "help" for
examples of how it's used in code!

HTH

Chris

 

[JLGWhiz]

In the VB editor, which is available with all authorized versions of Excel,
click the Help button on the menu bar. When the search panel appears on the
right of the screen, near the top of the panel there is a left and right
arrow. If the Visual Basic Reference Manuals are not already visible, you
can click one of the arrows to make them visible. There should be three
manuals shown there. Those three manuals list almost everything that your
version of Excel will process as VBA. The only free tutorial that was on the
web has been taken over by MicroSoft and is no longer free. There are,
however, numerous sites on the web where you can get free downloads of code
to do various tasks in Excel. Just do a web search when you have a question,
or post on this site for specific problem solving.

 

[Chad]

Sry for the late reply, been a little busy to jump on here and take a look.
Thanks for the help.