Ph: 102189961033

Visual Basic Macros for Spreadsheets

Browse, Contribute and Share Macros!

Navigate Pages | Site Map

Welcome

Sample Macros

User Contributed Macros

Apply Wiki Permissions Custom Permissions Remove Permissions and Make Private

Recently Changed

JP Copy Sheet Data Paste Values Apply Colored Border User Contributed Macros Lightening Colors HighlightÂ LargestÂ Value Paste Values Insert Cells Apply Background Color

Welcome

Tags:

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:

Introduction to VBA VBA Programming Basics VBA Common Objects, Properties and Methods VBA Navigating the Object Model
VBA Arrays

Comments (14) Show recent to old

kdinesh 1189 - days ago

Is it possible to create buttons which run the macros, rather than going to the macros menu?

kdinesh 1189 - days ago

Can I create a Hyperlink in Sheet1 which will take me to Sheet2?

walter_ochynski 1086 - days ago

Is it possible to create functions as with EXCEl VBA?

ajasmine 1081 - days ago

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.

cobyzoho 1042 - days ago

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

ajasmine 1033 - days ago

Currently we are not supporting custom function in Zoho Sheet. We will look to support this in future.

smithscf 954 - days ago

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!

zohosheet 884 - days ago

@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

frazayn 676 - days ago

Is there any chance to copy or move a worksheet from one book to another?

sheet 670 - days ago

Currently we are not supporting copy or move worksheet across Workbooks.

ilumshem 622 - days ago

It would be great to have my macros available not only in the spreadsheet the reside in (eg. paste special - and many more the like which are applicable to every and any sheet around)

me36835 499 - days ago

An excel sheet with a non ascii character in the name like a German Umlaut is not shown in the Macro editor.

adeptyx 472 - days ago

I have 2 requests - this is a good start, but there are some obvious omissions.

First - when will User Defined Functions (UDF's) be ready? This is key to VBA and should be able to be implemented (by Zoho) rather easily. Without UDF's, this VBA is weak.

Second - the VBA editor needs to be improved to allow for multiple modules. Right now the only option is embedding most of the code in the spreadsheets for organizational purposes. I guess that's OK, but it seems like the ability to make multiple modules and rename them would be pretty easy to fix.

colby.kine 465 - days ago

if you want to create a custom function create it and call it in a sub and have that sub put its output in the selected cell you will have to create some way to pass in the data your function needs and call it using the macro menu but it will work if you need to see this in action go to this worksheet..... http://sheet.zoho.com/public/colby.kine/macros

Attachments (9)

RSS of this page

[ http://img.zohostatic.com/wiki/v43_45/images/spacer.gif ]

You are viewing a mobilized version of this site...
View original page here