Then press CTRL R to open the list of Modules and Forms in VBA project window.To create a VBA form, click on “Insert User Form” icon and select “User Form” option. If Toolbox Window does not open, you may get it from View Menu option.On clicking of submit button you can see data being inserted in excel sheet.
Open a new Excel file and press ALT F11 shortcut key to open Microsoft Visual Basic Editor.
We also describe ‘design patterns’ commonly used in test automation for improving the maintenance and extensibily of your automation suite.
The more experienced reader will find these interesting if not already using these techniques. That depends on aspects of your project: user expectations, time allowed for the project, priorities set by the project manager and so on.
To prevent such instances, you may use data validation.
Data validation may be depending upon individual’s requirement.