how to write a VBA function ?

  • Thread starter Thread starter Guest
  • Start date Start date
mansure

I would suggest trooping off the David McRitchie's "getting started with
macros" site and read a while then practice.

Make use of the Macro Recorder under Tools<Macro>Record New Macro.

The code produced will do the trick in most cases. It is not the most elegant
code and you will learn how to refine it by watching these news groups,
especially the excel.programming group.

Tushar Mehta has a site that is useful also.

http://www.tushar-mehta.com/excel/vba/beyond_the_macro_recorder/index.htm

Shows how to use the recoder and make refinements.

Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to export table from outlook into ms access table? 0
Report duplicates 0
VBA code Required to Run the Multiple VBA Codes 6
vba powerpoint pasting named shape in selected named slides 0
Excel VBA 0
Function to calculate number of Wednesdays in time interval 1
How to learn VBA for excel 1
Excel VBA to match positive and negative transactions 3

Back
Top