Skip to content

Test Runner

The Test Runner is your rapid prototyping and debugging cockpit. It allows you to execute any function or subroutine from your compiled bytecode in a sterile environment, ensuring your logic is flawless before you ever touch a spreadsheet or document.

VBA Padlock Studio Test Runner dialog for debugging functions

🛠️ Isolated Execution

Section titled “🛠️ Isolated Execution”

Testing in VBA Padlock Studio is significantly faster than testing in Office because it bypasses the application overhead.

  • Routine Browser: A hierarchical list of every public and private function available in your compiled modules. Select any routine to target it for testing.
  • Live Parameter Entry: Pass values to your functions in real-time. The Test Runner supports all standard VBA data types.
  • Result Persistence: The right pane displays return values, execution time, and any console output in a high-contrast, developer-friendly terminal.

⌨️ Parameter Syntax

Section titled “⌨️ Parameter Syntax”

Pass multiple arguments to your routines using a simple comma-separated format:

Data TypeInput ExampleNotes
Numeric42, 3.1415Supports integers and floating points.
String"VBA Padlock"Wrap text in double quotes.
BooleanTrue, FalseCase-insensitive logical values.
Mixed101, "Admin", TrueSeparate multiple arguments with commas.

🔄 The Debugging Loop

Section titled “🔄 The Debugging Loop”
  1. Launch: Press Ctrl+F6 to open the Test Runner.
  2. Select: Pick the function you just finished writing in the Code Editor.
  3. Input: Provide test data in the parameter field.
  4. Execute: Click Run or press F5 again.
  5. Verify: Inspect the return value to ensure your business logic is correct.

See Also

Section titled “See Also”