Question: Can you recommend a tool that converts text-based descriptions into VBA code for Excel?

The first project, Formula Bot, is a full-featured AI-powered data analysis platform that can convert text into a variety of formats, including VBA scripts, to automate spreadsheet tasks. Formula Bot offers tools like an Excel Formula Generator, Text to Excel Converter, and a Data Analyzer that can run complex queries without you having to write any code. The idea is to make data analysis easier and automate repetitive tasks to boost productivity.

Another option is Formula Dog. It's an AI system that converts text instructions into Excel formulas or VBA code so you don't have to wrestle with syntax and formatting. It's got a free trial and several pricing levels, so you can use it as a pro or enthusiast. By automating formula generation, Formula Dog can give you more time for high-priority work.

FormulaGenerator is another option, using fine-tuned GPT models to generate Excel formulas, VBA automations and SQL queries from text prompts. It's got features like error detection, explanations of the generated formulas and a custom AI application service. It's available as a web app and Google Sheets extension, and you can use it as a formula generation and automation tool with a Premium Membership costing $4.99/month.