Valorx
Fusion
Fusion
  • 👋Introduction
  • Getting Started
    • 🧩What is a Valorx App?
    • 🚀Getting Started with Valorx Fusion
      • Salesforce Setup
      • Connections List
      • Apps List
      • Favorite Apps
      • App Promotion and Provisioning
      • App Administration
      • Valorx Administration
    • 🏫Building your first App
      • Express Mode
      • Express Actions
  • SIDEBAR ADD-IN: EXPRESS
    • 🔍Getting Started
    • ⚡Unlock the Full Potential of Express
  • Design Studio
    • 💡The power of Design Studio
      • 👨‍💼Manage Your Valorx Account
        • Sign Up to Valorx Account
        • Reset Password
        • General Information
        • Active Subscription
        • Environments
        • Users
        • Billing Address
        • Get a Demo
    • 🖥️Open an App in Design Studio
    • 📊Data Modeling
    • 🏳️‍🌈Maps
      • Grid Map
      • Form Map
    • 🎨Tasks
      • Query
      • API
      • Macro
      • Dataset
      • Add/Delete
      • Document
      • Data Import
      • Refresh Ribbon
      • Clear
      • Launch CRM
      • Refresh Map
      • Add Field
    • 🖌️Workflow and UX
      • Workflow Settings - Button Click
      • Workflow Designer
      • Toolbox
      • Common Tasks
      • Utility Tasks
      • Salesforce APIs
      • Query
      • API
      • Launch CRM
      • Macro
      • Dataset
      • Add/Delete
      • Document
      • Refresh Ribbon
      • Clear
      • Refresh Map
      • Add Field
  • Runtime
    • ⏱️Runtime UX
      • Run at App Launch
      • Launch from Salesforce (LFS)
      • App Permissions
    • 🧰Toolbox
    • 🌐Supported Platforms
      • Microsoft Excel for Windows
      • Microsoft Excel for Mac
      • Google Sheet
        • Introduction
        • Getting Started
        • Pop-up Blockers
        • Expected Behaviors
        • Runtime
          • Hot Upgrade
          • Google Sheets Collaboration
          • Insert Row Using Right-Click Options
  • Settings
    • ⚙️Valorx Fusion Settings
    • 🛠️App Settings
    • 📜Logs
  • App Store
    • 📱App Store Submission
    • 💫Installing App
    • 🎮Customizing App
  • Miscellaneous
    • 🛩️Mass Rollout of Valorx
    • 🍭Open Source Licenses
  • Valorx Home
    • 🏠Valorx Home
  • Versions and Release Notes
    • 🪟Windows
      • April 25 Release (V17)
      • Jan 25 Release (V16)
      • Feb 24 Release (V15)
      • Jul 23 Release (V14)
      • Nov 22 Release (V13)
      • Aug 21 Release (V12)
      • Apr 21 Release (V11)
      • Dec 20 Release (V10)
      • Nov 20 Release (V9)
      • Managed Packages
        • Version 2.0
        • Version 1.7
      • Older Versions
        • Aug 20 Release (V8)
        • Jul 20 Release (V7)
        • May 20 Release (v6)
        • Feb 20 Release (V4)
    • 📗Google Sheets
      • February 25 Release (v64)
      • October 24 Release (v63)
      • September 24 Release (v62)
      • August 24 Release (v61)
      • July 24 Release (v59)
      • June 24 Release (v58)
      • Older Versions
        • Jul 23 Release (v57)
        • Apr 23 Release (v56)-Hotfix
        • Apr 23 Release (v55)-Hotfix
        • Mar 23 Release (v54)
        • Mar 23 Release (v53)
        • Feb 23 Release (v52)
        • Jan 23 Release (v51)
        • Oct 22 Release (v50)
        • Jul 22 Release (v49)
        • Mar 22 Release (v47)
        • Feb 22 Release (v46)
        • Dec 21 Release (v45)
    • 🍎Mac
      • March 25 Release (v45.1 - Hotfix)
      • March 25 Release (v45)
      • February 25 Release (v44)
      • January 25 Release (v43)
      • October 24 Release (v42)
      • September 24 Release (v41)
      • August 24 Release (v40)
      • July 24 Release (v38)
      • June 24 Release (v37)
      • Older Versions
        • Feb 24 Release (v32)
        • Dec 23 Release (v31)
        • Oct 23 Release (v30)
        • Aug 23 Release (v27)
        • Jul 23 Release (v26)
        • Apr 23 Release (v25)
        • Mar 23 Release (v24)
        • Jan 23 Release (v23)
        • Nov 22 Release (v22)
        • Oct 22 Release (v21)
        • Sep 22 Release (v20)
        • Jul 22 Release (v19)
        • Apr 22 Release (v18)
        • Dec 21 Release (v17)
        • Nov 21 Release (v16)
        • Sept 23 Release (v28)
Powered by GitBook
On this page
  1. Design Studio
  2. Tasks

Macro

Last updated 1 year ago

Macros are used to record the set of actions, save, run. Macros are used to save time on repetitive tasks when we do not want to do the same task every time. Macros can make wonders and we want you to experience those wonders with our Valorx Fusion.

To get started with this follow the below steps.

Open an Excel, click Start from Valorx Fusion Ribbon.

Follow the instruction provided to view the Developer option on the ribbon. Developer option is used to write macro in Excel

  • Select File from the ribbon and click on Options.

  • Select Customize the Ribbon from Excel Options.

  • Select Developer and click OK.

Developer button will now show up on the Valorx Ribbon.

Open an app and click on Tasks and select Macros now click on New Macro Task. Below validation message will be displayed when there is no macro create on workbook or when Valorx Fusion is unable to access the macro settings. Follow the instruction provided under Information.

To get started with creating a macro follow the below steps.

  • Select Developer from Valorx Fusion Ribbon.

  • Click Macros and a dialog box will open.

Provide the name of the macro under Macro Name and click Create.

Now, write the macro in the provided box. Macro needs to be written between the "Sub" and "End Sub".

Once the macro is created now open a New Macro Task and provide the name of the Macro. Designers can choose the macros from Available Macros. Macro Task allows Valorx Fusion App to execute VBA hosted in the Excel file.

Designers also can record the macro by clicking on Record Macro.

🎨