Excel
Macro Builder
Produce powerful macro code using AI based on a simple text input
How To Use Macro Builder
- Step 1: Click the "AI Assistant" tool on the SkySuite ribbon. The AI Assistant chat box will open
- Step 2: From the AI Assistant chat box options, select "Macro Builder"
- Step 3: Enter what your macro will do (e.g., 'hide/unhide column A') and click "Submit"
- Step 4: The code will generate in the box below. Click "Test Code" to test the macro in real time on your workbook. If the code doesn’t perform correctly, adjust the prompt in the input box
- Step 5: If the macro performs correctly, click "Add to Sheet" to add the macro to your Visual Basic Editor, or "Save with button" to do the same and also create a button on your sheet that, when clicked, will execute the code
- Note: In order for your code to save to your workbook, please make sure you save as a macro-enabled workbook (.xlsm)