Create a VBA macro in sheet

Create a VBA macro in sheet

To create a macro:

  1. Click Tools > VBA Macros > Create. 
  2. The Create Macros menu is displayed.
  3. Name the macro that you wish to create. You can also describe the functioning of the macro. Note that the macro name can only consist of alphabets, numbers and underscore .
  4. You can choose to either record the macro or write the code for macro using VBA editor.

    • Related Articles

    • Run a macro in a sheet

      To run a macro: Click Tools > VBA Macros > Manage > Run the macro you want from the list of macros you've created for the sheet. You can also assign a macro to a button and run the macro just by clicking the button. ​

    • What is a Macro?

      Macros are sequences of actions that you want to automate. You can do this by creating a VBA macro or record a macro. 

    • Record a macro

      To record a macro: Click Tools > VBA Macros > Record. Name the macro and continue recording. Note that the macro name can only consist of alphabets, numbers and underscore characters. Click on the box near Use Relative Reference if you want the cell ...

    • Zoho Sheet

      Zoho Survey's integration with Zoho Sheet helps push your responses from your survey into a spreadsheet as and when your respondents submit their responses. You can map the survey responses into a new spreadsheet or to a new sheet in an existing ...

    • Create a form in Zoho Sheet

      To create a form: 1. Click Tools > Create Form. 2. Enter the Form Title and Description in the Create Form window and click Create. 3. A new sheet for the form results opens.  4. In the success notification that appears, select 'Click Here'. 5. The ...