Test Cases play a vital and very important role in the Software and System testing field to verify the functionality as per requirements and meet 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, experience-based test scenarios might not be covered 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 study 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 the 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 products. Through its easy-to-use interface and high degree of customization, this tool provides major benefits for software development teams, particularly in environments where rapid and consistent testing is essential.