Paste Function Dialog Box

  • Thread starter Thread starter comp
  • Start date Start date
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
 
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
 
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
 
Back
Top