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:
Mine works in Excel, but not in Zoho sheets.
Range("I4:I15").Value = TRANSPOSE(myArray)
thanks
We regret the challenge you come across.
We would like to inform you that we do have VBA Macros support. Please note that our support is limited but we are working on it to enhance the features. We would be in a better position to assist you if you could let us know the macro you wish to have and is not working for further analysis. We will work on the features that you are looking on high priority.
Looking forward to hearing from you.
Best Regards,
Sam | Customer Success Team
1- when I call the function from the Sheet with the instruction with parameters "ThisWorkbook.FunctionName(Parameter)" this show me the error saying that I'm not able to call a procedure with parameters... and then I tried to do it whit-out parameters...
2- when I call the function from the Sheet with the instruction "ThisWorkbook.FunctionName()" this give me an error as well, didn't work...
I tried both in Excel and this work perfectly, so, can you please check this for me?
thank you very much in advance
Thank you for your patience and consideration.
We regret notifying you that the error message is caused by the fact that we do not support calling VBA functions across spreadsheet objects.
We will investigate the possibilities, carefully consider your recommendations, and work to support this. While we don't have a specific timeline of when it will be ready. Your patience will be appreciated.
Best Regards,
Vinoth | Customer Success Team
I need to add the excel add-in file to the zoho spreadsheet and execute the VB application
The Add-in file (.xla) is created in MS-VB with userform and module file to execute
Can you help me to add the add-in file to the spreadsheet custom ribbon and execute the application
I need help finding the option to consolidate data from other sheets into a single field within ZOHO Sheets. It was working in excel, but when I converted over to Sheets, the functionality was gone. I have multiple individual sheets with single user data that I need pulled into one single form for department totals. Any help/guidance would be wonderful. Google searching for this information has yet to provide an answer for what I am needing.