Data Processing

VBA Code Formatter

Format and beautify VBA code for better readability

text· Text resultOpen tool

Quick start

Call this tool from your code in three languages.

cURL

curl -X POST 'https://api.elysiatools.com/en/api/tools/vba-formatter' \
  -H 'Content-Type: application/json' \
  -d '{"code":"Enter your VBA code here...","indentSize":4,"convertKeywords":true,"addLineNumbers":false,"removeComments":false}'

API reference

Send a POST request with your inputs as JSON. File parameters require a separate upload first.

Endpoint

HTTP

POST https://api.elysiatools.com/en/api/tools/vba-formatter

Parameters

Name	Type	Required	Description
code	textarea	Yes	—
indentSize	number	No	—
convertKeywords	checkbox	No	—
addLineNumbers	checkbox	No	—
removeComments	checkbox	No	—

Response format

MCP integration

Add this tool to your Model Context Protocol server so AI agents can list and call it.

Server configuration

Add this block to your MCP client configuration:

mcp.json

{
  "mcpServers": {
    "elysiatools-vba-formatter": {
      "name": "vba-formatter",
      "description": "Format and beautify VBA code for better readability",
      "baseUrl": "https://api.elysiatools.com/mcp/sse?toolId=vba-formatter",
      "command": "",
      "args": [],
      "env": {},
      "isActive": true,
      "type": "sse"
    }
  }
}

List available tools

After connecting to the SSE endpoint, list the exposed tools:

tools/list

{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/list"
}

Call this tool

Invoke the tool by its id, passing arguments built from its parameters:

tools/call

{
  "jsonrpc": "2.0",
  "id": 2,
  "method": "tools/call",
  "params": {
    "name": "vba-formatter",
    "arguments": {
  "code": "Enter your VBA code here...",
  "indentSize": 4,
  "convertKeywords": true,
  "addLineNumbers": false,
  "removeComments": false
}
  }
}

Chain multiple tools in one session with a comma-separated toolId list, e.g. /mcp/sse?toolId=png-to-webp,jpg-to-webp,gif-to-webp (max 20).

Questions or issues? Contact [email protected]

Browse tools Open tool

curl -X POST 'https://api.elysiatools.com/en/api/tools/vba-formatter' \ -H 'Content-Type: application/json' \ -d '{"code":"Enter your VBA code here...","indentSize":4,"convertKeywords":true,"addLineNumbers":false,"removeComments":false}'

Name

Type

Required

Description

code

textarea

Yes

—

indentSize

number

—

convertKeywords

checkbox

—

addLineNumbers

checkbox

—

removeComments

checkbox

—

{ "mcpServers": { "elysiatools-vba-formatter": { "name": "vba-formatter", "description": "Format and beautify VBA code for better readability", "baseUrl": "https://api.elysiatools.com/mcp/sse?toolId=vba-formatter", "command": "", "args": [], "env": {}, "isActive": true, "type": "sse" } } }

{ "jsonrpc": "2.0", "id": 2, "method": "tools/call", "params": { "name": "vba-formatter", "arguments": { "code": "Enter your VBA code here...", "indentSize": 4, "convertKeywords": true, "addLineNumbers": false, "removeComments": false } } }