0If you are New to VBA Macro for Excel Automation, please follow step by step you can automation your Task.
Step First - Enable the Developer Tab (This Tab is only for Macro Development)
Goto -> Options ->Customize Rippon -> Enable "DEVELOPER"
once you're done, you can find additional Tab name called Developer.
Step Two - Record Macro and Shortcut key Creation
In the Developer tab, you have an option called Record Macro. once you clicked that -> you will see another window to give Shortcut Key. (Conditions to follow while giving shortcut key - Shortcut key should not be a Keyboard Short cut keys because using keyboard shortcuts system won't work as expected).
Step Three - Record your Activities
Once we are done with the Shortcut Key Creation System, start to record your actions (Your actions should be only keyboard actions mouse actions will not record)
Important Note: Only Excel Window Keyboard actions record, Keyboard actions can perform whatever we want
Step Four - Stop Recording
We need to stop the recording once we are done with our keyboard actions, in the Developer tab you have an option to STOP (Same button where we select the Record Macro)
Step Five - Run Macro (What we Recorded)
Once we are done with Everything, this is the Output or Final step Press Shortcut key we created while recording.
