ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   vba help (https://www.excelbanter.com/excel-discussion-misc-queries/151423-vba-help.html)

AT

vba help
 
Where can i find a list of functions that vba can do.
I have excel 97 and the help didn't work as it could find any file to load.



Keith74

vba help
 
First port of call would be find whoever has the install disk and
install the help system (the vba help is not always installed).
Failing that, have a nose around MSDN, http://msdn2.microsoft.com/en-gb/default.aspx.

hth

Keith



steve_doc

vba help
 
If you were refering to the excel functions that vba can do ?
Using the vba Object browser search for WorksheetFunction

that will return a list of excel functions that are exposed to vba via the
call
Application.WorksheetFunction.

Note certain functions like left,Right, Len etc are native to vba and do not
require the Application.WorksheetFunction syntax

HTH

"at" wrote:

Where can i find a list of functions that vba can do.
I have excel 97 and the help didn't work as it could find any file to load.




All times are GMT +1. The time now is 11:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com