Home / Welcome

Welcome


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:


    42 Older Comments
    I am Private  17 Apr 2021 
    Can anybody please help me with an InputBox?
    Mine works in Excel, but not in Zoho sheets.
    My Dogspies  23 Jan 2022 
    Why is the following line giving me an error "Undefined function or value: TRANSPOSE"?
    Range("I4:I15").Value = TRANSPOSE(myArray)
    janegrd  12 Feb 2023 
    I have a Point of sales spreadsheet, I have a macro to and the VBA code is different than excel. The Application command in exel is Application.Run, however in Zoho the .Run option is not available only Range or Row. How can I fix this? " Application.Run "'
    Robert Tupa  24 Feb 2023 
    Is listobject class supported? Will it be? I'm trying to create a macro to add table rows.
    Alejandro Castillo  17 Nov 2023 
    Hi Zoho, is there any support on VBA macros?? this information that you have here is very poor and this doesn't work with normal VBA instructions

    thanks
    Samuel Ponraj P  18 Nov 2023 
    Hello Alejandro Castillo,

    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
    Alejandro Castillo  30 Nov 2023 
    Hi Samuel, one of the problems that I am facing now is that I'm trying to call a "Public Function" from the "Worksheet_Change" ... the function is settled in the Workbook area since I'm trying to use in all sheets, so, I having 2 problems:
    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
    Vinoth Kumar K  06 Dec 2023 
    Hello Alejandro,

    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
    Sudharsan Veluchamy  28 May 2024 
    Hi ZOHO 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
    Krista Woolford  17 Sep 2024 
    Hi ZOHO!

    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.



     RSS of this page