Forum home » Delegate support and help forum » Microsoft Excel Training and help » Macros

Macros

ResolvedVersion 2003

Fri 15 May 2009, 15:34 Delegate James said...

James has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course
Access Introduction course
Access Intermediate course
Access Advanced course

Macros

what do i enter into into VBE to create a new function?

Mon 18 May 2009, 13:40 Trainer Simon said...

RE: macros

Hi James,

Thank you for your question.

The first thing you would need to do is go into the Visual Basic Editor through Tools and Macro.

Insert a new module and start the code with the following:

Function AddUp (Field1 as Currency, Field2 as currency) as currency

Then define what The function will do:

AddUp =(field1-field2)

End Function

I hope this answers your question.

Regards

Simon

Tue 26 May 2009: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Adding Rows or Columns in an Excel 2010 Worksheet

If you want to add a row to an Excel spreadsheet, these are the simple steps you should take:

With your mouse, right click on the row header below where you want the new row to be added. Then, click Insert.

Follow exactly the same steps if you want to add a column to an Excel worksheet, right click on the column header, choose Insert and the new column will be inserted to the left of the selected column.

View all Excel hints and tips

Macros

Macros

RE: macros

Excel articles

Excel tip:

Adding Rows or Columns in an Excel 2010 Worksheet