This
wiki is intended to serve as a reference site for sharing Visual Basic Macro
Code. You can browse through this site and get the macro code you want. If you
intend to share your macro code with others, you can do that too here. Just
sign in to Zoho and create a new page.
What is a Macro?
A macro is a saved sequence of actions that are stored for later use. Most
of the tasks in a spreadsheet may be performed repeatedly (for example, fetching
live stock data from an external website -> populate the data to a cell range
-> format the data in an aesthetic way -> and, repeat these tasks daily
in a scheduled manner). Macros helps in automating these kind of tasks and accomplishing
them in a single click.
VBA Programming:
Visual Basic for Applications (VBA) is the programming language used to write
macros. For more information on VBA Programming, refer the following external
links:
Is it possible to create buttons which run the macros, rather than going to the macros menu?
Can I create a Hyperlink in Sheet1 which will take me to Sheet2?
Is it possible to create functions as with EXCEl VBA?
Yes, You can create functions and you can call that function in any procedure or other functions. You can't call that function directly from a cell as Excel functions.
As Microsoft points out, Microsoft can't "anticipate every calculation need of every user", nor can Zoho. Therefore, Microsoft provides, and Zoho should too, "the ability to create custom functions".
I can create the custom function in a macro module, as I can in Excel, but you don't seem to want me to execute it. I get an "#Invalid Formula!" error message displayed in the cell.
This is a HUGE, crippling omission, a major error!
-----------------------------------------------------------
Create your own worksheet functions
Although Microsoft Office Excel 2007 includes a multitude of built-in worksheet functions, chances are it doesn’t have a function for every type of calculation you perform. The designers of Excel couldn’t possibly anticipate every calculation need of every user. So instead, Excel 2007 provides you with the ability to create custom functions, which are explained in this article.
http://office.microsoft.com/en-us/excel/HA102189961033.aspx
Currently we are not supporting custom function in Zoho Sheet. We will look to support this in future.
Please support custom functions. Scientists and engineers need a Zoho Sheet program to calculate many types of custom functions, frequently repetitive. Please put it at the top of your list as we really don't need many of the features used in business!!! Otherwise, there is only Excel, which although lacking in so many ways, is still highly useful in engineering education. Thanks!
@kdinesh: we have added support for buttons. Kindly check http://blogs.zoho.com/sheet/new-in-zoho-sheet-insert-buttons-xlsx-support-time-zone-preference