Test Cases plays a vital and very important role in Software and System testing to verify the functionality as per requirements and meets the customer expectations. The traditional approach of test case generation in the testing field is predominantly manual, time consuming, and prone to human error but less expensive. Each tester tends to have their own approach to creating test cases, which may not cover experience-based test scenarios leading to inconsistencies, and lack of standardization. This lack of uniformity can cause testing deficiencies and make it difficult to ensure comprehensive test coverage. The objective is to develop an automation framework to generate standardized, configurable, modular, reusable and human error free test cases as per user defined inputs based on system requirement specifications. The framework proposed in this paper is known as the Automated Test Case Generator tool. This framework is designed using Visual Basic Applications (VBA) Scripts, in which Testcase are generated as per ISO-29119-4 and Functional Safety standard (ISO 26262). VBA is a scripting language used for automating repetitive tasks, creating customized forms, providing an interface where users can write and execute code directly using macros, for reusability, and enhance functionality of test cases. The automation framework is designed to adapt to any product line with minimal changes. This streamlines test case generation process, an efficient, user-friendly solution, promotes consistency, enhances testcase productivity, and provides standardized test cases that are crucial for maintaining high quality product. Through its easy-to-use interface and high degree of customization, this tool offers significant advantages for software development teams, particularly in environments where rapid and consistent testing is essential.