Function...

Home Search Site Map

Up
Cells...
Chart...
Columns
Comment
Diagram...
Function...
Hyperlink...
Name
Object...
Page Break
Picture
Rows
Symbol...
Worksheet

New! Excel User Group Now Open @ www.excelusergroup.org, Check It Out!


Menu command Type What happens next?
Function... ...

Prepares to insert a function (formula) in the selected cell(s). It first shows the Insert Function dialog, allowing you to select your desired function, like so...

Which after selection and pressing OK, will present you with the 'function builder', as below. This will help in 'assembling' the arguments required for each function. Here it shows a VLOOKUP formula being assembled. Note it shows the 'returned value' for each of the arguments and the expected result (40), shown both below the arguments and at the bottom left of the dialog.

VBA Sub ShowSymbolDialog()
'Displays Insert Function dialog
Application.Dialogs(xlDialogFunctionWizard).Show
End Sub

Top

 

Copyright Nick Hodge 2008. All Rights Reserved.