Create and run a macro
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.
Create a VBA macro
To create a macro:
- Click Tools > VBA Macros > Create.
- The Create Macros menu is displayed.
- Name the macro that you wish to create. You can also describe the functioning of the macro.
- You can choose to either record the macro or write the code for macro using VBA editor.
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 referencing in the macro to be relative (A1, for instance) and not absolute* ($A$1 for instance).
- Make the changes that you wish to be recorded in the macro.
- Click on Stop Recording *image* icon near the notification to stop the process. You can also edit the recorded macro using the VBA editor.
Absolute referencing - The cells are referenced $Column_Number$Cell_Number, meaning the macro is executed in the same cells used when recording the macro.
Relative referencing - The cells are referenced without the "$" constraint, meaning the macro is executed with cells relative from where the macro is executed.
You can choose if you need absolute or relative referencing from the popup indicating that the macro is being recorded too.
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.
Assign macros to a button
To assign macros to a button:
- Click the Advance Options on the top-right corner of the button or right click on the button.
- Select Assign an Existing Macro.
- In the macro list that appears, choose the desired macro and click "Assign".
- To create a new macro select Assign New Macro. You can write or record the macro.
EventsHere are the supported events that you can use while coding your macro.
Workbook Events:
1. Open
2. New Sheet
Sheet Events:
1. Change
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Zoho DataPrep Resources
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
Create a new blank spreadsheet
To create a new blank spreadsheet, open the app and follow these steps: In the listing page, tap the + icon in the bottom bar. Choose the Blank Spreadsheet option from the listed gallery.Create a new spreadsheet
To create a new spreadsheet: 1. Visit the file listing page and tap Blank Spreadsheet.Create a named range
To create a named range: Select the desired cell range. Go to Under the Insert menu, choose Define Name. You can choose to define a cell range, an expression, or a constant value. Enter the desired values and tap Done.Create spreadsheets from templates
To create a new spreadsheet from templates, open the app and follow these steps: In the listing page, tap the + icon in the bottom bar. Simply tap to open the desired template from the default template gallery. You can immediately start editing the ...Create a named range
To create a named range: Select the desired range. Go to the icon. Under the Insert menu, choose Define Name. You can choose to define a cell range, an expression, or a constant value from the drop-down menu. Enter the desired value and tap Done.
New to Zoho LandingPage?
Zoho LandingPage Resources