VBA Function Reference
 

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.

VBA Function Reference
 

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.

--
Rick (MVP - Excel)


"jwt" wrote in message
...
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.

VBA Function Reference
 

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.

"Rick Rothstein" wrote:

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.

--
Rick (MVP - Excel)


"jwt" wrote in message
...
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.

VBA Function Reference
 

See VBA Help for DateSerial
--
Gary''s Student - gsnu200824


"jwt" wrote:

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.

"Rick Rothstein" wrote:

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.

--
Rick (MVP - Excel)


"jwt" wrote in message
...
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.

VBA Function Reference
 

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" wrote:

See VBA Help for DateSerial
--
Gary''s Student - gsnu200824


"jwt" wrote:

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.

"Rick Rothstein" wrote:

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.

--
Rick (MVP - Excel)


"jwt" wrote in message
...
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.

VBA Function Reference
 

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/Sea...l%20basic&ac=1
--
Gary''s Student - gsnu200824


"jwt" wrote:

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" wrote:

See VBA Help for DateSerial
--
Gary''s Student - gsnu200824


"jwt" wrote:

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.

"Rick Rothstein" wrote:

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.

--
Rick (MVP - Excel)


"jwt" wrote in message
...
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.