VBA Function Reference

[jwt]

This is probably really dumb, but I can't seem to find the VBA funtion
reference for Excel 2007. Has it been renamed, hidden, or am I missing
something obvious?

Thanks.

 

[Rick Rothstein]

Do you mean the VB Help files? The fast way is to right-click a worksheet
tab and select View Code from the popup menu that appears. The more general
solution is to add the Developer tab to your Ribbon. Go to Excel Options
(click the circular icon in the upper left corner of the worksheet, click
the Excel Options button at the bottom of the dialog box that appears)...
select the Popular item in the left-hand list and put a check mark in the
CheckBox labeled "Show Developer tab in the Ribbon". Then you will have a
Visual Basic icon on the Ribbon directly.

 

[jwt]

No, that I got.

I'm looking for the online or help documentation on VBA - a function
reference, for example. Specifically, I was looking for the VBA equivalent of
the Excel Date function and couldn't find the docs in general.

Thanks.

 

[Gary''s Student]

See VBA Help for DateSerial

 

[jwt]

So close!

Thank you so much for the specific answer, here's what's still puzzling.

If I tyoe "dateserial" into the Excel Help search function, it returns a
result in:
Excel Developer Home > Access > Access 2007 Developer Reference > Visual
Basic for Applications Language Reference > Visual Basic Language Reference >
Functions

Moreover, there doesn't seem to be a way to navigate to this information
from Excel Help. How do you get to the Visual Basic for Applications Language
Reference oor Visual Basic Language Reference?

 

[Gary''s Student]

Excel 2007 can supply help online or offline.

If you disable online Help (at the very bottom right-hand corner of the Help
window), you will get the internal help description of the DateSerial()
function. Which is pretty good.

For on-line support, use MSDN:

http://social.msdn.microsoft.com/Search/en-US/?query=dateserial visual basic&ac=1