Paste Function Dialog Box

C

comp

I have been using Excel (2000) for a long time, but only to
store lists of data. Never have a need to do anything
beyond sorting information. Now I need to learn VBA to
turn a cost spreadsheet to a Business Case Analysis tool. I
have been reading the Book by John Walkenbach on Excel 2000
Formulas. In one of the chapters, he mentioned "Paste
Function Dialog Box" of which I have no idea what it is and
how to activate it. Any help is appreciated.

Thanks,
pac
 
O

Otto Moehrbach

Pac
I think that is the dialog box that is called Insert Function in my
2002. That is not a VBA tool, just a worksheet tool.
Look just above the column letters of a worksheet and find a script "F"
with a small "x" after it. Like the "function of x" we were all taught in
algebra classes. Click on it.
That is used to access all the Excel formulas. HTH Otto
 
C

comp

Otto said:
Pac
I think that is the dialog box that is called Insert
Function in my
2002. That is not a VBA tool, just a worksheet tool.
Look just above the column letters of a worksheet and
find a
script "F" with a small "x" after it. Like the "function
of x" we
were all taught in algebra classes. Click on it.
Click to expand...

Cool!
Thanks, you are right. I found it.
Excel has lots of tricks up its sleves that never fail to
amaze me.
I have been a long time "address book" type user. It is now
the time for me to start rocking!

pac
 
Top